Proposal summary
This proposal describes the Possibility of to Source Tracking Number to a Custom field in Netsuite.
Requirement
Currently, the value in the field( field id: linkedtrackingnumbers) in the sales order is sourced from the value in the PACKAGE TRACKING NUMBER in item fulfillment.
OX Tools USA needs to source values from tracking numbers in the box information and pallet information to the custom field in the sales order.
Our Solution
This requirement can be achieved by creating a custom field named Box/Pallet Tracking Number in sales order And source values from tracking number in pallet information and box information to this custom field.
J&J will deploy a script that triggers on save action of item fulfillment/Box/Pallet Tracking Number record. The script will source value from tracking numbers in pallet information and box information to the custom field in the sales order of the related IFs.
The order of the value in the Box/Pallet Tracking Number field will be first Pallet tracking number and then box tracking number. Each tracking number will be separated by “ , ”.
Example: Pallet tracking number – 11111
22222
33333
Box tracking number – 44444
55555
66666
Value in new custom field -: 11111,22222,33333,44444,55555,66666
Risk
- The update of the reference field with new custom field on all the required Searches/Reports/PDFs is not included in this scope
- The script will set the value in the Box/Pallet Tracking Number custom field only on the sales order of newly created or updated item fulfillment/Box/Pallet Tracking Number record. The script will not consider historical records unless there is an edit and save that occurred on the related records. If you want to update the value in historical sales orders, then we will create a mass update script to update the value in old sales orders. It requires additional effort.