SP_Transaction Notification for Receipt from Production !!!
Can anybody help me with Stored Procedure. On batch setup window when we perform report completion from production order to receipt from production and when we add batches we have 2 field called say A and B. What I request is when this 2 field data is not same then system should throw error message when adding.
For ex: On batch setup window field A = 425 and field B = 430 then system should throw error message and do not allow to add document(receipt from Production).
Request to please advise me the stored procedure for this please.
Please find attached image for better understanding.
Appreciate for quick solution.
Nagarajan K replied
IF @transaction_type in ('A') AND (@OBJECT_TYPE='10000044')
If exists (SELECT t0.AbsEntry FROM OBTN T0 WHERE T0.A <> T0.B AND
t0.AbsEntry = @list_of_cols_val_tab_del)
SET @error = 1
SET @error_message = 'A & B value should be same'
Thanks & Regards,