Conversion file issue

[Former Member]

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

[former_member186498 · Accepted solution]

Hi Abhi,

directly in transformation or conversion file it isn't possible, but you have several ways to obtain that:

• you can combine in the input file entity+account and convert this with the right account in the conversion file, f.e. external A10006, internal 10000, external B10006, internal 10001
• convert this account in a generic account and correct it after with a script logic based on entity
• build a "connection" table as master data, build an input schedule with few VBA code to read this table and to save new combination of entity+account => internal account and after you can import the data using this table for conversion

the first choise is the simplest, the last has the advantage that you can give it to fill to the users (they can be self-sufficient)

Kind regards

     Roberto

[Former Member · Accepted solution]

Hi Abhi,

You can also use the IF statement in the transformation file.

However, I would recommend Roberto's first choice as this gives the most flexibility.

The best solution is that the Chart of Accounts is corrected so that there is no confusion. However, as this is likely to be slow and time consuming I guess as usual the fix is done at the MI end.