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

    • Feature - Calculate Freight When Fill Presales Order

      Release Date: 4/2/26 Version: 8.6 and Above The new Global Setup option, 22. Calculate Freight When Fill Presales Order, has been added to System-Utilities-> Global Setup-> Add-Ons-> Presales Interface. 22. Calculate Freight When Fill Presales Order ...

    • 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 - Sales Order Import To Warn If Sales or Weight Greater Than Certain Value

      Release Date: 8/23/2016 This feature gives the ability to print a warning message on the Sales Order Import Pre-Interface List or Interface List if the Order Total Sales Amount is greater than a certain value or if the Order Total Weight is greater ...

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