New Advanced Flexible Type/Group Accounts Feature

Hi,

I think, This can be well achieved in better way by a drill down balance sheet and P/L inquiry form (2 forms).

Inquiry form should initially display only main heads divided in Assets and Liability side. (Income and Expense for PL statement) It should in form of a horizontal balance sheet i.e. all Assets accounts groups on left side and Liabilities on right hand side.

By clicking on any group, we should be able to drill down to it's subgroups and direct accounts listing and so on.

Note - Please search 'Horizontal Balance Sheet Formats' for details.
A link for reference - http://basiccollegeaccounting.com/balance-sheet-example-what-is-the-horizontal-and-what-is-the-vertical-presentation-method-of-preparing-the-balance-sheet/

Thanks,

Hi,

I think we can reach the same Idea in a simpler way If we Control the way that gl_all_accounts_list display the ComboBox :

I suggest that if you can display the content of the ComboBox as a hierarchical tree with ( +/- ) sign at the right of the Group/Types level. So, when you click the ( + ) sign, it will expand its sub accounts & if you click the ( - ) it will hide them.

This will be Just a looks like : "Hierarchical Tree Menu" embedded in the ComboBox Accounts List where the Types=Level1 Menu & Accounts=Level2 Menu

In this case as an end user, you have a full control for Minimizing/Limiting the displayed accounts of the COA in the ComboBox.

By doing the approach like I suggest now, we won't need at all to modify the structure of the 0_chart_types table. And perhaps we escape from the complexity
who may cause.

Finally by searching the net, what I mentioned is known as a " Tree ComboBox "
you may see a demo example at this link :

http://demo.koolphp.net/Examples/KoolComboBox/Advances/With_TreeView/index.php

Practically, we will need only 2 levels :
- Type/Group Level & Accounts Level
- Class Levels will be an extra option. Generally it is not needed when working
  on data entry transactions

Khaled

I think that you guys means different things here.
Khaled wants a combo selector where he only wants to see the accounts belonging to an expanded type (group) for easier selection, especially if the COA is very big.
And you Chaitanya wants a drill down BS or PL.
Both whishes seem to be fair. Only that the link you presented, Khaled, contains source that are proprietary (not open source).
We will have to rely on our JS expert, Janusz. Maybe he can find someting useful. Unfortunately he is very overloaded with business at present.
Maybe we can move this discussiont to the FA Wiki, Developers section, Wishlist and future development directions for next major releases.
We could then set the planning to go into release 2.3.

This discussion will be inside the current discussion.

/Joe