Skip to Content
Menu
This question has been flagged
3 Replies
7754 Zobrazenia

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
Zrušiť
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
Zrušiť
Autor Best Answer

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

Avatar
Zrušiť
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
Zrušiť
Related Posts Replies Zobrazenia Aktivita
3
júl 25
1932
1
máj 25
2415
1
apr 25
3433
1
apr 25
4254
1
apr 25
1744