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 - Determine Salesman By Division

      Release Date 9/12/21 Version: 8.5 and Above The purpose of this feature is to allow defining salesman by division which is on the item by item basis. In customer or ship-to file maintenance, user can only define one salesman per order. However, if ...

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