Hello,

We’re starting to support a new business who already has an Odoo database. The previous MSP handled upgrades yearly by dumping PSQL and reimporting bypassing ORM.

The reason this has come up is because it’s a multi-company database and the end users keep hitting access right rules due to location_id belonging to another company_id - this is just an example but it happens in almost every module with different fields. 

Is there a module available or does someone have a sql script that can be run to verify all of the records are assigned to the correct company_id or give some sort of indication the extant of the nightmare I’m being plunged into?

Thank you for your time.