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 :
- 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 |