The cost prices are calculated by AVCO, depending on the supplier orders. The sales prices are calculated by formula on the price lists.

Is there a way to fill in the margins with values based on UoM? For example €2/m?

At the moment we can not use AVCO because of this issue. The temporary solution is to export all products to xlsx and add a certain minimal margin by UoM manually, then saving this as the "base price list" with fixed price. By creating extra pricelists we can add a negative percentual discount to that "base price list", and hereby create different price categories for different customers.

Because of huge changes in costs (up as wel as down) we can not use percentual margins (5%)or absolute margins (base price + €10) for our "base price list". Prices change about daily ...

An example:

The product now cost €15/m, by adding €2/m we set our base price. Min margin €2/m and max margin €10/m.

As the cost rises to €40/m (not uncommon), we keep adding the same €2/m. This results in a price of €42/m.

On the other hand the price may fall to about €5/m, here we also add the €2/m. This results in a price of €7/m.