Adding Tracking Number to the SOP order and invoice forms in Microsoft Dynamics GP

Options

We’ve had a few requests lately asking how to add the Tracking numbers to our Sales Order Processing Orders and Invoice forms. Below are steps on how to use create a calculated field in Report Writer using a function to pull the information on a form.

Note: Steps below are how to add the tracking number to the SOP Blank invoice form, but the same concept applies to other forms. You will be using the rw_CreateSOPTrackingNumberString function to pull the information.

On the Original Report Side Click the SOP Blank Invoice form (or the report want to modify) and Click Insert (Some examples to modify are: SOP Blank Invoice form, SOP Blank Order Form, SOP Blank History Invoice form, SOP Long Order Form etc).

Click the SOP Blank Invoice form on the Modified Reports Side and Click Open.

In the Report Definition Window Click Layout.

Create a calculated field to pull the Tracking number.

a. In the Toolbox, select Calculated Fields from the drop-down list, and then click New.

b. In the Calculated Field Definition window, type Tracking Number as the name.

Hope this article is useful for getting the Tracking numbers onto your forms. If you have any issues or other modifications causing conflicts and need assistance, please create a case for troubleshooting.