Calculation in Fields selling rate = valuation rate multiplied by gross margin

Hello all

I am trying to set up a scenario where when creating an item, the user enters in the valuation rate, proposed gross margin and the standard selling rate is calculated.

I have created a custom field called gross margin (gross_margin)

I want to make the default value in the standard selling rate = valuation rate multiplied by gross margin.

What formulae do I key in to the default value of standard rate to make this possible?

Regards

You can somewhat manage this using standard features.

In the selling transactions, fetch item’s pricelist rate from Buying Price List. In the Discount and Marging section, enter your margin.

(Buying) Price List Rate + Margin = Selling Rate

https://erpnext.org/docs/user/manual/en/selling/articles/adding-margin

1 Like