Price Calculation
To calculate the net cost, the system does two things:
• From the price table, it selects the unit cost for the line item due date or the order entry date, depending on what you specified in Purchasing Control. If pricing is by item due date, the due date defaults from the due date in the order header, but you can override it for individual lines from single-line entry mode.
• If a discount table is specified, the system applies the percentage from the discount table for the line or order due date to calculate the extended net cost for the line item quantity. You can override this net cost manually.
If the price table has a minimum or maximum cost, the system verifies the calculated or user-entered net price against it. If the net cost is outside the minimum/maximum range, the system displays a warning message and replaces the line item net cost with either the maximum or minimum price from the price table, as appropriate.
When entering an item on an order, the system looks for a matching price list in the following order:
1 Currency, price list, item number, unit of measure
2 Currency, price list, item number
3 Currency, price list, product line (item number blank)
4 Currency, price list (product line and item number blank)
In addition, for a price list to be used:
• The currency of the order and price list must be the same.
• The order date must be within the pricing effective dates.
If no match is found, the item base price displays, converted to the currency of the order.