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 - Added Archive Function to Sales Order Import File Search Window

      Release Date: 9/21/23 Version: 8.5 and Above Some customers have asked how to delete or archive files from the Import Folder for Sales Order Import. This can happen because the import file has invalid information which will require the trading ...

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