Hi! Is there a GI that we can be created that will show the GL accounts and the associated Sub Account with it for all or specific modules? I know GL account and subaccounts are setup throughout the system but I’m not sure if there is a table out there that contains this data without having to go through every module and joining many tables.
GL and subaccount combination
Hello,
No, we don’t have “out of the box” a Generic Inquiry that shows us the account and subaccount combinations that have been used, by module.
- Are you trying to find the source of posting errors?
- Are you thinking of deleting an account or subaccount and want to know if it’s been used?
I think it will be impossible to make an accurate list of potential combinations of accounts and subaccounts because there are so many places where Acumatica can select segments of subaccounts from many places: the possible combinations are unlimited.
If you are thinking of deleting an account or subaccount → Acumatica will not delete an account that has activity or is used as a default. Go ahead and click Delete in Chart of Accounts screen, to find out. The account will either be deleted, or Acumatica will tell you whether it has been used after you click Delete.
Please post more details about your need and we will try to assist further. Thank you!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.