there is no business_unit_id in the parts table.
And Why not just import the project_id's to business_unit_id?
instead you add 1000 to project_id's ?
The issue is that departments and projects get merged into the same table, and so we decided to just add 1000 to project id's to avoid conflict. It is highly unlikely that anyone has 1000 departments so this should be perfectly safe.
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.