Skip to Content
This question has been flagged
OpenUpgrade
3 Respostes
1098 Vistes
Avatar
Santiago Carbonell Forment
Good morning,

I've just migrated a database from Odoo16 to Odoo17 with OpenUpgrade and all it looks like works fine, I am able to open the sales invoices created time ago, and I'm able to create new sales invoices in draft mode but if I try to confirm it, it appear an error that says:

Record does not exist or has been deleted.
(Record: account.analytic.plan(2), User:2)

But I don't understand, because in the source database in odoo16, I didn't use/activate analytic accounts so that is why its says something about plan analytic. I attach the error

Can you help me?

Thanks

Regards

Avatar
Descartar
Avatar
Bay Forward, Bay Forward
Best Answer
Check Analytic Account Settings: In Odoo 17, ensure that the analytic feature is disabled if you don’t need it. You can do this in the Accounting settings under "Analytic Accounting" and turn it off.

Manually Remove Analytic Account: If the invoice is wrongly linked to an analytic plan, you can try removing the analytic account from the invoice or sales order before confirming it.

Update Migration Script: If the migration script activated analytic accounts or created default records, you may need to manually clean up any analytic plan records in the database.

Avatar
Descartar
Avatar
Kunjan Patel
Best Answer
Hello Santiago Carbonell Forment
I hope you are doing well

Navigate to: Accounting → Configuration → Analytic Accounting → Analytic Plans

1. Click "Create" and name it "Default", save it
2. Go to Accounting → Configuration → Analytic Accounting → Analytic Accounts
3. Open each analytic account and assign the "Default" plan you just created
4. Try confirming your invoice again - the error should be resolved

The issue is that Odoo 17 requires analytic plans (new feature), but OpenUpgrade migration didn't create the default one from your Odoo 16 database.


I hope this information helps you

Thanks & Regards,
Kunjan Patel

Avatar
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,


After migrating from Odoo 16 to Odoo 17 with OpenUpgrade, you might encounter an error related to analytic accounts when confirming sales invoices, even if you didn't actively use them in Odoo 16. This can happen because Odoo 17 might have introduced a default requirement for analytic plans, data migration inconsistencies, or new module dependencies.

To resolve this, first, check if a default analytic plan exists and set a default analytic account in the accounting settings. Examine the journal entries configuration for the sales journal and ensure it doesn't require an analytic account if you don't intend to use them. Investigate any newly installed or updated modules for dependencies on analytic accounts. Review the OpenUpgrade logs for errors related to analytic accounts during migration. If needed, consider a manual data fix (if you have PostgreSQL expertise) or seek assistance from OpenUpgrade support or an Odoo partner.


Hope it helps

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Error employee_admin in openupgrade from odoo16 to odoo17
hr OpenUpgrade
Avatar
Avatar
Avatar
2
de des. 25
1107
OpenUpgrade from 15.0 to 16.0 : filestore missing files Solved
filestore OpenUpgrade
Avatar
Avatar
Avatar
2
de nov. 25
1729
Open upgrade inventory script
OpenUpgrade inventory-script
Avatar
Avatar
1
de juny 25
2823
Expenses : Migration from 15.0 to 16.0 CE (used OpenUgrade)
expenses OpenUpgrade odoo16CE
Avatar
0
de nov. 25
1031
Openupgrade - im trying to migrate odoo 14 to odoo 15 with openupgrade.
migration openupgrade OpenUpgrade
Avatar
Avatar
1
d’abr. 25
4506