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 SBS ARCB Billing Schedule Card page can be edited to any value you want.

Standard Price (no Special Prices)

When the standard pricing method (without special prices) is used, the unit price for a schedule line item is set up on the Item Card. Specifically, the unit price is from the Price & Sales FastTab and is based on the Price quantity. The Base Unit of Measure is from the Item FastTab.

Standard Price (with Special Prices)

The following example provides information standard pricing calculations when special prices are used. You can set up the special prices on the Item Card. For more information, see the Microsoft Dynamics 365 Business Central documentation.

An item has the following price brackets: 

Price Brackets Table
Qty From Qty To U of M Price
1 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: 

  • 250 x 1.00 = 250.00
  • Unit price = 1.00, which uses the price level that has the quantity of 250

Tier Price

An item has the following price brackets: 

Price Brackets Table
Qty From Qty To U of M Price
1 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 unit price is calculated as follows: 

  • 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
  • Unit price = 3.25 / 250 = 1.30

Flat Tier Price

The price brackets are set as follows: 

Flat Tier Pricing Table
Qty From Qty To Flat Amount
1 50 100.00
50 200 150.00

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

Unit Price Table
Invoice Quantity Purchased Unit Price Net Amount
1 25 100.00 / 25 = 4.00 100.00
2 20 100.00 / 20 = 5.00 100.00
3 50 100.00 / 50 = 2.00 100.00
4 60 150.00 / 60 = 2.50 150.00