Bulk update VAT on invoices

Question

I have imported 1000+ invoices from another system into ODOO. All invoices are still in Draft Status.
I have realized that the Tax Computation  settings were not properly set and the invoice were with the wrong TVA set. I have updated the Tax Computation to be right.
Now i am trying to find a solution how to apply in bulk the proper Taxes on the imported invoices.
If i go manually into the sales order and up change the price, it applies afterwards the proper taxes. But i can't do it manually of

Hamid Ahmadimoghaddam · Accepted Answer

Hi Dan,
You can use the external ID to update the records with another import.
In general, if the field that you would like to update is in the model, temporary do the following:
add the field in the list view select the records that you would like to update do the change on one of them apply on all records  after that, please remove again the field from the list view.
I hope I could help.
Hamid

Josep Anton Belchi Riera · Answer

You can export all these invoices to Excel. Include at least the external ID of the record and all the fields you need to change.
You can then manually change the Excel fields by giving them the correct values.
Finally, re-import this Excel to Odoo and all records will be updated.

Dan Witting · Answer

Excellent !! Many thanks.
To complete what Josep and Hamid wrote, i have downloaded

id
name
invoice_line_ids/id
invoice_line_ids/price_unit

As i have no price changed to be make, i have re uploaded the same file without any modifications. The VAT has still been re-calculated.

Related Posts	Replies	Views
add tax amount per item line in invoice odoo accounting tax	1 Nov 24	71
Exclude income tax from the total and add a Net receivable field accounting tax	1 Apr 24	574
Tax Closing error, Tax account configuration error? Odoo 15 accounting tax	0 Feb 24	672
INDIAN HSN Tax Information accounting tax	1 Dec 23	340
Error while generating tax report accounting tax	0 Jan 24	260

This question has been flagged

Enjoying the discussion? Don't just read, join in!