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