Adding Multiple Customer Freight Accounts

When a customer has their own freight account with a carrier and wants you to bill his freight account instead of billing shipping charges on the invoice then you can define the customer’s freight account in the Customer file Maintenance program by flagging the customer as having a “Special shipping acct#”, screen #2, line #14. The program will prompt for you to enter the account number.

Often the customer will have multiple freight accounts with various carriers, I.e. UPS, FEDEX, and possibly various truck lines. You can define these additional customer freight accounts by associating the customer’s freight account with the ship-via code. Field 48 in the ship-via code allows for a 2 character code. You might choose to assign all UPS ship-via method (Ground, 2nd Day Air, Next Day Air, etc.) with a code of “UP”.


Add a ‘GS’ (general string) , codes record to associate the ship-via method with the customer’s freight account as indicated in the following screen shot. The code key (value of field 2) is constructed by adding “3RD_” plus the two character value in field 48 of the ship-via codes record (UP in the example of a UPS ship-via method) plus “_” and the customer number for a resulting code key of 3RD_UP_102691 (whereas 102691 is the customer being defined). The value in field 3 (general string data) is customer 102691 UPS freight account number.

Once the additional customer freight account ‘GS’ codes records are defined and an order is being processed, the respective freight account number will be passed to the manifest system for processing with the carrier being used for the shipment.

Leave a Reply