FMS query on A/R invoice

[Former Member]

hi experts,

I was looking for some help on how to create the query to pull data from BP contact UDF (U_AR) to display in a UDF on an AR invoice for that customer (U_ARCON). Basically we are looking to populate how the invoice is to be recieved by customer (Email, Fax, Mail) when an invoice is created so the right method of delivery is choosen for that customer.

gord

[Former Member]

Gordon,

I get this message

1). [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near '$4.0.0'. 2). [Microsoft][SQL Native Client][SQL Server]Statement 'Received Alerts' (OAIB) (s) could not be prepared.

sincerely,

gord

[Former Member]

This query can not run directly. You have to assign it on the UDF.

Updated to use BP Contact table.

SELECT T0.U_AR FROM dbo.OCPR T0

WHERE T0.CardCode = $[$4.0.0\]

[Former Member]

Hi Gord,

Welcome you post on the forum.

Try this:

SELECT T0.U_AR FROM dbo.OCRD T0

WHERE T0.CardCode = $[$4.0.0\]

Thanks,

Gordon