on 05-21-2019 12:41 PM
Hello Experts,
I will like to know if there was a way SAP Business one SBO_SP_TransactionNotification query will be able to validate concurrent transactions for sales order which will be checking the available qty in stocks before it is added.
Below is the query I have but I do not know how it will check real-time the available stocks for users as they raise orders concurrently.
If @object_type ='17' and @transaction_type in ('A','U') BEGIN If EXISTS(SELECT T1.DocEntry FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OITW T3 ON T2.ItemCode = T3.ItemCode where T1.WhsCode = T3.WhsCode AND T2.InvntItem = 'Y' and T1.Quantity > (T3.OnHand - T3.IsCommited) and T1.DocEntry = @list_of_cols_val_tab_del ) Begin SET @error = 17 SET @error_message = N'Stock is low' End END
Any ideas on how to achieve my aim?
Regards,
Justice Doku
I did that too, but how will the FMS refresh in real-time when the available stock changes when multiple people are doing the same Sales Order transaction?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Try to create to FMS to calculate available quantity. Call this field in above transaction notification to block transaction in stock is low.
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.