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

    • Missing Freight Account After Starship Write Back Freight Amount

      Q - We are having an issue with the freight account not showing up in Elliott. If you go into the field, it then shows up but that is the only way we can get it work. This is only on UPS Starship orders that are prepay and add. See sample screen ...

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

    • IMIMSITM Inventory Management Item Import Utility

      Item Import Utility Application Overview The purpose of this utility is to provide an easy way for a third party application to add items into Elliott. It can also be used for transferring the item master records added in a different company or ...

    • Feature – Import Shopify Orders to Elliott through ESS and SPS

      Release Date: 07/08/2023 Version: 8.5 & Up New Features to Support Shopify Interface Shopify is a popular turnkey solution for creating eCommerce websites. Our EDI partner has created an interface with Shopify so the eCommerce order can be imported ...

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