Price lists - Calculation methods
Description

TIP: For more information on price lists including how to create them - Read more >


Calculation Method drop-down list

Fixed Price

Use this to enter a fixed price, which does not change even if the sales price changes.

Standard Sales Price

Uses the standard sales price on the product record.

Decrease Sales Price By %

Calculates and deducts the percentage from the standard sales price.

As the sales price on the product record changes, your price list price also changes so that it is always reduced by the percentage you enter.

Decrease Sales Price By Value

Deducts the value entered from the standard sales price.

As the sales price on the product record changes, your price list price also changes so that it is always reduced by the value you enter.

Markup % on Cost Price

Calculates and adds the percentage mark up to the cost price.

As the cost price on your product record changes, the price list price also changes by the percentage entered.

Markup Value On Cost Price

Adds the value mark up you enter to the cost price.

As the cost price on the product record changes, the price list price also changes by the value entered.

Increase Sales Price By %

Calculates and adds the percentage to the standard sales price.

As the sales price on the product record changes, your price list price also changes so that it is always increased by the percentage.


Value

Enter the amount or percentage to be used to update the selected price list items.


Rounding Direction options

Use the Rounding Direction information to specify how you want to round any values.

Round up to

Rounds any totals up to the number of decimal places you choose from the Decimal Places drop-down list.

For example, 6.55555 rounded up to 2 decimal places is 6.56.

Nearest

Rounds any totals to the nearest value you choose from the Decimal Places drop-down list.

Round down to

Rounds any totals down to the number of decimal places you choose from the Decimal Places drop-down list.

For example, 6.55555 rounded down to 2 decimal places is 6.55.

To

Select this to round to a specific number of decimal places from 0, 1 or 2. From the drop-down list choose the number of decimal places you want to round to.

Multiples of and plus adjustment

Select this to round to a specific number. For example, to round to the nearest 0.99 enter a value of 1.00 and in the plus adjustment enter -0.01. So if you entered a price of 10.00 this rounds down to 9.99.

Due to rounding calculations, the Profit Margin % column may differ between each row.