How do I set prices and price lists?
An item’s price lives on its record, in six sale levels. A price list is something else: it is the set of price list conditions —discounts or special prices— of a particular business partner. The two are edited in different places and do different things.
Where do I put an item’s price?
On the item record, Prices tab. It has two blocks.
The Purchase block stores what it costs you: Base purchase price, Purchase discount (as a percentage) and Associated costs. From these three comes the Final purchase price, which isn’t typed in: it is calculated automatically with the formula ‘base minus its discount, plus costs’.
The Margins and sale prices block has six pairs: Margin 1 with Sale price 1, Margin 2 with Sale price 2, and so on up to 6, the same six prices as the Desktop ERP. The margin is a percentage on the Final purchase price.
The purchase details are unique to the item. The six levels only differ in their margin and their sale price.
Each customer is invoiced at the price chosen on their record (Price list level, from Price 1 to Price 6). If the item doesn’t have that price set, the sale uses Sale price 1.
How are the margin and the sale price related?
They are tied together: when you change one, the other is recalculated automatically. You don’t have to balance them by hand.
If you type a Margin, its Sale price is recalculated as ‘final purchase price plus that margin’. If you type a Sale price, its Margin is recalculated as the margin that price implies on the cost.
If you change any detail in the Purchase block, the Final purchase price is recalculated and, with it, the six sale prices, keeping each level’s margin. A level you do not use —no price and no margin— stays empty: it does not become the cost.
When the Final purchase price is zero, there is no margin to calculate: the margin stays at zero and the sale price you type is kept exactly as it is.
How many decimals do prices work with?
As many as your company says, in Settings → Sales and documents → Prices → Numeric precision:
- Decimals in sales prices: those of sale prices, customer price lists and sales document lines.
- Decimals in purchase prices: those of the purchase block, supplier price lists, costs and purchase document lines.
Both accept from 0 to 4 and come set to 2. With 3, a price of 1,459 € is saved, shown, reaches the invoice and is printed with its three decimals. Some sectors need it: fuel, screws and fixings, bulk goods.
The number is a minimum, not a cut-off. With 2 decimals, a price of 100 is shown as ‘100,00’; but if a price has more (for example, one that came from working with 3), they are all shown. That way an invoice’s price always matches its amount.
A price you type is saved exactly as you type it, up to 4 decimals. A price the program calculates (the sale price from the margin, or the final purchase price) is rounded to the configured decimals.
Amounts (line total, tax base, VAT and document total) always have 2 decimals: they are euros and cents.
Which price level is used when invoicing?
Sale price 1 is always used. Levels 2, 3 and 4 are stored, but they aren’t chosen automatically when making a document.
If the item works with sizes and colours, and the variant you are selling has its own price, the variant’s price is used. If the variant doesn’t have one, the item’s Sale price 1 is used.
On the document line you can always type over it with the price you want.
What cost is used to calculate the profit on what I sell?
Each sales line stores the item’s cost at the moment it is sold. Profit reports use it, such as Profit summary by customer: without it, what was sold would show a 100 % profit.
Which price is taken is decided by Settings → Sales and documents → Prices → Cost price calculation:
- On the normal price: the Final purchase price on the record.
- On the average purchase price (the default).
- On the last purchase price.
- On the stock price: the average price of what you have in the warehouse.
The cost is stored when the document is saved, on quotes, sales orders, delivery notes, invoices, credit notes and receipts. Once stored it doesn’t change, even if the item’s price or the option changes later: the profit on a sale is the one from when it was sold. If you edit the document, only new lines and the ones that change item are valued.
Some lines already bring their cost and aren’t touched: those of a composite item, whose cost comes from its components, and those of invoices that come from the Desktop ERP. Lines without an item have no cost. Purchases don’t carry this cost.
What is the profit % in reports calculated on?
It is decided by Settings → Sales and documents → Prices → Warehouse price calculation:
- With Profit on final purchase price or Discount on base purchase price, the % is on the cost: sold at 100 with a cost of 80 is 25 %.
- With Profit margin on sale price, it is on the sale: the same case is 20 %.
That is how profitability reports and the assistant calculate it when you ask about the margin. The Profit summary by customer is always on cost, whatever the option.
This option doesn’t yet change how the Sale price is calculated on the item record: there the margin is still a percentage on the Final purchase price.
How do I give a customer a price list?
On the customer record, Price lists tab.
- Click Add price list. The New price list window opens.
- Choose a Family, an Item, or both. With an item family only, the condition applies to the whole item family. With an item only, it applies to that item even if it has no item family. At least one of the two is needed.
- Type a Discount (%) or a Price. At least one of the two is needed, and greater than zero.
- If you want, narrow it down with Quantity from and Quantity to, and with From and To for the validity period.
- If the condition gives away a free item, choose the item in Gift.
- Click Save.
The first condition you add creates the customer’s own price list. You don’t have to create it beforehand.
When you add the customer, the Price lists tab is also available: the conditions you type there are saved together with the customer, in the same operation. On an existing customer, each condition is saved separately as soon as you click Save.
How do I give a supplier a price list?
The same as for a customer, but from the Price lists tab of the supplier record.
A supplier’s conditions are for purchases and don’t get mixed up with sales ones. The same business partner can have both at the same time: one price list as a customer and another as a supplier, each with its own conditions.
Are price lists applied automatically when making an invoice?
Yes. When the item on a line is resolved, the program looks for the price list condition that applies to it and applies it: if the condition has a Price, it replaces the suggested price; if it has a Discount (%), it is set as the line discount.
The search order is fixed: first the business partner’s own conditions (those on their Price lists tab), then those of the price list chosen in the document header. Within each one, the item condition beats the item family one. Only one condition is applied, the most specific.
The Quantity from/to bands also count: when you change the line quantity, if a condition starts to apply (for example, ‘from 3 units’), the price or the discount is updated automatically. A price you typed by hand isn’t touched while no condition applies.
This works the same way in purchases: a condition agreed with the supplier beats the last price you bought at from them.
Two things it doesn’t do: the item chosen in Gift doesn’t add the free item line on its own, and the Discount on the customer’s Financial tab plays no part in the calculation.
How do I edit or remove a price list condition?
On the record’s Price lists tab, each row has two buttons at the end: Edit price list and Delete price list.
Edit price list opens the same window with the details loaded and the title Edit price list. When you save, the condition keeps its position in the list.
Delete price list asks for confirmation and removes the condition. The business partner’s price list stays, even if it is left with no conditions.
The search box in the header filters by item family, item, gift or description. The table is sorted by clicking Family, Item, Gift or Description.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| The window’s Save button is greyed out | Item family and item are missing, or discount and price are missing | Fill in at least an item family or an item, and at least a discount or a price |
| ‘Enter an item family or an item’ | The condition doesn’t point to anything | Choose one of the two |
| ‘Enter a discount or a price’ | Both are empty or at zero | Type one of the two |
| ‘The “to” quantity can’t be less than “from”.’ | The quantity range is the wrong way round | Correct the range |
| ‘The “to” date can’t be earlier than “from”.’ | The validity period is the wrong way round | Correct the dates |
| ‘The business partner has no specific price lists’ when editing | The price list was deleted in the meantime | Close the window and go back into the tab |
| The invoice price doesn’t respect the price list | No condition applies to that item, quantity and date, or the condition is for another item family | Check the item family/item, the quantity band and the condition’s validity period |
| The line doesn’t add the condition’s gift | The free item isn’t added automatically | Add the gift line by hand, at zero price |
| I enter 1,459 and the record leaves it at 1,46 | It is a calculated price (from the margin) and your company works with 2 decimals | Type it in the Sale price field, or raise the sales decimals in Settings |
| ‘No price lists’ on the tab | The business partner has no conditions of their own | That is normal. Click Add price list if you want any |
| A sale shows a 100 % profit in the report | When it was saved, the price chosen in Cost price calculation was zero on the record | Set that price on the record; the line is valued the next time you change and save the document |
| An invoice from the Desktop ERP shows a 100 % profit | It came without a cost and the ERP doesn’t give it today’s price, which would change the profit on an old sale | That is what to expect |
| The % in a report isn’t what you expected | It is on cost or on the sale depending on Warehouse price calculation | Check that option in Settings → Prices |
See also: Add an item · Add a customer · A business partner that is a customer and a supplier
More about Records
- How do I change the length of codes?
- What are trades for?
- What are customer types for?
- How do I classify my customers by type, route, trade and carrier?
- How do I set up my company’s sizes and colours?
- How do I add a sales agent?
- How do I add an item?
- How do I add a customer?
- How do I add a supplier?
- How do I add my customers’ vehicles?
- How do I add a currency?
- Mailing for your customers and suppliers