Move Business Units to a different Company and Impact on Trial Balance

Hello Folks,

We have moved few business units from various companies (A,B, and C) into one company X (as of FY 18) and left the transaction data for prior years with previous companies. We have also followed the standard process of moving COA, Account Ledger and Account Balance data and the data is looking good.

The challenge we are having is with running of Trial Balance for Company X where it pulls the data for the prior years (which is still aligned to the previous company) for the Business Units that have been moved. I checked various Trial Balance reports and applications and it all works the same way where it is showing balances for the prior years for the business unit data (aligned to old company).