Can you help me out on my query / FMS:
1. I created a UDF in Customer Master data: SALES_ACCT_BIR (Alphanumeric,12), ex. 4111-02-1-00
2. I created a UDF in Marketing header: TAX (Alphanumeric, 12, valid values: YES & NO)
3. I assigned my query below in the A/R Invoice GL account (Sales acct) field, refresh when Sales Employee is altered and Tax status = YES
SELECT T0.U_SALES_ACCT_BIR FROM OCRD T0 WHERE T0.OCRD.CARDCODE = $[OINV.CARDCODE] AND $[OINV.TAX] = 'YES'
Purpose: I want to override the GL (Sales) account default when the Tax status is set to YES.
But it seems not working right now, I wonder if this has something to do with the format of my OCRD UDF or for any other reasons.
Hope you could help me out. Thanks.