Skip to Content
This question has been flagged
2 Replies
100 Views
Avatar
Miquel de Antonio Torné

Hello everyone,

I'm currently facing a persistent issue in the Expenses module after migrating from Odoo 16 to Odoo 17 recently.

The problem is specifically: "The 'Vendor' field is required, please complete it to validate the vendor bill." appears when an expense is submitted/validated and attempts to create the accounting journal entry.

  • Odoo Version: Odoo 17 (Community)

  • Previous Version: Odoo 16, where this process worked correctly.

  • Scope: The error only affects one specific user/employee. I have successfully tested the same process with another employee, and the entries posted without any issue.

  • Initial Check: Based on some online searches (related to private address/contact info being missing), I verified the affected employee's private information (address, contact details) is fully populated on their private contact card. Despite this, the error persists.

Has anyone encountered this specific user-related issue in Odoo 17 after migrating? It seems to be a data-integrity or user-specific configuration problem rather than a module-wide bug.

Thank you in advance for your help!

Avatar
Discard
Kunjan Patel

Hello,
I have edited the answer can you try that.

hope it helps

Miquel de Antonio Torné
Author

It works!

Thanks and have a good day :)

Kunjan Patel

Great to hear it works!
You're welcome.

Avatar
Miquel de Antonio Torné
Author Best Answer

Hello Kunjan,

I'm good, thanks!
Unfortunately, I'm still getting the same error when I run those commands in the Odoo shell.
do you have any other ideas?

Thanks & Regards, Miquel.

Avatar
Discard
Avatar
Kunjan Patel
Best Answer
Hello Miquel de Antonio Torné,
I hope you are doing well

SQL - fixes all affected employees at once:
UPDATE hr_employee
SET work_contact_id = address_home_id
WHERE work_contact_id IS NULL
AND address_home_id IS NOT NULL;


I hope this information helps you

Thanks & Regards,
Kunjan Patel

Avatar
Discard