Item group on A/R invoice Row Level
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
Tags:
Nagarajan K replied
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.