Skip to Content

How to block the Non relevant budget account using SP_transaction in AP invoice?

Hi experts,

How to block the GLaccount in AP invoice which has no budget ?

This is my query but not working.

IF @transaction_type In ( 'A' ,'U') AND @object_type = '18'

begin

BEGIN

IF EXISTS(SELECT T0.ACCTCODE FROM PCH1 T0 INNER JOIN OPCH T1 ON T0.DOCENTRY=T1.DOCENTRY WHERE T1.DOCENTRY=@list_of_cols_val_tab_del AND T0.ACCTCODE IN (select acctcode from OACT WHERE BUDGET='N') )

BEGIN

SET @Error = 18

SET @error_message = 'Budget Not defined for the Account'

END

END

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers