Use special prices in sales orders
Business Central applies the "best price" principle. The best price is the lowest permissible price with the highest permissible line discount on a given date. Business Central automatically calculates the price when it inserts the unit price and the line discount percentage for items on new document and journal lines.
Business Central calculates the best price for sales as follows:
Check the combination of the bill-to customer and the item, and then calculate the applicable unit price and line discount percentage by determining:
Whether the customer has a price/discount agreement or if they belong to a group that has one.
If the item or the item discount group on the line is included in these price/discount agreements.
If the order date (or the posting date for the invoice and credit memo) is within the starting and ending date of the price/discount agreement.
If a unit of measure code is specified. If so, Business Central checks for prices/discounts with the same unit of measure code and prices/discounts with no unit of measure code.
Check whether price/discount agreements apply to information on the document or journal line, and then insert the applicable unit price and line discount percentage by determining:
If a minimum quantity requirement in the price/discount agreement has been fulfilled.
If a currency requirement in the price/discount agreement has been fulfilled. If so, the lowest price and the highest line discount for that currency are inserted, even if local currency would provide a better price. If no price/discount agreement exists for the specified currency code, Business Central inserts the lowest price and the highest line discount in your local currency.
The Sales Prices field in the Sales Line Details FactBox indicates if sales prices exist for an item for the customer combination that's specified on the sales line.
Business Central uses the same calculation process for purchases.
Watch the following video for a demonstration of the best price principle.