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.

関連投稿	返信	ビュー
add tax amount per item line in invoice odoo accounting tax	1 11月 24	2303
Exclude income tax from the total and add a Net receivable field accounting tax	1 4月 24	2807
Tax Closing error, Tax account configuration error? Odoo 15 accounting tax	0 2月 24	2766
INDIAN HSN Tax Information accounting tax	1 12月 23	2086
Error while generating tax report accounting tax	0 1月 24	260

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！