Item group on A/R invoice Row Level

[Former Member]

Hello Everyone !!!

How to display Item Group in A/R Invoice on Row level. For Ex. Along with Item Code and Item Description I want to display Item Group as well.

Is there any possibility. please advise.

Thanks,

Harshal Makwana

[kothandaraman_nagarajan · Accepted solution]

Hi,

Yes possible by FMS. Run below query and refresh when item code changes.

SELECT T1.[ItmsGrpNam] FROM OITM T0  INNER JOIN OITB T1 ON T0.[ItmsGrpCod] = T1.[ItmsGrpCod] WHERE T0.[ItemCode] = $[$38.1.0]

Thanks.

[former_member211473]

Hi

Select distinct and

Apply join on t1.itemcode = t2.itemcode where t2.itemcode = $[inv1.itemcode]

[ashish_shah6]

Hi Harshal,

Create UDF (Item Group) at Row Level in Marketing Documents. and put FMS in A/R Invoice Row level UDF(Item Group) as below :

SELECT TOP 1 T0.[ItmsGrpNam] FROM OITB T0  INNER JOIN OITM T1 ON T0.[ItmsGrpCod] = T1.[ItmsGrpCod] INNER JOIN INV1 T2 ON T1.[ItemCode] = $[INV1.ItemCode.38.1]

please mark auto refresh on Item Code.

Regards,

Ashish Shah