FrontAccounting forum — Is There any way to Inquire the Account(s) Types/Groups

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

null@example.com (joe) — Sat, 21 Nov 2009 09:05:04 +0000

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

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

null@example.com (chaitanya) — Sat, 21 Nov 2009 08:13:08 +0000

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

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

null@example.com (Kalido) — Tue, 08 Sep 2009 01:13:34 +0000

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