How to change/edit the Product Price

The Price Calculator is used when you want to calculate the optimal retail price for a product, when you want to set prices determined by date and when you want to enter fixed prices in different currencies.

Adding/editing the default sales price in company currency

The Standard and Advanced tabs within the Price Calculator help you to find your optimal sales price, i.e. by calculating the cost price, gross profit and retail price. You can experiment with different prices and gross profit margins, making it easier to optimise the combination.

How to add/change the price for a product

  1. Open View - Product - Product Register, tab Price.
  2. Is the company setting for products Company wants to track the price history for products under View - Settings - Company - Settings per module - Product activated? If so, then select the price line and click Edit to edit an existing price. If you want to add a new price, click New.

    If this setting has not been activated? Then click the button Price Calculator in order to change the existing product price. You cannot add further prices.

  3. Enter Date and Time in the Prices valid from field.
  4. Then enter a Description in the field below, for example "autumn sales". It is not mandatory to enter anything in this field.
  5. In the Standard tab you can enter the most common price adjustments while in the Advanced tab you can perform more advanced calculations.

    Enter the Cost price, Expenses in terms of labour, warehousing, transport etc. The Cost price field displays the Purchase price and Expenses.

    Gross profit can be entered as either a Factor, Amount or as a Percentage. If you enter an amount the percentage is automatically calculated. Furthermore, if you enter a percentage or a factor the amount is also calculated automatically.

    Note! If you make changes to the Cost price or Gross profit you must select how this will influence the price calculation. You do this in the drop-down list to the right of the window.

  6. Click OK.

The new price is now being saved.

You can change the price for several products at once with the help of the Price Adjustment function. Find out more in Changing Prices for a Selection of Products.

Fixed prices in different currencies

Under the Currency tab, you can add fixed sales prices for products in one or more different currencies than the company currency. You can, for example, define a sales price in Euro which is individually adjusted to the continental market.

Settings

To activate the setting for fixed prices in different currencies, open the company settings for products. Make sure the check box Company wants to track the price history for products is activated and then select Company sells products with fixed prices in different currencies.  

In the Currency Register under View - Accounting - Currency, the check box for all currencies you want to add fixed prices for, has to be activated in the column Show.

Note! A fixed price in a different currency on product level is independent from the exchange rate defined in the Currency Register. Nevertheless, you should always have an updated Currency register with actual exchange rates for all currencies you trade with. The exchange rate is also displayed on the Currency tab in the Price Calculator and influences the values displayed in several columns. It helps you to get a proper overview of e.g. the Variance between the foreign currency and your company currency. Read more about the Currency Register in Currency.

How to enter fixed prices in different currencies

  1. Open the product you want to add a fixed price in a different currency for via View - Product - Product Register.
  2. Select the price line with the correct company price on the Price tab. Click Edit.
  3. Open the Currency tab and click New.
  4. Select the Currency from the list and enter the sales price in this currency under Sales price in currency.
  5. Click OK to save the new sales price in the different currency.
  6. You can now find the new sales price in the list of the Currency tab.

    Tip! It is possible to see how much the Sales price in the different currency differs from your sales price in company currency (column Variance). A negative value indicates a lower sales price in the different currency. Furthermore, you will find the Gross profit (GP) and the new Sales price both in the different currency (Sales price in currency) and re-calculated into your company currency (Sales Price (<company currency>)). All this information will help you to find the correct sales price.

  7. If necessary, adjust your sales price via Edit
  8. To save the sales price, click OK.

You have now defined a fixed sales price in a different currency. You will also find the fixed sales price on the Price tab of the Product card, below the respective sales price in company currency .

Read more about:

Product Prices

The Price Tab in the Product Register

The Product Register

Price Adjustment

Company Settings for Products