Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
3 Răspunsuri
5958 Vizualizări

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
Imagine profil
Abandonează
Autor Cel mai bun răspuns

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!

Imagine profil
Abandonează
Cel mai bun răspuns

Worked for me, great solution!

Imagine profil
Abandonează
Cel mai bun răspuns

Thanks Jan it worked for me

Imagine profil
Abandonează