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

    • Feature - Calculate Order Total Sales Amount for Open Non-Picked Orders

      Release Date - 2/20/19 This feature gives the user the ability to calculate the Order Total Sales Amount. This ability has been added to the Order Integrity Check utility program. It is available from Global Setup-> Utilities-> COP Utilities-> ...

    • Feature - Alleviate Error 25 When Two Users Import Sales Orders Simultaneously

      Release Date: 9/26/19 Version: 8.5 and up If two users attempt to run Sales Order Import at the same time, the second user will receive an error 25 on the Import Header File (CPIMPHDR). If the second import is launched from deferred processing, this ...

    • Feature - Ability to Change EDI Import Path

      Release Date: 1/9/17 This feature gives the user the ability to change the path used when importing EDI orders. This option is enabled through Util-Setup-> Global Setup-> Add-Ons-> Sales Order Import. Field 4. Can User Override Path During Import? ...

    • Feature - Check for Duplicate PO During Sales Order Import

      Release Date: 7/19/2016 A new feature has been added to COP Sales Order Import that will check imported orders for potential duplicates. Setup by entering "Y" in Global Setup - > Add-ons -> Sales order import, field 23. When running Sales Order ...