Hi there,
I've been trying to migrate my company's stock databases, which are currently held in MS Excel, into OpenERP 7. I have exported the data as a CSV from Excel, imported the file to OpenERP, and assigned fields to each column label. OpenERP validates the the CSV and imports it fine.
The problem is, it then creates a new inventory for each product (all with the same inventory reference), rather than creating one inventory containing all products in the CSV. Consequently I have several hundred physical inventory entries at the end of the process, and furthermore as OpenERP is seeing these as inventories not products I am not able to track stock levels or create re-order rules or anything of that ilk. Can anyone advise what I might be doing wrong? Any help would be greatly appreciated.
All the best,
Adam
Were you able to get this resolved? I am having the exact same problem.
see this: http://help.openerp.com/question/28203/importing-a-csv-to-physical-inventory-problem/?comment=28213#comment-28213