Is there an easy way (prefereably a report) to get the GL accounts specified in a particular GL Control group?
For example, we setup GL accounts in the ProductGroup type of GL Controls. And need to verify that each account specified is correct for the Product Group.
There are 21 configurable accounts, per Prod Group GLControl code, and we have over 100 product Groups. So stepping through the GL Control Maintenance screen isn’t feasible)
Calvin,
What I have done before is to build a dashboard for the different GL codes.
One for product group GL codes, one for supplier GL codes, one customer,
etc.
Then you could right click into the GL control code and get the account
details. Do this you can work through the GL control codes and the details
update as you move down the list.
Hopefully, you have 100 product groups and only 20 GL control codes…That
is the theory at least.
You could show all of these in one dashboard, but I found that different
people are focused on each group of control codes.
Brad
Brad
GLCntrlAcct table will give you the GL Control Type, Control Code, and GL
Account associated with each
Mark Wagner
Sr. Partner
Capstone Alliance Partners 888.597.2227 Ext. 71
<888.597.2227%20Ext.%20714>2 | 904.412.6847 mwagner@capstoneap.com (cell)
| www.capstoneap.com
Could you use a BAQ? I think EntityGLC is the table that maintains the GL control relationships.