In this article
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:
Qty From | Qty To | U of M | Price |
1 | 100 | Each | 1.50 |
|
200 | Each | 1.25 |
|
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:
Qty From | Qty To | U of M | Price |
1 | 100 | Each | 1.50 |
|
200 | Each | 1.25 |
|
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:
Qty From | Qty To | Flat Amount |
1 | 50 | 100.00 |
|
200 | 150.00 |
The following invoices show the unit prices with the different quantities purchased:
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 |