Multiple unit prices on an item
You can define item prices on the POS according to the sold quantities.
If an item’s standard unit price is 250.00 and you want to set a specific price for a quantity range, you can take the following approach:
| Quantity | Unit Price | Unit Price | Explanation |
|---|---|---|---|
| 2 | 225.00 | 450.00 | If the item quantity reaches 2 units, the unit price is 225.00. |
| 4 | 200.00 | 800.00 | When the quantity reaches 4 units, the unit price will change to 200.00. |
| 6 | 250.00 | 1500.00 | When the quantity reaches 6 units, the unit price will change back to the standard price of 250.00. |
- If the quantity is 2 or 3, the unit price is 225.00 per unit.
- If the quantity is 4 or 5, the unit price is 200.00 per unit.
- If the quantity is 6 or higher, the unit price is the standard price.
The function to define this scheme is found on the Item Card itself, under Special Sales Prices & Discount > Multiple Unit Price.
| Quantity | Unit Price | Example |
|---|---|---|
| Main No. | The item code. | 10010 |
| Description | The short description of the item category. | Multiple Price Levels |
| Status | The status of the scheme. | Active |
| Modified Date | The date on which the latest changes are performed on the page. | System-generated |
| Block Custom Discount | Block the related record to prevent it from being used. | Deactivated |
| Base Unit of Measure | The base unit used to measure the item, such as a piece, a box, or a pallet. | PCS |
| Starting date / Closing date / Starting Time | The date & time range for the scheme. | |
| Global 1/Global 2 | Global dimension values as a condition for applying the scheme. | |
| Service Item Group | You can specify the code for the service item. Whenever this item is purchased, a service contract for the item is created in parallel. | Leave it blank. |
| Multiple Unit Price | The details of the multiple lines and the unit price that applies to them. |
Multiple unit prices on an item – Business Central
The concept of Multiple Unit Price in Business Central is a bit different than it is in NP Retail. In Business Central, when you define the levels, the quantity is considered as an absolute value, and not a range of values.
So, in the case of the example stated above, the following would be true:
| Quantity | Unit Price | Unit Price | Explanation |
|---|---|---|---|
| 2 | 225.00 | 450.00 | For the quantity of 2, the unit price is 225.00. |
| 4 | 200.00 | 800.00 | For the quantity of 4, the unit price is 200.00.. |
| 6 | 250.00 | 1500.00 | For the quantity of 6, the unit price is 250.00. |
- If the quantity is 2, the unit price is 225.00 per unit (multiple sales price).
- If the quantity is 3, the unit price is 250.00 per unit (normal unit price).
- If the quantity is 4, the unit price is 200.00 per unit (multiple sales price).
- If the quantity is 5 or higher, the unit price is 250.00 per unit (normal price).
The Business Central function to define this multiple price scheme is found on the Item Card, under Special Sales Prices & Discount > Sales Price > Sales Price List.