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

7.

Click to select Microsoft Dynamics GP (Modified) .

8.

Click Save .

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×