Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Need both Customer Ite...

Need both Customer Item and GP Item number to print on SOP invoice, but only GP item number if no Customer item setup

(0) Share

Report

Posted on by Althea ADS

We are having an issue with GP2016 where we created the customized field per the MSFT article on “How to add the “Customer Item Number” field to a quote, order or invoice form in SOP in MSFT GP” and brought the standard GP form xml into the Word template and added this field. We do get it to print both the item number AND the customer item number, but the problem is if the customer does not have a customer item number, it prints the GP item number twice. They cannot have that. We tried changing the GP report writer field to hide when empty but the Word template ignores that. They require both on the SOP Blank Invoice, but not duplicates if it’s empty. Any help is greatly appreciated!

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

iruser2 2,048 on at

Like (0)

Report

RE: Need both Customer Item and GP Item number to print on SOP invoice, but only GP item number if no Customer item setup

you will have to make a conditional field that compares the calculated field to the item number field and if different get the calculated field, else get a blank. Put the conditional field onto your reports.