Skip to Content
0

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

Apr 10 at 10:18 AM

8

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers