How to use Report Writer to add the functional currency list price to the SOP Blank Invoice Form in Microsoft Dynamics GP


INTRODUCTION


This article describes how to use Report Writer to add the functional currency list price to the SOP Blank Invoice Form or to other non-options forms in Sales Order Processing in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains.

MORE INFORMATION


Step 1: Back up the report

1. If you have any modified reports, back up the Reports.dic file. To locate the Reports.dic file, follow these steps:
a.

Use the appropriate method:

• In Microsoft Dynamics GP 10, point to Tools on the Microsoft Dynamics GP menu, point to Setup , point to System , and then click Edit Launch File .
• In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Setup on the Tools menu, point to System , and then click Edit Launch File .


     
b. If you are prompted for the password, type the system password.
c.

Use the appropriate method:

• In Microsoft Dynamics GP, click Microsoft Dynamics GP in the Edit Launch File window.
• In Microsoft Business Solutions - Great Plains 8.0, click Great Plains in the Edit Launch File window.

d. Note the path that appears in the Reports box.
e. Click OK to close the Edit Launch File window.

Step 2: Open the report

1.

Use the appropriate method:

• In Microsoft Dynamics GP 10, point to Tools on the Microsoft Dynamics GP menu, point to Customize , and then click Report Writer .
• In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Customize on the Tools menu, and then click Report Writer .


     
2.

Use the appropriate method:

• In Microsoft Dynamics GP, click Microsoft Dynamics GP in the Product list, and then click OK .
• In Microsoft Business Solutions - Great Plains 8.0, click Great Plains in the Product list, and then click OK .


     
3. Click Reports .
4. In the Original Reports area, click the report that you want to modify, and then click Insert .
5. In the Modified Reports area, click the report, and then click Open .

Step 3: Create a calculated field

1. Click Layout .
2. In the Toolbox window, click Calculated Fields in the resource list, and then click New .
3. In the Name field, type List Price .
4. In the Result Type list, click String .
5. In the Expression Type area, click Calculated .
6. Click the Functions tab, and then click User-Defined .
7. In the Core list, click Inventory .
8. In the Functions list, click rw_ivGetFuncListPrice , and then click Add .
9. Click the Fields tab. In the Resources list, click Sales Transaction Amounts Work .
10. In the Field list, click Item Number .
11. Click Add , and then click OK . The following expression appears:

FUNCTION_SCRIPT(rw_ivGetFuncListPriceSOP_LINE_WORK.Item Number)

12. Click OK .

Step 4: Add the new fields to the report

1. In the Toolbox window, click Calculated Field in the resource list, and then click List Price .
2. Drag the List Price field to the H2 section of the report.
3. If you want to edit the field, click Tools , and then click Drawing Options .

Step 5: Save the modified report

1. Close the report. Click Save when you are prompted to save your changes.
2. In the Report Definition window, click OK .
3.

Use the appropriate method:

• In Microsoft Dynamics GP, click Microsoft Dynamics GP on the File menu.
• In Microsoft Business Solutions - Great Plains 8.0, click Microsoft Business Solutions - Great Plains on the File menu.


     

Step 6: Assign security permissions to the modified report

Method 1: Use Microsoft Dynamics GP 10.0 security

1. On the Microsoft Dynamics GP menu, point to Tools , point to Setup , point to System , and then click Alternate/Modified Forms and Reports .
2. In the ID box, type the user ID that will print this modified report.
3. In the Product list, click Microsoft Dynamics GP .
4. In the Type list, click Reports .
5. Expand the Sales folder.
6. Expand the report_name folder.

Note The report_name placeholder is a placeholder for the name of the report.
7. Click to select Microsoft Dynamics GP (Modified) .
8. Click Save .

Method 2: Use Advanced Security in Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0

1. On the Tools menu, point to Setup , point to System , and then click Advanced Security . Type the system password if you are prompted.
2. Click View , and then click by Alternate, Modified and Custom .
3.

Use the appropriate step:

• In Microsoft Dynamics GP 9.0, expand Microsoft Dynamics GP .
• In Microsoft Business Solutions - Great Plains 8.0, expand Great Plains

4.

Expand the following nodes:

• Reports
• Sales
report_name

5.

Use the appropriate method:

• In Microsoft Dynamics GP 9.0, click Microsoft Dynamics GP (Modified) .
• In Microsoft Business Solutions - Great Plains 8.0, click Great Plains (Modified)

6. Click Apply , and then click OK .

Note By default, when you start the Advanced Security tool, the current user and the current company are selected. Any changes that you make are for the current user and for the current company. However, you can select additional users in the User area of the Advanced Security window. You can select additional companies in the Company area of the Advanced Security window.

Method 3: Use Microsoft Dynamics GP 9.0 security or Microsoft Business Solutions - Great Plains 8.0 security

1. On the Tools menu, point to Setup , point to System , and then click Security .

Note If you are prompted to type the system password, type the system password.
2. In the User ID list, click the user ID of the user who will access the report.
3. In the Type list, click Modified Reports .
4. In the Series list, click Sales .
5. In the Access List box, double-click report_name , and then click OK .

Note After you click OK , an asterisk appears next to the report name.