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

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) / Adding a field to PO
Microsoft Dynamics GP (Archived)

Adding a field to PO

(0) ShareShare
ReportReport
Posted on by Community Member

I am attempting to modify the PO form in Microsoft Dynamics GP 2013.  We have chosen to use the item short description field to hold our part ID #'s from our previous system.  Our purchasing agent would like to see this field on the PO, in addition to the vendor and item #.  I am jumping in on this after someone else has added this field to the PO, so I'm not entirely sure how it was added.  The problem I have is that this field does not display on the PO.  My educated guess is that there is a relationship missing somewhere.  The item number field on the PO is a calculated field.  The short description field has been added directly from the Item Master table.  I'm new at this.  Can someone point me in the right direction to make this field visible on my PO?  Thanks!

*This post is locked for comments

I have the same question (0)
  • Jeff LaPointe Profile Picture
    Jeff LaPointe 1,022 on at

    Usually when you are missing a new field that you added to a GP report is is due to a setting that switches the report from the canned version to a modified version. Try these steps to see if the report view is setup correctly:

    1. Go to Tools | Setup | System | Alternate/Modified Forms and Reports

    a. Select the current user ID for the ID field. (The default ID is DEFAULTUSER)

    b. Product = Microsoft Dynamics GP

    c. Type = Reports

    d. Expand the Purchasing folder and change the report from Dynamics GP to the modified version of the report.

    e. Click Save

    Try to run the report and verify the field is now visible.

    Hope this helps,

  • Community Member Profile Picture
    Community Member on at

    I am using the modified version already.  Thanks for your reply, though.

  • Tanner Profile Picture
    Tanner 360 on at

    If you are already using the modified report, the next thing I do is make sure the field was added correctly.  I usually print the report I want to modify to screen, and then click the modify button at the top to ensure I'm changing the correct report.  The other thing that has tripped me up is adding the field to the header of the report and not the body, or vice versa.  The field needs to be added in both the header (pink section) and the body (green section) in report writer for it to work correctly.

  • Community Member Profile Picture
    Community Member on at

    I have used the modify button on my PO to modify my report.  I've already made the mistake of adding a field in the header and not the body, so was aware of that one too.  I'm still thinking it is probably a relationship issue.  This field should be tied to the item number, which is a calculated field in this PO.  I don't know if it's possible to create a relationship with a calculated field.  My instincts tell me this is what I'm looking for, but I don't know where to go with it.

  • Redbeard Profile Picture
    Redbeard 12,931 on at

    Here is a link to a post explaining table relationships. You should be able to extrapolate adding the user short description field to the Purchase Order...

    support.microsoft.com/.../922054

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at

    Using GP2010, and starting from the default POP Purchase Order Blank form, I was able to add the "Item Short Name" and have it successfully print.

    1.)  You must create a table relationship from the popPOLineRollupTemp to the Item Master (Using Key 1)

    2.)  Link the Item Master on to the POP Purchase Order Blank Form.  Keep in mind, you can only link a given table once to a report, so if the item master is already linked, you would need to remove it and link it via Purchase order Line Rollup Temp*

    3.)  Add the Item Short Name into the H3 section

    4.)  Print the PO and check your results

    If you are still having problems, please provide me with a screenshot of the Report Table Relationships window so that I can see what table you currently have the Item Master linked with. 

    Thanks,
    Justin

  • Community Member Profile Picture
    Community Member on at

    Thank you!  It was helpful to know how these tables linked.  I found that my Item Master was using IV_Item_MSTER_Key4 as the Secondary Table Key and was linking the Tax Detail ID with the Item Short Name in addition to the Item Number field.  This made no sense to me and would explain why the result would always be null.  I deleted this relationship and re-created it using IV_Item_MSTR_Key1 and linked only on Item Number.

    I expected this to solve my issue, but it still will not print.  I can't get my screen shot of the Report Table Relationships to paste here.  If I understand correctly, the absence of an asterisk on the Item Master table means the only relationship is the one I created.

    I tried deleting the field from the report and bringing it over again. This made no difference, either.  I'm not sure what to try next.

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at

    Can you confirm that the existing table relationship to the Item Master (based on Key 4) has been deleted?  I seem to remember from a long time ago that if you had 2 relationships setup to the same table, regardless of which relationship you chose when linking the table to the report, it would always use the relationship that was "on top".

    Therefore, please delete all relationships between popPOLineRollupTemp and the Item Master except for the 1 you just created based on Key 1.

    Thanks,

    Justin

  • Community Member Profile Picture
    Community Member on at

    Yes.  I specifically deleted the Key 4 relationship before I added the Key 1.  It took a few minutes to figure out how to do that, but I made sure it was deleted first.

  • Kumar_Sat Profile Picture
    Kumar_Sat 1,282 on at

    Did you get it done? Any solutions so far?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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