Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Stored Procedure for AP Invoice (Service) Based on PO

Dear All,

I have below Store Procedure for Blocking Purchase Invoice not based on Purchase Order.

IF @transaction_type IN ('A','U') AND @object_type = '18'and @error = 0

BEGIN

IF EXISTS (SELECT T0.DocNum FROM OPCH T0 INNER JOIN PCH1 T1 on T1.DocEntry=T0.DocEntry WHERE T1.[BaseType] <> '22'

AND T0.DOCENTRY = @list_of_cols_val_tab_del)

BEGIN

SELECT @Error = 15, @error_message = 'Cannot Add Document without Purchase Order'

END

End

I would like to add additional criteria for blocking if the AP Invoice Amount Exceed the Open Amount in the PO.

Kind Regards

Raju Parmar

Not what you were looking for? View more on this topic or Ask a question