Currently you have the Accpac GL and you have G/L Consolidations which is like a bit on the side.

For example in a child company if you add a new GL Account you need to go into GL Consolidations > Setup > Mapping Table > Bring up the mapping table and add the account in there.

Usually at a child level if your account structure is XXXX-XXX-XXX then at a parent level is usually becomes XXXX-YY-XXX-XX (or similar logic) This is usually all the same in a child level.

So in a GL Consolidations setup can we have the ability to set a new global parent structure and account mapping structure. Then at an account level in the child company if GL Consolidations is activated for this database have a new tab of the GL Account Screen that lets you perform all of the mapping and logic there as well. This keeps it all in one place instead of having two separate places. Still have a mapping table and let the users look them all up as well, just make it easier during the Account Creation process.

Also integrate this into the G/L Account - Create Accounts function as well.

by: Kerry J. | over a year ago | Financial Management