Sales Orders Import Utility Does Not Import the Freight Amount

Sales Orders Import Utility Does Not Import the Freight Amount

A - I use the Sales Order Import utility.  In my import ASCII file, I verify that the freight amount is placed in the correct position.  However, after the sales order is imported, the imported sales order shows zero freight amount.  Why is that?

Q - The likely reason has to do with Global Setup -> Cop-Func -> Order Billing Screen:

        1. Initialize Freight Amount in Order Billing ?

See sample screen below:



The default value in the past was "Y."  This is for legacy Macola compatibility purposes. However, setting this flag to "Y" can be problematic.  This is especially true if you choose to access the billing screen during order entry and enter the freight amount.  Then you find that during billing selection, the freight amount you entered is being wiped out due to this flag being set to "Y."

Also, during the sales order import process, if this flag is set to "Y" the system will set the order freight amount to zero even if you provided the freight amount value in the proper location in the import ASCII file.

We suggest that you change this flag to "N," which will make sense in most situations.




    • Related Articles

    • 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 ...

    • CPIMPMNU Customer Order Processing Sales Order Import

      Sales Order Import Application Overview The Sales Order Import module is designed to import a pre-defined ASCII file to create COP sales orders. It is intended to provide an easy way for developers to create add-on solutions for creating sales ...

    • Change - CSV Import Programs to Support File Names Longer Than 20 Characters

      Release date: 5/5/2021 Version 8.5 & Up There were many Elliott CSV Import programs which had a limitation that the maximum file name could not be greater than 20 characters. See the following KB article: ...

    • 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 ...

    • CPSLSDSK Customer Order Processing Sales Desk

      Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...