web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Printing both Customer...
Microsoft Dynamics GP (Archived)

Printing both Customer Item Number and Item Number on SOP Documents

(0) ShareShare
ReportReport
Posted on by Thomas Dillon 80

Hello all,

I was wondering if there was a way to print both the customer item number (if applicable) and item number on SOP reports (invoices and packing slips mainly) in GP 2013. I tried adding the field to the report writer per this article, and added the fields via Template Maintenance, but when i print documents the item number becomes blank in both sections. Several of our customers require both their item number and ours to appear on their packing slips. Any help on this would be greatly appreciated. Thanks so much!

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Printing both Customer Item Number and Item Number on SOP Documents

    Did you add the customer item number before your item number?  Is it possible you did not allow enough room and the blanks at the end of the customer Item Number are overprinting your item number?

  • Thomas Dillon Profile Picture
    Thomas Dillon 80 on at
    RE: Printing both Customer Item Number and Item Number on SOP Documents

    Customer item numbers were added after item numbers. I assigned 15 characters to both the customer item field and item number field via the Template maintenance on the modified Word template.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Printing both Customer Item Number and Item Number on SOP Documents

    The customer Item number is longer than 15 characters, I think they are 25 or 30 characters.

  • Thomas Dillon Profile Picture
    Thomas Dillon 80 on at
    RE: Printing both Customer Item Number and Item Number on SOP Documents

    I changed the field to 30 characters but the field is still blank when I print. I should note that the item number populates (either with the item number or customer item number if i select that option), but the customer item field is always blank either way. Ideally, both would print.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Printing both Customer Item Number and Item Number on SOP Documents

    The Customer Item Number is in the Sales Customer Item Cross Reference table SOP60300. You need to create a relationship that would be includible in the report. This is a one to many relationship with the item master. My cursory inspection of the Report Writer report definition looks like it would be very difficult (if even possible) to create that relationship without some VBA magic.

    Do you have the Modifier/VBA module?

    kind regards,

    Leslie

  • Althea ADS Profile Picture
    Althea ADS 10 on at
    RE: Printing both Customer Item Number and Item Number on SOP Documents

    I am having a similar issue (GP2016) where I created this customized field and brought the standard GP form xml into the template and added this field.  I 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 item number twice.  We can't have that.  Tried changing the GP report writer field to hide when empty but the Word template ignores that.  They really need both on the SOP Blank Invoice, but not duplicates if empty.  Any help is greatly appreciated!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans