Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Althea ADS Profile Picture
    Althea ADS 445 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!

  • 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

  • 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.

  • 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

    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

    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?

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans