Modifying the POP Purchase Order Blank Form Report to Print the Purchase Order Note

Issue

How to modify the POP Purchase Order Blank Form report to print the Purchase Order Note.

Resolution

1. Go into Report Writer.

2. Open the Report.

a. Click on the Reports icon from the top menu bar.

b. From the Original Reports side, highlight the POP Purchase Order Blank Form and choose Insert.

c. Then on the Modified Reports side, highlight the same report and choose the Open button.

d. In the Report Definition window choose the Layout button.

3. Calculated Fields.

a. In the Toolbox choose Calculated Fields from the drop down list.

b. Then choose the New button.

c. In the Calculated Field Definition window, type PO Note 1 as the name.

d. For the Result type choose String from the drop down list.

e. The Expression Type should be Calculated.

In the functions section:

a. Place your cursor in the Calculated.

b. Choose the Functions tab.

c. Choose User-Defined.

d. For the Core drop down select System.

e. For the Function drop down select RW_GetNoteText.

f. Choose the Add button.

In the fields section:

a. Choose the Fields tab.

b. Click on the drop down list for Resources and choose Purchase Order Work.

c. Click on the drop down list for Fields and choose PO Note ID Array and choose the Add button.

d. Enter 1 for the array index.

In the constants section:

a. Choose the Constants Tab.

b. Click on the drop down list for Type and choose Integer.

c. Type 50 in the Constants field, and choose the Add button. (This value represents how many characters are to print)

In the constants section:

a. Choose the Constants Tab.

b. Click on the drop down list for Type and choose Integer.

c. Type 1 in the Constants field, and choose the Add button. (This value represents which line of the note will print)

The final Calculated field should look like this:

FUNCTION_SCRIPT(RW_GetNoteTextPOP_PO.PO Note ID Array[1]501)

This will be the first line of the note.

To print the other lines of the Note you will need to create additional calculated fields. The calculated field will be exactly the same except the last constant. To get the different lines to print you will need to change the 1 to a 2 to print the second line, enter 3 for the third line, etc. The second Calculated field would look like:

FUNCTION_SCRIPT(RW_GetNoteTextPOP_PO.PO Note ID Array[1]502)

4. Bringing fields onto the report.

a. In the Toolbox choose Calculated Fields from the drop down list.

b. In the scrolling window find PO Note 1 and drag it into the RH section on the report.

c. Drag any other Calculated Fields that have been created into the same section.

5. Leaving Report Writer.

a. Choose the X from the top right corner of the Report Layout window.

b. Save your changes.

c. Click OK in the Report Definition window.

d. From the top menu bar, choose File | Microsoft Great Plains Dynamics/eEnterprise.

e. Give users access to the modified report in the Security Setup window (Setup | System | Security) within Great Plains.

These steps should also work for the POP Purchase Order Other Form.

This article was TechKnowledge Document ID: 27934