on 04-10-2018 11:18 AM
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
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.