• Kalido
  • Senior Member
  • Offline
  • From: Lebanon
  • Registered: 08/06/2009
  • Posts: 85

Topic: Is There any way to Inquire the Account(s) Types/Groups

Hello,


Is There any way to Inquire the Account(s) Types/Groups, and also to print it out ?

For now we need to exctract it from the 'Account GL' Report Statement who is mainly aware of the Active Accounts and not aware of the Account Groups.

This feachure will help a lot in the Accounting Analysis.



Regards,


Kalido

  • From: India
  • Registered: 11/09/2009
  • Posts: 115

Re: Is There any way to Inquire the Account(s) Types/Groups

Hi,

I support this. We have facility to classify the GLs in groups, subgroups, types and tags but reporting is not possible.

Can anyone help with this ? I think this is a common need so many people may have got this developed in some or other way...

Thanks

Chaitanya
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: Is There any way to Inquire the Account(s) Types/Groups

Look into the report, rep707.pjp. This is the Profit and Loss statement.
It uses 2/3 sql statements, depending on which comparing column is used.
The first and overall is the routine get_gl_accounts_all(0), where the digit 0 indicates non balance accounts. This function resides inside /gl/includes/db/gl_db_accounts.inc
The second and third are: get_gl_trans_from_to() and get_gl_budget_from_to(). These functions get the balance from to for accounts and dimensions (if any). These both functions reside inside /gl/includes/db/gl_db_trans.inc.

/Joe