Feature - Import of Shipment Tracking Number for Sales Order Through CSV File

Release date: 5/19/2020

Revised: 7/26/24

Version 8.5 and Up

You can now import shipment tracking numbers for sales orders through a CSV File.  You can find the utility in COP, Processing, Print Pick/Pack Tickets & Lbls, Shipping, and Tracking Number Import.  The import has the standard Pre-interface, Interface, and Layout menu options.

The CSV file should contain the following fields:

Note that Order# and Tracking# are the only required fields.

If Package# is not provided, then it is assumed to be 1. 

If Weight is not provided, then it won't be written to the note.

If Freight Amount is not provided, then it won't be written to the note.

If Ship Via is not provided, then we look up the Ship Via Description using the 

Order Ship Via Code.

The note Create Date and Modify Date will be set to the System Date.

The note Create Time and Modify Time will be set to the System Time.

The Reference field will be used for the Note Subject.

The Pre-Interface screen will prompt for the following three fields:

Values in fields 1 and 2 will be saved and used for the next session.

An example of the Pre-Interface report:

All errors must be resolved before the Interface can proceed.  To reduce the possibility of duplicate tracking notes the program will give a warning if a tracking number has already been entered for an order, and an error will occur if the import tracking number already exists for that order.

The Interface screen prompts for the following:

Values in fields 1 and 2 will be saved and used for the next session.  Enter "Y" for the "Do You Want To Interface At This Time ?" question when you are ready to interface.

An example of the Interface report:

 

If there are no errors during the Interface, the input CSV file will be deleted.

Note: You must enable the corresponding settings in Global Setup-> COP-Func-> Ship Data Update to enable the the importing of ship date,  package#, ship via, weight and freight. 

If Update Ship Date in Manifest Note is set to "Y" a prompt will ask "Note Create Use System Date/Time & May Not Match Note Content If Flag is Y. OK?" Answering Y may cause the note creation date/time to not match the date/time in the note content.

Modified programs:  CP0200.CBL, DATE.WS, DATE.PL, DATEGR.WS, DATEGR.PL

New: CPTRKIMS.CBL, CPTRKIMP.CBL, CPIMPER2(SL, FD, WS, DS), CPIMPTRK(SL, FD, WS, DS), CPTRKASC(SL, FD, WS, DS)               

DLM

• Related Articles

• Shipment Confirmation Email Shows FedEx URL for UPS Tracking Number

  Release Date: 02/06/2024 Version: 7.x & Up Q - How is the URL used in the shipment confirmation email determined? We have a case where the FedEx URL is used for a UPS shipment, which obviously doesn’t work. See sample below: A - Elliott tries to ...

• A Summary to Outline of Elliott EDI Integration Flow

  Release Date: 06/15/2023 Version: 8.x & Up Q - We currently use SPS Fulfillment Portal for our EDI processing. We are getting too great of a volume of EDI orders and we are evaluating whether to automate it with Elliott. Can you give me an outline of ...

• APINVIMS Accounts Payable Invoice Import Utility

  A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...

• ARECIMNT Accounts Receivable Customers and Contacts Import Utility

  Last Update: 03/20/2024 Version: 8.0 & Higher Introduction This utility was the first utility we developed to handle the import and update of customers and contacts at the same time. Since then, we have developed a separate utility to import or ...

• ARCUSMNT Accounts Receivable Customer File Maintenance

  Customer File Maintenance Application Overview The Customer File is a very important file. It stores the basic information about every customer you do business with. Almost every major application in the A/R package uses the Customer file to ensure ...