How is the Price Determined in Sales Order Import?

How is the Price Determined in Sales Order Import?

Release Date - 11/09/2020
Version - 7.5 and up

There is a flag on screen 4 of the EDI Profile in Customer Maintenance that determines how the price is set, Warn If Import Unit Prc <> Eli Calc Prc. This can be N for No Warning, I for Use Import Price, or E for Use Elliott Price.



There are five different import scenarios. First, the import price could be blank. The import would calculate the price in the same way as a manually entered order in Order Entry. Second, a price could be provided and the Import Price flag set to N. Regardless of the price in Elliott, this would always use the import price without any warning. Third, a price could be provided and the flag set to I. If the price was different, a warning would be printed on the Import Journal and the import price would be used. Fourth, a price could be provided and the flag set to E. If the price was different, a warning would be printed on the Import Journal and the Elliott price would be used. Again, this would be the same price used as a manually entered order respecting any entries in the Price Code file. A fifth scenario would be an import price is provided and the prices match. In that case, no warning would be printed.

MAD




    • Related Articles

    • Feature - Added Item Price Mismatch Event in Sales Order Import

      Release date: 4/19/2022 Version: 8.5 and Up You can now subscribe to the Item Price Mismatch Event in Sales Order Import. This will trigger an email when there is a price discrepancy between the import price for an item and the calculated price in ...

    • Feature - Avalara Tax Code Support in Sales Order Import

      Release Date: 9/6/23 Version: 8.6 and Above Sales Order Import now determines the correct tax codes for an order based on the ship-to state and country for the order. First, the application will determine if the address is a foreign address (non-US ...

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

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

    • Feature - Sales Order Import Error Directory Support

      Date Released: 8/21/18 This feature gives users the ability to move import files that contain errors to an error directory during the Interface process. This is helpful for users who want to use defer processing to import sales orders every few ...