How to display the difference between the Original Unit Price and Special Unit Price on the WCD Pricing Transaction Inquiry Report

Subject:

The steps here will describe how to display the difference between the Original Unit Price and Special Unit Price on the Pricing Transaction Enquiry Report.

Resolution:

Here are the steps to follow:

1. Go to Microsoft Dynamics GP | Tools | Customize | Report Writer.
2. Select Product: Omni Price, and then click OK.
3. Click Reports.
4. Select WDC Pricing Transaction Inquiry Report in the Original Reports column, and then click Insert.
5. Select WDC Pricing Transaction Inquiry Report in the Modified Reports column, and then click Open.
6. Click Layout.
7. In the Toolbox window, select Calculated Fields in the drop down field.
8. Click New.
   1. Type Original Unit Price in the Name field.
   2. Select Currency for Result Type.
   3. Select Calculated Fields for Resources.
   4. Select (C) Original Unit Price for Field.
   5. Click Add.
   6. Click OK.
9. Click New.
   1. Type Special Unit Price in the Name field.
   2. Select Currency for Result Type.
   3. Select Calculated Fields for Resources.
   4. Select (C) Special Unit Price for Field.
   5. Click Add.
   6. Click OK.
10. Click New.
    1. Type Difference between Original and Special Unit Prices in the Name field.
    2. Select Currency for Result Type.
    3. Select Calculated Fields for Resources.
    4. Select (C) Original Unit Price for Field.
    5. Click Add.
    6. Click the Subtraction operator button ( – ).
    7. Select Calculated Fields for Resources.
    8. Select (C) Special Unit Price for Field.
    9. Click Add.
    10. Click OK.
11. Select the Difference between Original and Special Unit Prices calculated field and move it to the Body section of the report.
12. Double click on the Difference between Original and Special Unit Prices field in the Body section of the report.
13. Click the Format ellipse button.
14. Click New.
15. Type Currency in the Format Name field.
16. Select Right for Alignment.
17. Type 2 for Decimal Digits.
18. Select () for Negative Symbol.
19. Mark the following checkboxes:
    1. Show Thousands Separator.
    2. Show Currency Symbol.
20. Click OK.
21. Click OK.
22. Click OK.
23. Go to File | Microsoft Dynamics GP.
24. Click Save.
25. Click Save.
26. Give the User ID security to the report.
    1. Go to Microsoft Dynamics GP | Tools | Setup | System | Alternate/Modified Forms and Reports.
    2. Select the DEFAULTERUSER for example.
    3. Select Omni Price for Product.
    4. Select Reports for Type.
    5. Expand 3^rd Party.
    6. Expand WDC Pricing Transaction Inquiry Report.
    7. Mark the Omni Price (Modified) radio button.
    8. Click Save.
27. Print the report.
    1. Go to Inquiry | Omni Price | Pricing Transactions.
    2. If you have any restrictions, enter them.
    3. Click Print.