INTRODUCTION
This article describes how to modify the POP Purchase Order Blank form to include information from the Extender window.
MORE INFORMATION
Create the Extender window
1. |
Click Tools , click Extender , and then click Extender . |
2. |
Click Windows . |
3. |
Specify the following options: • Window ID : POP_LINE |
Add the Extender key fields
1. |
Expand Key Fields . |
2. |
Click the down arrow next to View , and then select Purchase Order Entry . |
3. |
Click Ord . |
4. |
Click Select . |
5. |
Expand Key Fields again. |
6. |
Click the down arrow next to View , and then select Purchase Order Entry . |
7. |
Click PO Number . |
8. |
Click Select . |
9. |
Enter the appropriate information for the purchase order line items. |
10. |
Click Save . |
Create a purchase order, and then open the report
1. |
Create a purchase order in Microsoft Great Plains. Select the line item, click Extras , click Additional , and then click POP Extra Window . |
2. |
Fill in the appropriate information for the line. |
3. |
Save the purchase order. |
4. |
Click Tools , click Customize , and then click Report Writer . In the Product box, select Great Plains . |
5. |
On the top menu bar, click the Reports button. |
6. |
Under Original Reports , select POP Purchase Order Blank Form , and then click Insert . |
7. |
Under Modified Reports , select the same report, and then click Open . |
8. |
In the Report Definition window, click Layout . |
Create two calculated fields
Calculated field 1
1. |
In the Toolbox , select Calculated Fields , and then click New . |
2. |
In the Calculated Field Definition window, type myKeyField as the name. |
3. |
In the Result Type list, select String . |
4. |
In the Expression Type list, select Calculated . |
5. |
Put the pointer in the Expressions Calculated box. |
6. |
Click the Functions tab. |
7. |
Click in the Functions box, and then select LNG_STR . |
8. |
Click Add . |
9. |
Click the Fields tab. |
10. |
Click in the Resources box, and then select Purchase Order Line Rollup Temp . |
11. |
Click in the Field box, select Ord , and then click Add . |
12. |
In the Expressions Calculated box, put the pointer to the right side of the closing parenthesis. |
13. |
In the Operators section, click CAT . |
14. |
Click the Functions tab. |
15. |
Click in the Functions box, and then select STRIP . |
16. |
Click Add . |
17. |
Click the Fields tab. |
18. |
Click in the Resources box, and then select Purchase Order Work . |
19. |
Click in the Field box, select PO Number , and then click Add . |
20. |
Click OK . |
Note In step 19, the first calculated field appears as the following string. LNG_STR(popPOLineRollupTemp.Ord ) # STRIP(POP_PO.PO Number )
Calculated field 2
1. |
In the Toolbox , select Calculated Fields , and then click New . |
2. |
In the Calculated Field Definition window, type Extender Field as the name. In the Result Type list, click String . |
3. |
Click the Functions tab. |
4. |
Click User-Defined . |
5. |
Click in the Core box, and then select System . |
6. |
Click in the Functions box, select rw_TableHeaderString , and then click Add . |
7. |
Click the Constants tab. |
8. |
Click in the Type box, and then select Integer . |
9. |
In the Constant box, type 3107 , and then click Add . |
10. |
Click in the Type box, and then select String . |
11. |
In the Constant box, type POP_LINE , and then click Add . |
12. |
Click the Fields tab. |
13. |
Click in the Resources box, and then select Calculated Fields . |
14. |
Click in the Field box, select myKeyField , and then click Add . |
15. |
Click the Constants tab. |
16. |
Click in the Type box, and then select Integer . |
17. |
In the Constant box, type 0 , and then click Add . |
18. |
Click in the Type box, and then select Integer . |
19. |
In the Constant box, type a value of 1 , and then click Add . |
20. |
Click OK . |
21. |
In the Toolbox , select Calculated Fields . |
22. |
Use the scroll box to find Extender Field . Then, drag Extender Field to the H3 section of the report. |
Note In step 19, the second calculated field appears as the following string.
FUNCTION_SCRIPT(rw_TableHeaderString3107"POP LINE"MyKeyField01 )