Just wondering how I can influence what appears in a tree.
Scenario: I have a BO called ChartOfAccounts. This BO has a referenced item to a transactions BO. After 3 years of operation there are thousands of transactions, so I would like to restrict the number of transactions that appear as subnodes in the tree to the currently selected reporting period. and more importantly have the totals shown only relevant to the reporting period So...
8000 Flying fees £100
---8010 Members Flying £70
--------transaction 1 £20
--------transaction 2 £35
--------transaction 3 etc etc £15
---8020 Trial Lessons £30
--------Transaction 1 £25
--------Transaction 2 £5
Each logged in user sets their own reporting period. I have the tree working fine in that The chart of accounts codes and sub codes all appear as expected, and I have a process in the context menu that can pull up a filtered list of the reporting period transactions for each sub-node, but it would be a really nice touch if I could have them appear as subnodes or leaves in the tree itself.
Any suggestions? If I can crack this, I'll have a pretty damn fine on screen monthly P&L report
