ERROR Conversion Factor is mandatory - Importing Sales Invoice + Purchase Invoice

Hey ERPNext Community,

I am just importing several CSVs from v7 to v10 via Import Tool and bench csv-import.

Especially on Sales and Purchase Invoice there is a Error I cannot get over and it says:

Error for row "SINV-12345"Row 2: Conversion Factor is mandatory

Error for row "PINV-12345"Row 1: Conversion Factor is mandatory

When I enter a Conversion Factor like “1” the Error changes to the following:

Error: Sales Invoice Item Row #1: Value missing for: UOM

Thank you


You need to add column UOM, Conversion Factor in the CSV file against each item for sales invoice and purchase invoice. Better download the template from v10 and add the data from v7 CSV file.

Hi Rohit,

this is what I wrote and already did. But then this error shows:

Sales Invoice Item Row #1: Value missing for: UOM

I have added UOM (Unit/Hour etc.) and UOM Factor (1) in the colums and already compared V10 and V7 csv and added the UOM Factor.

In Purchase Invoice this is working somehow but not in Sales Invoice.

Thank you.


In that case it should be work, I have also checked on my local account and it’s working properly. Is there any error traceback on console log? If yes, please share.

There is no special error traceback, only what I have pasted here.
I see one column for UOM and one for UOM conversion factor.
Should there be another UOM field maybe, because when UOM and Factor is filled, it says UOM value is missing like on my first post?