How does Item Purchase Prices and Discounts work? (VIDEO)

How does Item Purchase Prices and Discounts work? (VIDEO)

How does Item Purchase Prices and Discounts work?

VIDEO: How does Item Purchase Prices and Discounts work?

If you have defined specific prices per item, per vendor, it will have effect when you create purchase order lines for that vendor for that item.

Let’s take an example here from my item 1120.

If I go from navigate into my special prices, I could define special prizes or special discounts.

And that’s actually defined by fixed price or by percentages.

Here in the overview, I can see a mix of both of them.

So I can see I have one line discount for that item, saying a minimum 150 pieces, line discount 10% from vendor number 88,000, in euro.

And I could see different purchase prices, some of them also from the same vendor in euro, one of them with the starting date that is not active yet, when we speak and I can see the Euro amount here.

And of course, I also have my list price on the item card.

So in this example, I can see if I buy from my vendor 88, 000.

And I buy more than 100,000 there will be no special prices defined in that scenario.

So let’s try to make a purchase order.

And we define a new purchase order for that vendor just to see how it works.

And we enter the item number here on the purchase line.

And quantity one, and I can see now the 0.

2 euro is the list price from the item card transferred into euro because this vendor is set up with euro.

Whereas if I enter 100,000 pieces, which was one of the criteria.

And I leave the lines who have updated, whereas if we enter 100,000 pieces, which was one of the criteria, I can see my price changing to 0.

112 euro with a sum of 11,200 because that’s the one of the fixed prices and again if I change my quantity to 150,000 like this, I can see my price being the same but if I calculate 0.

112 times 150,000, I can see that this is only 0.9 factor of that, because I’ve added 10% from the line discount.

So this is how it works automatically on the purchase order once the price is set up correctly.


    • Related Articles

    • Setting up Item Purchase Discounts (VIDEO)

      How to set up item purchase discounts in Business Central? VIDEDO: Setting up Item Purchase Discounts It is possible to define line discounts per item per vendor in Business Central and that is set up either from the vendor card or from the item ...

    • Setting up Item Purchase prices (VIDEO)

      How to set up item purchase prices in Business Central? VIDEO: Setting up Item Purchase prices Item purchase prices in Business Central can be set up either on the items, or from the vendors. So first of all, let’s look on the items and we take an ...

    • Set Up Prices and Discounts

      Set Up Prices and Discounts Article 09/18/2022 7 contributors Feedback In this article Setting Up Prices and Discounts About Price Lists Set Up Prices To set up a sales line discount for a customer Show 5 more Note In 2020 release wave 2, we released ...

    • How to use posting groups on item charges in business Central?

      In Business Central, you can set up posting group on chart items or item charges, to define which accounts to post to when you use item charges on, basically purchase orders but also on sales orders. See Video So, these are my item charges. Here, I ...

    • Process Purchase Returns or Cancellations

      In this article Inventory Costing To create a purchase credit memo from a posted purchase invoice To create a purchase credit memo by copying a posted purchase invoice To create a purchase return order based on one or more posted purchase ...