Item group on A/R invoice Row Level

This question is answered

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

Correct Answer

October 10, 2015 at 06:51 AM

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.

0 Likes 0 View this answer in context

Helpful Answer