Price via calculation

When you add sales prices, you can select to have the price determined using a calculation. The calculation is then a percentage on top of theCurrent purchase price (CPP), the Current cost price (CCP) or the Current settlement price (CSP). You can have the calculated sales price rounded too. If you change the price the calculation is based on, the calculated sales price automatically changes too.

If your sales price always should be 25% higher than your purchase price, you only specify the purchase price for an article and calculate the sales price based on the current purchase price.

If you select the Price via calculation check box and the price on the basis of which you determine the sales price is €0.00, the sales price also is 0.00. The calculated sales price appears after the rounding has been set.

Example: 

The current purchase price of an article is €185. You want the sales price to be 25% higher than the current purchase price. You enter 25 as the percentage. In that case, the sales price is €231.25. The percentage you enter is added to the price!

Two months later, the purchase price changes to €200. The calculated sales price now is €250.

To determine a sales price from a calculation:

  1. Go to: the sales price you want to have determined using a calculation, for example to Order Management / Sales / Price/discount / Sales price.
  2. Click on: New. 
  3. Select an Item code and/or Unit and Item type.
  4. Click on: Next. 
  5. Select the Price via calculation check box.

  6. In Percentage, enter a percentage that will be calculated over the Calculation basis.

    You can also enter a negative percentage.

  7. In Calculation basis, select the price to be used as the calculation basis for the percentage, the Current purchase price (CPP), theCurrent cost price (CCP) or the Current settlement price (CSP).
  8. In Rounding, select the rounding method.

    In the grey Calculated price field, the price calculated on the basis of the selection then appears.

  9. If required, complete the other fields such as the dates, etc.
  10. Click on: Finish. 

Directly to

  1. Prices (Sales)
  2. Overview of price terminology
  3. View the prices by article
  4. View the prices by sales contact
  5. Add a price for each sales contact
  6. View all prices/discounts per sales contact
  7. Manually change a price in a line
  8. Price by calculation
  9. Calculate the cost price and the transfer price
  10. Sales price
  11. Price list
  12. Promotional price
  13. Add volume prices
  14. Collective price changes
  15. Import prices
  16. Import a ladder when importing a sales price