Skip to Content
0
Feb 11, 2011 at 01:12 PM

PCH1 Query

65 Views

Hi

Is there a possibility of doing the following:

When selecting a specific GL Account (701120) on Row Level of an AP Invoice (PCH1) it will automatically update the Project field to (Regional = Code 100014).

I created the following query then did a FMS but not working:

SELECT CASE CODE

WHEN '701120' THEN '100014'

ELSE NULL END AS Project

FROM OPRJ

WHERE CODE = $[PCH1.AcctCode]

Any help will be much appreciated

Regards

Kurt Walters