Skip to Content
0
Former Member
Jan 26, 2010 at 08:37 AM

Query / FMS on G/L Account field

38 Views

Hi Experts,

Can you help me out on my query / FMS:

Definitions:

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.

Don