Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SOP Blank Packing Slip...
Microsoft Dynamics GP (Archived)

SOP Blank Packing Slip Form - Add Vendor's Item Number

(0) ShareShare
ReportReport
Posted on by Don L 740

Using GP 2010, SP 3 - I am attempting to add the Vendor's Item Number to the SOP Blank Packing Slip Form.

Using Report Writer, I open the SOP Blank Packing Sip Form and select the Tables button. The following Relationships are shown:

01. Sales Document Header Temp

02. -Sales Transaction Work

03. --Customer Master Address File

04. --Sales User-Defined Work History

05. -Sales Document Line Temp*

06. --Sales Transaction Amounts Work*

07. ---Sales Line Comment Work and History

08. ---Sales Serial/Lot Work and History*

I add additional tables...for Item Master and Item Quantity Master as shown below.

01. Sales Document Header Temp

02. -Sales Transaction Work

03. --Customer Master Address File

04. --Sales User-Defined Work History

05. -Sales Document Line Temp*

06. --Sales Transaction Amounts Work*

07. ---Sales Line Comment Work and History

08. ---Item Master

09. ---Item Quantity Master

10. ---Sales Serial/Lot Work and History*

Here is the problem...I would like to add the Item Vendor Master table, but it is not available when I double click on the Item Quantity Master table (this does work on GP 2013). My goal is to have the following table relationships.

01. Sales Document Header Temp

02. -Sales Transaction Work

03. --Customer Master Address File

04. --Sales User-Defined Work History

05. -Sales Document Line Temp*

06. --Sales Transaction Amounts Work*

07. ---Sales Line Comment Work and History

08. ---Item Master

09. ---Item Quantity Master

10. ----Item Vendor Master

11. ---Sales Serial/Lot Work and History*

Any thoughts on how to include this in GP 2010?

Thank you!

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    Very cool!  I didn't know you could use non-conforming relationships via editing the package file...interesting.  You  see, Report Writer used to allow this, and then they took away our ability to do it through the UI because too many folks were complaining about RW yielding incorrect reports. We had a dex.ini switch we could use for awhile, but they took that away too.

    So, it looks like we can do it again!  Wow, the possibilities.  Thanks for checking back in, I can hardly wait to try it!

    Kind regards,

    Leslie

  • Don L Profile Picture
    Don L 740 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    I was preparing the details for the VBA suggestion when I thought, let's try importing my SOP Packing Slip from GP 2010 into GP 2013. I then created the desired relationship to the Item Vendor Master table and exported the package. I then imported the package into the GP 2010 dictionary and it worked!

    Just thought I'd let you know it is possible.

    Thanks again.

  • Don L Profile Picture
    Don L 740 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    My thanks to all for taking the time to respond to my question.

    I would like to conclude by saying Report Writer for GP 2010, does not allow the needed relationship. My GP 2013 Report Writer works fine.

    Thanks again, and best regards to all.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    Vail is absolutely correct. GP Report Writer will not allow us to add many -to-one relationship. Better you can do this with using Crystal Reports or SSRS.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    Don,

    The relationship you want to make cannot be made using Report Writer. Report Writer will not allow you to attach more than one branch of many-to-one relationships. The fact that you, in fact, only have one record is irrelevant to Report Writer. This is a limitation of the tool, you could do it with say, Crystal Reports or SSRS. You may want to explore using a different reporting tool. You could do this using VBA with the Modifier module. This is probably going to be impossible to see, but I drew a diagram of the relationships and where it will be disallowed.

    Kind regards,

    Leslie

  • DinB Profile Picture
    DinB 3,812 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    In my testing, I could not add "Item Vendor Master" in GP 2013. I am not sure why it is different result in your GP 2013. As you said, it allows in your GP 2013.

  • Don L Profile Picture
    Don L 740 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    Max,

    I am assuming in your reply above you meant for it to read...

    I created same sequence in GP 2013, but I was unable to add "Item Vendor Master"  to "Item Quantity Master" in GP 2010's SOP Blank Packing Slip Form.

    Thank you.

  • DinB Profile Picture
    DinB 3,812 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    I created same sequence in GP 2013, but I was unable to add "Item Vendor Master"  to "Item Quantity Master" in GP 2013's SOP Blank Packing Slip Form.

  • Don L Profile Picture
    Don L 740 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    Hi Leslie,

    I understand the one to many relationship of the vendor items. In this case, there is only one vendor item entry. As such when I modify a GP 2013 SOP Packing Slip Report with the relationship I mentioned above. the one vendor item number is displayed on the report just fine.

    What is the difference between GP 2010 and GP 2013? Everything looks the same but I cannot add the Item Vendor Master as shown below.

    01. Sales Document Header Temp

    02. -Sales Transaction Work

    03. --Customer Master Address File

    04. --Sales User-Defined Work History

    05. -Sales Document Line Temp*

    06. --Sales Transaction Amounts Work*

    07. ---Sales Line Comment Work and History

    08. ---Item Master

    09. ---Item Quantity Master

    10. ----Item Vendor Master

    11. ---Sales Serial/Lot Work and History*

    Thank you.

  • Don L Profile Picture
    Don L 740 on at
    RE: SOP Blank Packing Slip Form - Add Vendor's Item Number

    Max, this relationship already exists exactly as you described. It cannot be edited or changed. I understand the one to many relationship of the vendors. There is only one vendor item entered, so there is no problem there.

    Thank you.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans