Pricing Methods

You can use one of the following pricing methods to calculate the unit price of an item: 

  • Flat (no example)
  • Standard
  • Tier
  • Flat Tier

Flat

When the flat pricing method is used, the unit price for a schedule line item on the page can be edited to any value you want.

When the flat pricing option is used, the Price unit is always 1. As a result, the Unit price and the Net amount for an item are the same.

Standard Price (no Trade Agreement)

When the standard pricing method (without a trade agreement) is used, the unit price for a schedule line item is set up on the Release product details page. Specifically, the unit price is from the Base Sales Price section and is calculated as follows: Price / Price quantity.

Standard Price (with Trade Agreement)

The following example provides information standard pricing calculations when a trade agreement exists. You can create trade agreements from the Release product details page. For more information, see the Microsoft Dynamics 365 for Finance and Operations documentation.

An item has the following price brackets: 

Qty From Qty To U of M Price
0 100 Each 1.50
100 200 Each 1.25
200 99999 Each 1.00

Using the price brackets, assume the invoice quantity is 250. With the standard pricing method, the unit price is calculated as follows: 

  • Quantity 250 is in the price quantity range 200 - 99999 , so the unit price is 1.00
  • Net amount = (Quantity * Price) / Price unit = (250 * 1.00) / 100 = 2.50

Another example for an invoice quantity of 100. With the standard pricing method, the unit price is calculated as follows: 

  • Unit price = 1.25, which uses the price level that has the quantity of 100
  • Net amount = (100 x 1.25) / 1 = 125

Tier Price

An item has the following price brackets: 

Qty From Qty To U of M Price
0 100 Each 1.50
100 200 Each 1.25
200 99999 Each 1.00

Using the price brackets, assume the invoice quantity is 250. With the tier pricing method, the net amount is calculated. After calculating the net amount, you can obtain the unit price by dividing the new amount by the quantity. Review the sequence of events to obtain the unit price: 

  1. Get the prices of the items based on the pricing brackets: 
    • First hundred items: 100 x 1.50 = 150.00
    • Second hundred items: 100 x 1.25 = 125.00
    • Remaining items: 50 x 1.00 = 50.00
  2. Get the net amount.
  3. Net amount = (150.00 / 100) + (125.00 / 100) + (50.00 /100) = 1.50 + 1.25 + 0.50 = 3.25

  4. Use the net amount and quantity to obtain the unit price.
  5. Unit price = 3.25 / 250 = 1.30

Flat Tier Price

The price brackets are set as follows: 

Qty From Qty To Flat Amount
0 50 100.00
50 200 150.00

The following invoices show the unit prices with the different quantities purchased: 

Invoice Quantity Purchased Unit Price Net Amount
1 25 2 / 25 = 0.08 100 / 50 = 2.00
2 20 2 / 20 = 0.1 100 / 50 = 2.00
3 50 2 / 50 = 0.04 100 / 50 = 2.00
4 60 0.75 / 60 = 0.0125 = 0.01 150 / 200 = 0.75