Skip to Content
0
May 09, 2013 at 03:36 AM

Conversion file issue

36 Views

Hello Experts,

While creating the Account conversion file, we encounter that same source account is mapped to different group account in different entities. For exampls

Entity A -- GL account mapping

source account BPC account

10006 10000

Entity B

source account BPC account

10006 10001

So if we create only one Account conversion file to load all Trial balances, the data coming in 10006 will go in 2 BPC accounts which is incorrect. It should only flow to 10000 for TB coming of Entity A and to 10001 for TB coming of Entity B

Any idea on how to handle this...one way is to create sepearte transformation and conversion files and load these seperately. But since data load has to automated am wondering if there is better solution to handle this.

Thanks