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

INTRODUCTION

MORE INFORMATION

Create the Extender window

Click Tools , click Extender , and then click Extender .

Click Windows .

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 )

↑ Back to the top

Keywords: kb, kbnosurvey, kbMBSMigrate, kbMBSPartner, BemisKB904575