Blocking

[Former Member]

Hi All,

This issue has not been resolved in our SBO system. we can't prevent user to add good receipt PO without copy from PO. I mean the user should only make good receipt if it based on a PO. How to prevent good receipt PO posting if there is no PO number as a base document ? I would appreciate if it is store procedure since our FMS and UDF are so many used now. Pls give advice. TIA

Rajh

[former_member583013 · Accepted solution]

Rajh,

Use this in your SBO_SP_TransactionNotification

IF @transaction_type = 'A' AND @object_type = '20'

BEGIN

IF EXISTS (SELECT T0.ItemCode FROM [dbo\].[PDN1\] T0

WHERE T0.BaseType = -1 AND T0.DocEntry = @list_of_cols_val_tab_del

BEGIN

SELECT @Error = 1, @error_message = 'Goods Receipt not based on PO'

END

END

Suda

[Former Member · Accepted solution]

Tks for your answer and I will return for a result.

Rajh