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 ) 

 

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×