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
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
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:
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:
13. All you have left is to add the Price List field to the Report Layout and you are good to go!
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,287
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
