Hi does anybody tried generating a Balance Sheet in CR using a recursive Structure of account Title. Im Having Trouble with hierachial view of Balance Sheet ,The hierachial feature is available in CR but i found it not enough to do the balance sheet. or maybe i miss something. thx. heres my structure



PkActID AccountName Fk_Parent_ID FkAccntType
----------- -------------------------------------------------- ------------ -----------
14 Cash On Hand NULL CASH
15 Cash In Bank NULL BANK
16 Petty Cash Fund NULL PETTYCASH
17 Temporary Investments NULL BANK
18 Advances to Officers & Employees NULL OCASSET
20 Accounts Receivable NULL AR
27 Inventories - Books & Journals NULL OCASSET
28 Accounts Receivables - Others NULL OCASSET
29 Prepaid Expenses NULL OCASSET
34 Land 91 FIXASSET
35 Land Improvements 91 FIXASSET
36 Accumulated Depreciation - Land Improvements 35 FIXASSET
37 School & Administrative Building 91 FIXASSET
38 Accumulated Depreciation -School & Admin Building 37 FIXASSET
39 Office Furniture, Fixtures & Equipment 91 FIXASSET
40 Accumulated Depreciation - Office FFE 39 FIXASSET
41 Sports and Laboratory Equipment 91 FIXASSET