Interco Addon- Export from Branch to Consol DB error on mapped account is not in Consolidation COA

[too_muihwee]

Hi,

When i perform Manual consolidation at Consol DB, click on Export from Branch, at the Status, i encounter error message-> Failure: At least one of the mapped accounts is not available in the Consolidation Chart of Account.

I am not able to know which account is not in consolidation COA, which screen can i check? Any idea?

I have setup 2 level of consol, this is level 1 consol. I have not mapped Consol1 COA to Consol2 COA, is this the cause of error? But i am trying to export branch JE to Consol1, between branch and Consol1 COA are mapped. Anyone can help?

[too_muihwee]

Hi Pankaj,

Thanks so much for your guide. Issue is resolved.

Not sure why there are empty rows in "CTX_ACCMAP" table, so i deleted those empty rows then it is able to export manual JE from branch at Consolidation DB. Really thanks a lot.

[too_muihwee]

Hi Pankaj,

Thanks for the reply. I have just export consolidation company COA and perform mapping in branch company, didn't make changes to consolidation COA after it is exported. So there is no screen that able to tell which account is not exist in Consol DB?

[pankaj_sharma22]

Hi,

If you have "Clear All" the existing mapping and re-done the mapping again in the consolidation account mapping screen with the newly exported COA from the consolidation company then it works.

Also, you can refer to the "CTX_ACCMAP" COA Account Mapping table, From this table, you can compare the mapped accounts with the consolidation company accounts and identify which mapped account does not exist in the consolidation company chart of accounts.

[pankaj_sharma22]

Hi,

From the error it seems, any of the mapped accounts in the branch company does not exist in the consolidation company.

Please check might be you have deleted the account from the consolidation company and however this account is already mapped in the branch company.

To fix this issue, perform the Export/Import of chart of account from the consolidation company and perform the consolidation account mapping in the branch company.

Thanks,

Pankaj Sharma