Need help on Ledger wise report

In your respective column Fields...use as under:

Set As : if $VoucherTypeName CONTAINS "Sale" then $Amount else "" .... similarly do for Sales Returns and Receipts.

 

that is because ur collection is referring to ledger and not vouchers..........

 

search for a file.... Daybook Columnar in this forum.... you can modify that file to your requirement.... it is similar to yours.

 

http://tdlexperts.org/index.php?threads/free-code-columner-daybook.2868/#post-14169

refer to this post.....it is as per your needs..........you can modify it....

 

Make another collection for Vouchers........ then use $$CollAmtTotal based on Voucher Type.......... in your "Set As"

 

Find herewith the sample for your requirement.......
I have filtered it for "Sundry Debtors", since your columns indicate it is applicable to that group only.

Now based on what I am submitting, am sure you can work on the other fields............ Happy coding.......

Code:

[#Menu: Gateway of Tally]
    Add    : Item    : Before : @@locQuit    : My Trial Balance    : Display    : TB
   
[Report: TB]
        Form        : TB
    Variable     : SVFromDate,SVToDate
    Set         : SVFromDate     : ##SVCurrentDate
    Set         : SVToDate     : ##SVCurrentDate

[Form: TB]
    Parts           : TB Main Title, TB Part
    Height          : 100% Page
    Width           : 100% Page
    Button         : Change Period, Print Button, Export Button, FilterButton

[Part : TB Main Title]
    Line : TB Main Tit Line
   
[Line : TB Main Tit Line]
    Field : TB Main Tit Field
   
[Field : TB Main Tit Field]
    Use        : Name Field
    Set as     : "My Trial Balance for the period " + $$String:##SVFromDate + " to " + $$String:##SVToDate
    Align      : Center
    Width        : 100% Screen
    Style      : Large Bold
    Color        : Blue
   
[Part: TB Part]
    Lines           : TB Title, TB Details
    Repeat          : TB Details    : TB Groups
    Scroll          : Vertical
    CommonBorder    : Yes
       
[Line: TB Title]
    Use         : TB Details
        Local   : Field : Default               : Type      : String
        Local   : Field : Default               : Align     : Centre       
        Local   : Field : TB Name Field      : Set as    : "Particulars"
    Local   : Field : Op Balances         : Set as    : "Op.Balances"       
    Local   : Field : Group Names         : Set as    : "Group Name"       
        Local   : Field : Sales Invoices     : Set as    : "Sales Invoices"
        Local   : Field : Sales Returns        : Set as    : "Sales Returns"
        Local   : Field : Receipts         : Set as    : "Receipts"
        Local   : Field : Jour Ent Pay         : Set as    : "Jour Ent Pay"
        Local   : Field : Total Pay         : Set as    : "Total"
        Local   : Field : TB Amount Field    : Set as    : "Closing Balance"
        Border      : Flush Totals

[Line: TB Details]
        Fields          : TB Name Field, Group Names
    Right Fields    : Op Balances, Sales Invoices, Sales Returns, Receipts, Jour Ent Pay, Total Pay, TB Amount Field
    Option         : DisplayOnEnter
    Option         : TBAlterOnAltEnter

[!Line: TBAlterOnAltEnter]
        Key             : TBLine Object AltEnter Alter, Line Click Object Enter Alter

[Key   : TBLine Object AltEnter Alter]
        Key         : Alt + Enter
        Action      : Alter Object
        Mode        : Display
        
[Field: TB Name Field]
    Use             : Name Field
    Set as          : $Name            
    Display        : Ledger Vouchers    : $$ISLedger
    Variable    : LedgerName
    Modifies    : LedgerName
    Alter        : Ledger
    Width        : 40

[Field: Group Names]
        Use             : Name Field
    Set as          : $parent   
    Border          : Thin Left
    Style        : Normal Italic

[Field: Op Balances]
        Use             : Amount Field
    Set as          : $openingBalance   
    Border          : Thin Left
    Width        : 12

[Field: Sales Invoices]
        Use             : Amount Field
    Set as          : $SalesAmt
    Border          : Thin Left
    Width        : 12

[Field: Sales Returns]
        Use             : Amount Field
    Set as          : ""
    Border          : Thin Left
    Width        : 12

[Field: Receipts]
        Use             : Amount Field
    Set as          : ""
    Border          : Thin Left
    Width        : 12

[Field: Jour Ent Pay]
        Use             : Amount Field
    Set as          : ""
    Border          : Thin Left
    Width        : 12

[Field: Total Pay]
        Use             : Amount Field
    Set as          : ""
    Border          : Thin Left
    Width        : 12

[Field: TB Amount Field]
        Use             : Amount Field
    Set as          : $ClosingBalance   
    Border          : Thin Left
    Width        : 12

[Collection: TB Groups]
    Type            : Ledger
    Child OF     : $$GroupSundryDebtors
;       Filter          : Non Zero Closing Balance
    Fetch        : Name, parent, openingbalance, ClosingBalance
    Fetch         : Date, Amount, VoucherTypeName, PartyLedgerName, VoucherNumber
   
[System: Formula]
    Non Zero Closing Balance: $ClosingBalance > 0
    SameLedExists        : $LedgerName = $$ReqObject:$Name

[Collection : TBVchSrcColl]
    Type            : Voucher
;    Child Of        : ##cvLedgerName
   
[Collection: TBVchColl]
    Source Collection    : TBVchSrcColl
    Walk            : AllLedgerEntries
    By                      : VoucherTypeName       : $VoucherTypeName
        By                      : LedgerName            : $LedgerName
        Compute                 : ParentGroupName       : $Parent:Ledger:$LedgerName
        Compute                 : PrGroupName           : $_PrimaryGroup:Group:$Parent:Ledger:$LedgerName
    Compute            : ExtractMode        : ##ExtractMode
    Compute            : VoucherTypeName    : ##VoucherTypeName

    Aggr Compute        : SalesExtract        : Sum : If $$IsSales:$VoucherTypeName Then $Amount Else ""
    Keep Source        : No

[#Object: Ledger]
    SalesAmt        : $$ReportObject:$$FilterAmtTotal:TBVchColl:SameLedExists:$SalesExtract

 

Dear Pankaj....as per the TDL made by Venkat......it will work on single group only....not subgroup......

I just made the collection and formula for him to fetch the relevant data............

 

Very good......well done

post the success screenshot here...........

 

Very beautifully done Pankaj.....

A few suggestions......
a. In your Border definitions....use "FULL" so that the horizontal lines are flush with vertical ones.
b. Use --- Color : If $$IsDr:#OpBalance Then "Blue" Else "Red" to visually identify DR n CR Amts.
c. Add one column for OTHERS which will contain Journals n Payments (adjustments entries if any).
d. Remove GROUP column and try to put that above the Column title,so you get more space in Data Report area.
e. You can also put Invisible formula to hide columns if there are none data to display.

If you are stuck, let me know.

 

Here is the screenshot...........

 

Please use appropriate forum....so that other members can follow the line..............

you have already made a POST on this topic...so kindly use the same.......