Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Adding Item Currency table to Picking Ticket

(0) ShareShare
ReportReport
Posted on by 456

I have a request to add something to the Picking ticket and need the List price off the item currency table. I am unsure how to add/join it. Also the company it setup as multicurrency so there a more than one row per item however I only need the US currency list price. I think the one to many further complicates this but hoping someone can guide on how to accomplish this. Thanks for any advice or direction.

*This post is locked for comments

  • Nancy Cohen Profile Picture
    Nancy Cohen 456 on at
    RE: Adding Item Currency table to Picking Ticket

    Thank you Mariano, never added a restriction in report writer before, so that was fun. Probably should have mentioned I already had the Item master but I very much appreciate the detailed explanation. This worked perfectly

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Adding Item Currency table to Picking Ticket

    1. Print the Picking Ticket report to screen and click the Modify button -- this will take you to Report Writer

    2. Close the Report Layout window

    3. On the Report Definition window, click the Tables button

    4. On the Report Table Relationships window, highlight the Sales Transaction Amounts Work table, then click New

    5. Highlight the Item Master table and click OK

    6. On the Report Table Relationships window, highlight the Item Master table, then click New

    7. Select the Item Currency Master and click OK. At this point, this is what your relationships should look like:

    Restrictions.png

    8. Close the Report Table Relationships window

    9. In the Report Definition window, click the Restrictions button

    10. In the Report Restrictions window, click New

    11. Type Functional Currency in the Restriction Name field

    12. You will create a restriction for Item Currency Master's Currency ID field = Sales Transaction Work's Currency ID field. This should limit the Price List field to only the functional currency value. This is the final result:

    Restrictions.png

    13. All you have left is to add the Price List field to the Report Layout and you are good to go! 

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,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans