Can anyone tell me the formula needed in Report Writer to get the courier tracking number to print on SOP documents?
Thanks,
Jennifer Pegg
Engine Control Systems Limited
*This post is locked for comments
Jennifer,
Here is the answer to your question regarding putting the tracking number on a SOP Document:
TechKnowledge Content
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 INFORMATION
When 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 )
Add the 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.
Note: There is a character limit of 80 when adding the Tracking Number to Invoices or Orders.
Please have a look on the below link.
Hope this helps!!!
This is a great post! This works just great for users that have only a few tracking numbers linked to a SOP invoice. However, we have a client who has some invoices with 20 tracking numbers attached and the numbers are 20 characters each so they are well over the 80 character limit. Any ideas on how to increase the size of the field printed on the invoice?
Does anyone know where the tracking # goes once the document is posted? I know Unposted goes to SOP10700, but I would like the tracking to show up on Historical documents as well.
Thank you!
Hi Leslie,
Just curious - have you ever done a parsestring with this tracking number calculated field so that it can wrap when there are more than 80 characters of tracking numbers on an order or invoice? We had an instance where a tracking number is 17 characters in length and there can be anywhere from 1 to 15 tracking numbers per order.
Thanks!
Jean
Hi Ian,
In 2008 you wrote about creating a table relationship with the sopTrackingNumbersWorkHist table and the Sales Transaction Work table in the Tables>Tables area of Report writer so that you could eventually get the user defined fields for tracking numbers to print on the SOP Invoice.
I was able to set up the Table releationships but am having difficulties understanding from there how you get that sopTrackingNumbersWorkHist table attached to the SOP Invoice so you can find those fields.
I already have the User Defined fields table related in the report from the SOP Transaction Work Table. Is it possible to expound on this to get it to relate to the tables on the report?
Thanks,
Jean
Thank you so much for the formula, this is exactly what we were looking for. It works perfectly!!
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,403
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
