Skip to Content
Menu
This question has been flagged
3 Replies
5428 Views

Hi,

I've been getting started with Odoo 10 and testing importing data in various parts of the software (Sales Orders, Products, Partners etc.) without issue, however I keep getting an error when trying to import new POs. I've got around 1300 lines to import so am definitely not keen on entering these manually, especially as this is only a testing environment at present.

I've of course used the template from export, however I keep getting an error :

  • Missing required value for the field 'Order Reference' (name) between rows 2 and 3

I'm only trying to import 1 PO currently with 2 lines, whatever I specify as 'Order Reference' gets rejected with the above error. On running an export the last PO number is PO00197 - so logically PO00198 should be accepted. On other modules (eg. Sales Orders) this number is generated automatically so I don't see why it should be necessary in the first place.


Below is a paste of the import file I'm using. I'm attempting to import a new PO which doesn't yet exist, rather than updating an existing PO.


date_order currency_id/id partner_id/id order_line/product_id/id order_line/product_uom/id order_line/product_qty order_line/price_unit Order Reference
14/06/2016 00:00:00 base.EUR __export__.res_partner_42 __export__.product_product_16470 product.product_uom_unit 10 68.48 PO00198
10 69.56
Avatar
Discard
Author Best Answer

Well, looks like I've found a solution and PO Import works - so this might help others.

It appears the Odoo error below

  • Missing required value for the field 'Order Reference' (name) between rows 2 and 3

Refers to Order Lines / Description - not PO name. After adding a description for each line, import works!

Avatar
Discard
Best Answer

Worked for me, great solution!

Avatar
Discard
Best Answer

Thanks Jan it worked for me

Avatar
Discard