ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Item UOM Conversion


#1

We buy one (01) roll of cable that have 1000 RFT and we sell in RFT to customers so how we can handle this issue?


#2

You can put two UOM one fore purchasing and one for selling
You have to add UOM Conversation factor so that can convert vice-versa like
unit roll
unit RFT
Roll = 1000*Roll


#3

How to put this conversation factor?


#4

In Item Master you will find section called Unit of measure inside it put both uom and conversation factor


#5

Please see the following:





After all this, I see ‘Nos’ as UOM in Quotation and Sales Invoice so where did I make mistake?


#6

You need to put 0.001 conversation factor for RFT for this
as 1/1000


#7

Once you mentioned the UoMs in the item master, you can change it in the line item in any transaction:


#8

Hi, I can see in the screenshots you provide above that you have Nos as your Default Unit of Measure. Since you stock and sell in RFT, RFT should be your Default UoM, not Nos.


#9

Is there a way to bulk update the UOM conversion table for individual items?


#10

It depends… If you DON’T have transactions, download the items base, in the import tool, change it in Excel, then upload the file updating the infos…

If you DO have transactions, duplicate the item, change the configs, then freeze the original.

I guess…


#11

Thanks for the response.

Also got feedback elsewhere to check documentation https://erpnext.com/docs/user/manual/en/setting-up/data/data-import

Particular section 4. Uploading All Tables (Main + Child)

Basically, new line for child table entries.