try the steps below from partnersource. I completed for a customer last month.
SUMMARY This article describes how to use the Report Writer function rw_CreateSOPTrackingNumberString for Tracking Numbers on Sales Order Processing Sales Invoices and Order forms.
MORE INFORMATIONWhen tracking numbers are entered in the Sales User-Defined Fields Entry window, the rw_CreateSOPTrackingNumberString function will print the Tracking Numbers on the Sales Invoice and Order Forms. This functionality was added to Great Plains Release 7.5 with Service Pack 2. To use this function, follow the steps below:
Calculated Fields:
1. In the Toolbox, select Calculated Fields from the drop-down list, and then click New.
2. In the Calculated Field Definition window, type Tracking Number as the name.
3. For the Result type, select String from the drop-down list.
4. Select Calculated as the Expression Type.
In the Functions section:1. Click in the Calculated Expression.
2. Click the Functions tab.
3. Select User Defined.
4. Click the drop-down list for Core and select Sales.
5. Click the drop-down list for Function and select rw_CreateSOPTrackingNumberString. Click Add.
In the Fields section:1. Click in the Calculated area.
2. Click the Fields tab.
3. Click the drop-down list for Report Table and select Sales Transaction Work.
4. Click the drop-down list for Table Fields and select SOP Number. Click Add.
In the Fields section:
1. Click in the Calculated area.
2. Click the Fields tab.
3. Click the drop-down list for Report Table and select Sales Transaction Work.
4. Click the drop-down list for Table Fields and select SOP Type. Click Add.
The Calculated Expression should read:
FUNCTION_SCRIPT(rw_CreateSOPTrackingNumberStringSOP_HDR_WORK.SOP NumberSOP_HDR_WORK.SOP Type )
Note: There is a character limit of 80 when adding the Tracking Number to Invoices or Orders.
Share
Report
490
All responses (
Answers (
