How to add tracking number to the SOP order and invoice forms in Microsoft Dynamics GP
This article introduces how to add the Tracking numbers to our Sales Order Processing Orders and Invoice forms in Microsoft Dynamics GP.
You can see the full BLOG article.
Applies to: Microsoft Dynamics GP
Original KB number: 4100256
Below are steps on how to create a calculated field in Report Writer using a function to pull the information on a form.
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.
Open Report Writer by selecting Microsoft Dynamics GP > Tools > Customize > Report Writer. Select Microsoft Dynamics GP for Product and select OK.
On the Original Report Side, select the SOP Blank Invoice form (or the report want to modify) and select Insert (Some examples to modify are: SOP Blank Invoice form, SOP Blank Order Form, SOP Blank History Invoice form, SOP Long Order Form, and so on).
Select the SOP Blank Invoice form on the Modified Reports Side and select Open.
In the Report Definition Window, select Layout.
Create a calculated field to pull the Tracking number as follows:
In the Toolbox, select Calculated Fields from the drop-down list, and then select New.
In the Calculated Field Definition window, type Tracking Number as the name.
For the Result type, select String from the drop-down list.
Select Calculated as the Expression Type.
Select the Calculated Expression section.
Select the Functions tab.
Select user Defined.
Select the drop-down list for Core and select Sales.
Select the drop-down list for Function and select rw_CreateSOPTrackingNumberString. Select Add.
Select the Fields tab.
Select the drop-down list for Resources and select Sales Transaction Work.
Select the drop-down list for Fields and select SOP Number. Select Add.
Select the drop-down list for Fields and select SOP Type. Select Add.
The Calculated Expression should read:
FUNCTION_SCRIPT(rw_CreateSOPTrackingNumberStringSOP_HDR_WORK.SOP NumberSOP_HDR_WORK.SOP Type)
Add the field new Tracking Calculated field to the RF section of the Invoice or Order you are modifying. It will print in alphabetical order with a comma between multiple tracking numbers.
There is a character limit of 80 when adding the Tracking Number to Invoices or Orders.
Go back to Microsoft Dynamics GP by selecting File > Microsoft Dynamics GP. Select Save to any message you receive.
Give access to your modified report by going to Administration > Setup > System > Alternate/Modified Forms and Reports.
- Select your ID.
- Select the drop-down list for Series and select Sales.
- Select the drop-down list for Type and select Reports.
- Select the Sales + sign in the Alternate/Modified Forms and Reports List section.
- Select the SOP Blank Invoice form + sign.
- Select the option for Microsoft Dynamics GP (Modified).
- Select Save and close the window.
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, create a case for troubleshooting.