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.

Bài viết liên quan	Trả lời	Lượt xem
add tax amount per item line in invoice odoo accounting tax	1 thg 11 24	2308
Exclude income tax from the total and add a Net receivable field accounting tax	1 thg 4 24	2811
Tax Closing error, Tax account configuration error? Odoo 15 accounting tax	0 thg 2 24	2770
INDIAN HSN Tax Information accounting tax	1 thg 12 23	2087
Error while generating tax report accounting tax	0 thg 1 24	260

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!