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...........