on 04-13-2016 10:58 AM
Hi,
For the purpose of an external application I need to have following information in Item Master Data UDF. The UDF is [U_StockStatus] in OITM table.
If stock status is 0 then value 0
If stock status is greater than 0 then value 1
Something like in following query:
SELECT CASE WHEN T1.[OnHand] <= 0 THEN '0' ELSE '1' END FROM OITM T0 INNER JOIN OITW T1 ON T0.[ItemCode] = T1.[ItemCode] WHERE T1.[WhsCode] = '01'
My question is:
Is it possible to achieve it by Stored Procedure to set automatically mentioned values in [U_StockStatus] field when [OnHand] field from OITW changes.
If Yes
What code should I insert to SBO_SP_TransactionNotification ?
Regards
Wojtek
Hi
It is not advised to update the OITM UDF field with the SP.
Rgds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Have you tried with FMS instead of SP?
Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.