Skip to content

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.

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:

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:

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:

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.

  1. Click Add price list. The New price list window opens.
  2. 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.
  3. Type a Discount (%) or a Price. At least one of the two is needed, and greater than zero.
  4. If you want, narrow it down with Quantity from and Quantity to, and with From and To for the validity period.
  5. If the condition gives away a free item, choose the item in Gift.
  6. 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 seeWhat has happenedWhat to do
The window’s Save button is greyed outItem family and item are missing, or discount and price are missingFill 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 anythingChoose one of the two
‘Enter a discount or a price’Both are empty or at zeroType one of the two
‘The “to” quantity can’t be less than “from”.’The quantity range is the wrong way roundCorrect the range
‘The “to” date can’t be earlier than “from”.’The validity period is the wrong way roundCorrect the dates
‘The business partner has no specific price lists’ when editingThe price list was deleted in the meantimeClose the window and go back into the tab
The invoice price doesn’t respect the price listNo condition applies to that item, quantity and date, or the condition is for another item familyCheck the item family/item, the quantity band and the condition’s validity period
The line doesn’t add the condition’s giftThe free item isn’t added automaticallyAdd the gift line by hand, at zero price
I enter 1,459 and the record leaves it at 1,46It is a calculated price (from the margin) and your company works with 2 decimalsType it in the Sale price field, or raise the sales decimals in Settings
‘No price lists’ on the tabThe business partner has no conditions of their ownThat is normal. Click Add price list if you want any
A sale shows a 100 % profit in the reportWhen it was saved, the price chosen in Cost price calculation was zero on the recordSet 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 % profitIt came without a cost and the ERP doesn’t give it today’s price, which would change the profit on an old saleThat is what to expect
The % in a report isn’t what you expectedIt is on cost or on the sale depending on Warehouse price calculationCheck 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