Calculate sales price from standard cost
You can have automatic sales price calculation for items that do not have any
prices in Sales Prices entered. This works independently from the Base Price
List setting, but if the factor is set in the other Sales Type Lists it works
together with them.
Preparing and operation
Go into Setup tab - Company Setup.
In the field, Base for auto price calculation, set a Base Price List.
In the field, Add Price from Std cost, enter the % that you want to increase
from the average standard costs for the items not listed in the Item Price List.
If this value is empty there are no automatic price calculations. BE aware that
an increase value of 0 will calculate the price to be the same as the Std cost.
So to remove the calculation, just empty the field. It will then get an internal
value of -1.
If the average standard costs is 0, the calculation would result in 0 as well.
The field, Round to nearest xxx Cents, will round the calculated result to the
nearest Cent entered. If you have 2 decimals in the amounts the value 100 would
be divided by the xxx value. If you have 3 decimals in the amounts the value
1000 will be divided by the xxx value. If there is no fraction, the value will
be rounded up to the nearest xxx value. If there is a fraction, the value xxx
will be subtracted from the value (100-xxx) or (1000-xxx).
Let us take an example:
Item standard cost = 20.77
Decimals = 2
Value to increase the items with = 70 (%)
Round to nearest value = 5
the pow(10, 2) = 100. 100 divided by 5 = 20 and no fraction. Price after increase
= 20.77 * (1 + 70 / 100) = 35.309. Rounded to nearest 5 cent value = 35.35;
Let us set the Round to nearest value = 95.
The value 100 / 95 = 1 and a fraction of 95. The Price will still be calculated
to 35.309. Now the value will be rounded to 36.00 and subtracted by (100 - 95) =
35.95.
So you see it is very flexible. If you have larger prices you can even round up
to nearest 10, 100 by setting the rounding to nearest value = 1000 or 10000. \\
But take care if you have different prices, large prices and small prices. It might
not be a good idea to round a value of 10.77 to 100.
If there is a base price list set and for instance a factor 0.7 the price list in
foreign currencies are calculated as well. And again, if a 'Round to nearest' value
is set to other than 1 the foreign prices are rounded in the same way as explained
above.
This new price calculation should work with sales kits too.