Discount and Unit Price Fields are Formatted Incorrectly on the SOP Blank Invoice Report

Question:

I have downloaded the SOP Blank Invoice 7pt report from the reports library and am now printing the modified report. The discount and unit price fields are being formatted with a percent symbol (%) instead of a dollar sign ($). How can the report be fixed, so that the fields show the proper symbols?

Answer:

Go into Report Writer ( Tools - Customize - Report Writer ).

Opening the Report:

1.) Click on the Reports icon from the top menu bar.
2.) From the Original Reports column, highlight the SOP Blank Invoice report and choose Insert .
3.) Then, in the Modified Reports column, highlight the same report and choose Open .
4.) In the Report Definition window, choose the Layout button to open the report layout.

Layout:

1.) Double-click on the F/O Markdown Amount field to access the Report Field Options window.
2.) Change the format field from MC Decimal Places to (C) Curr Index Body by clicking on the (C) Curr Index Body option in the Format Field scrolling window.
3.) Click on the OK button to close the Report Field Options window.
4.) Repeat steps 1 through 3 for the F/O Unit Price field as well.

Leaving Report Writer:

1.) Choose the X from the top right corner of the Report Layout window.
2.) Save your changes.
3.) Choose OK in the Report Definition window.
4.) From the top menu bar, choose File - Great Plains Dynamics or eEnterprise .
5.) Give users access to the modified report in the Security Setup window ( Setup - System - Security ).

Now, when you print the report, the fields should be correctly formatted with a dollar sign, and not a percent symbol.



This article was TechKnowledge Document ID: 27173