Blocking of Sales Order thru SP Transaction Notification

4 months ago 18

Hi Experts,

Im astir to artifact Sales Order thru SP Notification, I Create a elemental codification to cheque if the lawsuit has Open Invoices successful the AR Module and if it does, it volition artifact the income bid for that peculiar bid unless the AR Document of the erstwhile transaction is closed present is my code.

IF(@object_type = '17') and (@transaction_type successful ('A', 'U')) BEGIN IF Exists (SELECT T0.CardCode FROM OINV T0 WHERE T0.DocEntry = @List_of_cols_val_tab_del AND T0.[DocStatus] = 'O' AND T0.CANCELED='N' ) BEGIN SET @error = 1001 SET @error_message = 'You person Pending AR invoice Open, Please Settle Customer Account. Thank you!' End End

Apparently the codification artifact Sales Order for each Customers adjacent they dont person AR Invoice Open Documents.

what you deliberation is the problem? anyone tin assistance me? 

Read Entire Article