This is what happens in the video
In Business Central you can define line discounts per item per vendor. You set them up from either the vendor card or the item card, and both views show the same underlying data. A line discount is a percentage applied on top of the purchase price, and you can make it conditional on a minimum purchase quantity and a starting date.
If you change a line discount from the item card, the change is reflected on the vendor card too, because both screens display the same records.
Defining line discounts per vendor and item in Business Central
Business Central lets you set up line discounts that apply to a specific combination of vendor and item. You can reach this setup from two places: the vendor card or the item card. Whichever way you choose, you are editing the same data.
The purchase discount is a percentage taken from the purchase price. If you have also defined specific purchase prices for the vendor and item, the line discount is applied on top of that price.
Setting up line discounts from the vendor card
Open the vendor you want to work with, for example vendor number 80000. From the vendor card, go to Navigate, then Purchases, and open Line Discounts.
Here you can see and create the discount lines for that vendor. Two examples show how flexible this is:
- On item number 1110, the vendor gives a line discount of 15%, starting from 1 June, when you buy at least 50,000.
- On item number 1120, the line discount is 10% when you buy at least 150,000, with no starting date.
This shows that you can attach both a minimum quantity and an optional starting date to each discount line.
Setting up line discounts from the item card
You can manage the same discounts from the item side. Open the item, go to the purchase prices and special discounts, and you will find the same lines with the same data.
Because the vendor card and the item card point to the same records, any change you make in one place appears in the other. If you edit a discount from the item list, the vendor list shows the updated value automatically.
Q&A
Can you set line discounts per item per vendor in Business Central?
Yes. Business Central lets you define line discounts for a specific combination of vendor and item, and you set them up from either the vendor card or the item card.
How does a line discount relate to the purchase price?
A line discount is a percentage taken from the purchase price. If you have also defined specific purchase prices for the vendor and item, the line discount is applied on top of that price.
Can you make a line discount depend on quantity or a starting date?
Yes. You can require a minimum purchase quantity and set an optional starting date for each discount line. For example, 15% on item 1110 from 1 June when buying at least 50,000, or 10% on item 1120 when buying at least 150,000 with no starting date.
If you change a line discount on the item card, does it update on the vendor card?
Yes. The vendor card and the item card display the same underlying data, so a change made in one place appears in the other.