PCH1 Query

[former_member282786]

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

[Former Member · Accepted solution]

Hi Kurt.....

Try this.....

Declare @Code as nvarchar (100)
Set @Code=$[PCH1.AcctCode.0]
Begin
If @Code='701120'
Select '100014'
End

Apply above FMS in Project field of PCH1......

Regards,

Rahul

[former_member282786 · Accepted solution]

Hi Rahul

This works perfect, thanks very much for the quick and correct reply, it is much appreciated.

Regards

Kurt Walters