FMS Query in A/r Invoice

[ramco1917]

Hi

I want in A/r Invoice when item is 10021 then G/l Account should be 81302

Thanks

[silambarasan_rajendran · Accepted solution]

Hi,

FMS may not work sometime GL Account may change after choosing whs,..

Better apply set G/L Account By - Item Level and map the gl account in the item master itself

or

you can do set rules Item as parameter in the advanced GL determination.

Thanks & Regards,

silambu

[shahbaz_akbar]

HANA Syntax:

IF $[INV1.ItemCode] = '10021' then SELECT '81302' FROM DUMMY;

SQL Syntax:

IF $[INV1.ItemCode] = '10021'

SELECT '81302'