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

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

• CP1400 Customer Order Processing Price List Report

  Price List Report Application Overview The Price List Report application enables you to print out the base price and pertinent discount price information for each item within a selected range of items, product categories, and price code types. (Refer ...

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

• CP0901 Customer Order Processing Price Code File Maintenance

  Price Code File Maintenance Application Overview The pricing system is based on price break tables. For example, you could set up a table such that when over 100 of an item are ordered, there is a 5% discount, when over 200 are ordered, there is a ...

• CPFUTMNU Customer Order Processing Future Price File Maintenance

  Future Price File Maintenance Application Overview Future Price function is used to update the price, standard cost and user-amount fields in the item master file. By using this function, the user can enter a date when the item price, cost, and ...