Dear, I new in this forum and now I am facing the problem in the profit and loss account in the profit and loss in vertical view there's opening stock, purchase account and closing stock I want explode that three. So opening stock will explode opening stock summary, purchase account will explode purchase group summary and closing stock will explode stock summary. The problem is I can show the item and the ledger when I explode it but I cannot get the amount. Can you help me for fix the issue, I'm very thankful for your help. this is the file :
Can you check http://www.tdlexperts.com/index.php?threads/balance-sheet.149/#post-205 It might be help full for you. Still you need support, please contact us
Dear I already doint the same way in profit and loss, my code is like this : [#Line: PLDetail] Fields : DSP AccName, PLAmt Repeat : PLAmt Local : Field : TestName : Set As : $Name Space Top : if $$InPrintMode then 1 else 0.25 NextPage : $$IsFirstChildOnNextPage OR + (($$NumExplosions < 4) AND (NOT $$DoExplosionsFit)) OR + (($$LineNumber = $$LastLineNumber) AND ($$BalanceLines > 0) AND ($$BalanceLines < 5)) Explode : BSGRP Explosion : $$IsGroup AND @@GrpExplodable Explode : BSStkExplosion : $IsStockLine AND @@StkGrpExplodable AND $$IsIntegrated Explode : BSStkGrpExplosion : $IsStockLine AND @@StkGrpExplodable AND NOT $$IsIntegrated Option : Small Size Line : NOT $$InPrintMode Empty : $$IsEmptyObject [#Part: BSStkExplosion] Lines : BS Detail delete : Repeat : BS Detail : StockGroupItemChildOfPrimary Repeat : BS Detail : StockItemChildOfGroupName Scroll : Vertical Local : Line : BSDetail: Delete : Explode Local : Line : BSDetail : Add : Explode : BSStkExplosion : $$IsGroup AND (@@IsWkgCapItem OR @@GrpExplodableNew) Local : Line : BSDetail: Delete : Space Top Local : Line : BSDetail: Empty : $$IsEmpty:$OpeningValue AND $$IsEmpty:$ClosingValue [System : Formula] GrpExplodableNew : $$KeyExplode OR ##ExplodeFlag But, still I cannot explode item and ledger in the profit and loss vertical view.. Can you give me another clue for fix this issue?