Language:


Prices - Quantity Dependent Prices

After you have created a Price List, you will be ready to enter the prices for that Price List. These prices can be stored in one of two places, depending on the Type of the Price List:
  • If the Type of a Price List is "Discount" or "BuyBack", its prices will be stored in the Price register in the Pricing module. These Price Lists can contain a single price for each Item.

  • If the Type of a Price List is "Qty Dep Values", its prices will be stored in the Qty Dependent Prices setting, also in the Pricing module. These Price Lists can contain several prices for each Item, allowing you to charge different prices for an Item depending on the quantity that you sell.
This page describes the Qty Dependent Prices setting. Please refer here for details about the Price register. If you want to offer discounts based on the quantity that you sell (rather than changing the price), use a Discount Matrix instead of a "Qty Dep Values" Price List. Discount Matrices are described here.

The Quantity Dependent Prices setting is in the Pricing module. To work with this setting, first ensure you are in this module. Then, if you are using Windows or Mac OS X, click the [Settings] button in the Navigation Centre and then double-click 'Qty Dependent Prices' in the 'Settings' list. If you are using iOS or Android, select 'Settings' from the Tools menu (with 'wrench' icon) and tap 'Qty Dependent Prices' in the 'Settings' list. The 'Qty Dependent Prices: Browse' window opens, showing the Quantity Dependent Prices that you have previously entered. Double-click (Windows/Mac OS X) or tap (iOS/Android) a Quantity Dependent Price in the list to edit it, or add a new record by selecting 'New' from the Create menu (Windows/Mac OS X) or the + menu (iOS/Android). When the record is complete, save it by clicking the [Save] button (Windows/Mac OS X) or tapping √ (iOS/Android) in the Button Bar. To close it without saving changes, click the close box (Windows/Mac OS X) or tap < (iOS/Android).

Item
Paste Special    Item register
Specify the Item for which you are entering Quantity Dependent Prices.

If you enter a Quantity Dependent Price record for an Item that has its pricing controlled by Item Formula, the Quantity Dependent Price record will be ignored.

Price List
Paste Special    Price List register, Pricing module
Specify the Price List for which you are entering Quantity Dependent Prices.

You will not be able to enter more than one record in the Quantity Dependent Prices setting for the same Item/Price List combination.

Comment
Enter a description or comment about the Quantity Dependent Price record here. This comment will be shown in the 'Quantity Dependent Prices: Browse' window.

Sales A/C
Paste Special    Account register, Nominal Ledger/System module
If you specify a Sales Account here, it will be used as the Sales Account in Invoices where pricing is determined by the Quantity Dependent Price record (i.e. by the unique record for the Item/Price List combination). This Account will take priority over those for the Item and Item Group and that in the Account Usage S/L setting. Please refer here for more details about how Sales Accounts will be chosen in Quotations, Orders and Invoices.
Use the matrix to list the unit prices that you will charge for the Item, depending on the quantity that you sell. In the example illustration, the price for Item 10101 will be as follows:

Quantity SoldUnit Price
130.00
2-429.00
5-928.00
10 and over27.00

In this example, we have used the Price column to specify an absolute price for each quantity break. You can instead use the Formula column if you need each price to be calculated using a formula: use 'Paste Special' to choose the correct Price Formula. Using a Formula could mean less maintenance because if the calculation base (e.g. the Base Price) changes, the quantity prices will change automatically.

If the Price List in the field above the matrix is one that includes VAT, the prices that you enter in the matrix should include VAT. If the Price List has a Currency, these prices should be in that Currency.

You should enter the lowest quantity in the quantity break in the Qty Limit field i.e. treat the quantity as a “Quantity From”. In the first row you will usually enter 0 or 1 as the Qty Limit or leave the field empty. If you enter a higher quantity in the first row, you risk selling for a zero price. For example, do not enter 10 as the Qty Limit in the first row intending this to mean “up to 10”. It will be interpreted as “10 or more”, and a sale for a lower quantity will be given a zero price.

When you create a sales transaction (i.e. an Order, Quotation or Invoice) in the name of a Customer that uses a "Qty Dep Values" Price List, the Price List will determine the Prices in the sales transaction. When you add an Item to the transaction, its Unit Price will be chosen as follows:

  1. It will be taken from the Quantity Dependent Price record with the relevant Item/Price List combination. When you change the Quantity in the sales transaction row, the Unit Price will be updated.

  2. The Base Price from the Item record will be used.
In a row where pricing is determined by a Quantity Dependent Price record, the Unit Price will be updated automatically when you enter or change the quantity:

This example Invoice is for illustrative purposes only, to show the Unit Prices for different quantities. As the illustration suggests, the quantity pricing is applied to each row individually. So, you should enter the full sales quantity in a single row to give the maximum possible discount.

---

The Pricing module in Standard ERP:

Go back to: