Create a Dynamic UOM conversion calculator table

ERPNext Customize ERPNext
1

Hi everyone! i am new to ERPnext. I want to create a UOM conversion calculator for the products sold. But i was not able to get the conversion rate of an item to another Doctype and calculate it:

  1. I have Created a product with Kg as its default value and i have set the conversion value in items. in Items
  2. I want to create the table in the quotation with a conversion calculator the concept is somewhat like this:

capture%201
capture%2011481×812 66.4 KB

any help will be much appreciated! thank you

2

How is your conversion values in the Item master? Did you examine https://docs.erpnext.com/docs/user/manual/en/buying/articles/purchasing-in-different-unit ?

3

I have pre set the conversion values in the Items as follows:

UOM
UOM943×310 10.9 KB

The conversion works just fine its just that if customer request purchase in Kg the sales must know how many Rolls is used for the purchase (If the Rolls is in the Float value the customer should buy the next whole number of the roll value) Thus the calculator serve the purpose so sales can quickly and accurately determine how many Kg customer should buy. Since Accounting and Stock manager uses Kg as their standard UOM i can’t put Roll as the default value.

Another problem i’m facing is that when i try to link UOM Conversion Factor doctype on the Quotation Item doctype it made the quotation not reponding when i try to see the breakdown of the item