How to modify the POP Purchase Order Blank form to include information from the Extender window

This article describes how to modify the POP Purchase Order Blank form to include information from the Extender window.

Applies to: Microsoft Dynamics GP
Original KB number: 904575

Create the Extender window

Expand Key Fields.
Select the down arrow next to View, and then select Purchase Order Entry.
Select Ord.

Note

If you select Line Number, the report modification will not work.
Choose Select.
Expand Key Fields again.
Select the down arrow next to View, and then select Purchase Order Entry.
Select PO Number.
Choose Select.
Enter the appropriate information for the purchase order line items.
Select Save.

Create a purchase order in Microsoft Great Plains. Select the line item, select Extras, select Additional, and then select POP Extra Window.
Fill in the appropriate information for the line.
Save the purchase order.
Select Tools, select Customize, and then select Report Writer. In the Product box, select Great Plains.
On the top menu bar, select the Reports button.
Under Original Reports, select POP Purchase Order Blank Form, and then select Insert.
Under Modified Reports, select the same report, and then select Open.
In the Report Definition window, select Layout.

In the Toolbox, select Calculated Fields, and then select New.
In the Calculated Field Definition window, type myKeyField as the name.
In the Result Type list, select String.
In the Expression Type list, select Calculated.
Put the pointer in the Expressions Calculated box.
Select the Functions tab.
Select in the Functions box, and then select LNG_STR.
Select Add.
Select the Fields tab.
Select in the Resources box, and then select Purchase Order Line Rollup Temp.
Select in the Field box, select Ord, and then select Add.
In the Expressions Calculated box, put the pointer to the right side of the closing parenthesis.
In the Operators section, select CAT.
Select the Functions tab.
Select in the Functions box, and then select STRIP.
Select Add.
Select the Fields tab.
Select in the Resources box, and then select Purchase Order Work.
Select in the Field box, select PO Number, and then select Add.
Select OK.

Note

In step 19, the first calculated field appears as the following string.

LNG_STR(popPOLineRollupTemp.Ord ) # STRIP(POP_PO.PO Number )

In the Toolbox, select Calculated Fields, and then select New.
In the Calculated Field Definition window, type Extender Field as the name. In the Result Type list, select String.
Select the Functions tab.
Select User-Defined.
Select in the Core box, and then select System.
Select in the Functions box, select rw_TableHeaderString, and then select Add.
Select the Constants tab.
Select in the Type box, and then select Integer.
In the Constant box, type 3107, and then select Add.
Select in the Type box, and then select String.
In the Constant box, type POP_LINE, and then select Add.
Select the Fields tab.
Select in the Resources box, and then select Calculated Fields.
Select in the Field box, select myKeyField, and then select Add.
Select the Constants tab.
Select in the Type box, and then select Integer.
In the Constant box, type 0, and then select Add.
Select in the Type box, and then select Integer.
In the Constant box, type a value of 1, and then select 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.
Select OK.
In the Toolbox, select Calculated Fields.
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 )