In Business Central, prices are calculated based on a combination of factors, including the item's unit price, line discounts, and potentially special pricing setups. The system automatically determines the best price based on these factors, optimizing for the user's profit margin.
Business Central supports various pricing strategies, such as:
One-price-fits-all models where an item is always sold at the same price.
Special price agreements with specific customers, or groups of customers.
Campaigns when a sale meets the criteria for a special offer. For example, you might have the following criteria for an order:
It meets a minimum quantity
It's before a certain date
It includes a certain type of item
After you record special prices and line discounts for sales and purchases, Business Central calculates the best price on sales and purchase documents, and on project and item journal lines.
The best price is the lowest price with the highest line discount allowed on a given date.
The best price is the lowest price with the highest line discount allowed on a given date. Business Central calculates best prices when it adds unit prices and the line discount percentages on document and journal lines.
Business Central checks the combination of the bill-to customer and the item and then calculates the applicable unit price and line discount percentage, using the following criteria:
Does the customer have a price/discount agreement, or does the customer belong to a group that does?
Is the item or the item discount group on the line included in any of these price/discount agreements?
Is the date within the starting and ending date of the price/discount agreement? For invoices and credit memos, this is the date in the Posting Date field on the document header. For all other documents, it's the date in the Order Date field on their headers.
Is a unit of measure code 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.
Business Central checks whether any price/discount agreements apply to information on the document or journal line. It then inserts the applicable unit price and line discount percentage using the following criteria:
Is there a minimum quantity requirement in the price/discount agreement that is fulfilled?
Is there a currency requirement in the price/discount agreement that is 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 there's no price/discount agreement for the specified currency code, Business Central inserts the lowest price and the highest line discount in your local currency.
If no special price can be calculated for the item on the line, then either the last direct cost or the unit price from the item card is inserted.
