How to modify the POP Purchase Order Blank form to include information from the Extender window in Microsoft Great Plains


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
Description : POP Extra Window
Product : Great Plains
Series : Purchasing
Form : Purchase Order Entry
Window : Line_Scroll



     

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 .

Note If you select Line Number , the report modification will not work.
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 .

Note This value prints the first field in the "POP Extra Window" window for the line item. Type 2 if you want the second line to print, and so on.
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 )