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

Hello Everyone,

I am attempting to import invoices in an odoo 16 database

but facing the following issue during import

Missing required value for the field 'name' at multiple rows

I am not sure what is causing it since none of the fields i am importing show errors

here are the imported fields:

Partner 
Journal
Invoice/Bill Date
Reference
Invoice lines/Product
Invoice lines/Analytic lines/Analytic Account
Invoice lines/Quantity 
Invoice lines/Unit Price


I Tried adding the external ID however the issue remained the same


Thanks for the responses everyone, the issue was solved by adding a field for currency and removing analytic account

instead of adding analytic account to the invoice 

we just added the product category to the analytic distribution model so it would automatically assign the analytic account

Avatar
Discard
Best Answer

Hi,

you could use this template



Technical Column Names:

 : invoice number

 : invoice refrence
 : partner name

 : invoice date

 : invoice due date

 : product name

 : analytic account name

 : product quantity

 : product unit price

Hope this will help.

Avatar
Discard
Author Best Answer

Hello tony thanks for the answer, i tried adding the external ID however when trying to import the same issue appears

Avatar
Discard
Best Answer

It needs external ID. Try adding a new field for it or you can generate one by creating an invoice with one item and then exporting it to get the external ID and then reimport

Avatar
Discard
Related Posts Replies Views Activity
3
Nov 24
2939
5
Nov 24
7436
2
Oct 24
2877
4
Oct 24
1857
0
Oct 24
97