Grand totals not getting

Discussion in 'Requests' started by Venkat1433, Oct 7, 2018.

    
  1. Venkat1433

    Venkat1433 New Member


    Can you please help on below error. i am not getting the totals


    [#Menu: Gateway of Tally]
    Add: Item: Before: @@locQuit : My Trial Balance : Menu: My TB



    [Menu: My TB]

    Indent: Groups
    Item: BLANK
    Item: BLANK
    Item: @@locquit


    [#Menu: My TB]
    Add : Item : Before : @@locQuit : All Group Types : Display : Sundry Debtors


    [Report: Sundry Debtors]
    Form : TB
    Variable : SVFromDate,SVToDate
    Set : SVFromDate : ##SVCurrentDate
    Set : SVToDate : ##SVCurrentDate

    [Form: TB]
    Parts : TB Main Title, TB Part
    Bottom Part : TBTotals
    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 : Set as : "Sales"
    Local : Field : Purchases : Set as : "Purchases"
    Local : Field : Receipt : Set as : "Receipt"
    Local : Field : Payment : Set as : "Payment"
    Local : Field : Contra : Set as : "Contra"
    Local : Field : Journal : Set as : "Journal"
    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, Purchases, Receipt, Payment, Contra, Journal, 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
    Format : "DrCr"
    Border : Thin Left
    Width : 12

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

    [Field: Purchases]
    Use : Amount Field
    Set as : $purchaseamt
    Format : "DrCr"
    Border : Thin Left
    Width : 12

    [Field: Receipt]
    Use : Amount Field
    Set as : $receiptamt
    Format : "DrCr"
    Border : Thin Left
    Width : 12

    [Field: Payment]
    Use : Amount Field
    Set as : $paymentsamt
    Format : "DrCr"
    Border : Thin Left
    Width : 12

    [Field: Contra]
    Use : Amount Field
    Set as : $Contraamt
    Format : "DrCr"
    Border : Thin Left
    Width : 12

    [Field: Journal]
    Use : Amount Field
    Set as : $Journalamt
    Format : "DrCr"
    Border : Thin Left
    Width : 12




    [Field: TB Amount Field ]
    Use : Amount Field
    Set as : $ClosingBalance
    Format : "DrCr"
    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

    ; Aggr Compute : SalesreturnExtract : Sum : If $$IsCreditNote:$VoucherTypeName Then $Amount Else ""
    ; Keep Source : No

    Aggr Compute : purchaseExtract : Sum : If $$IsPurchase:$VoucherTypeName Then $Amount Else ""
    Keep Source : No
    Aggr Compute : receiptExtract : Sum : If $$IsReceipt:$VoucherTypeName Then $Amount Else ""
    Keep Source : No

    Aggr Compute : JournalExtract : Sum : If $$IsJournal:$VoucherTypeName Then $Amount Else ""
    Keep Source : No

    Aggr Compute : PaymentExtract : Sum : If $$IsPayment:$VoucherTypeName Then $Amount Else ""
    Keep Source : No

    Aggr Compute : ContraExtract : Sum : If $$IsContra:$VoucherTypeName Then $Amount Else ""
    Keep Source : No


    [#Object: Ledger]
    SalesAmt : $$ReportObject:$$FilterAmtTotal:TBVchColl:SameLedExists:$SalesExtract
    ; Salesreturamt : $$ReportObject:$$FilterAmtTotal:TBVchColl:SameLedExists:$SalesreturnExtract
    receiptamt : $$ReportObject:$$FilterAmtTotal:TBVchColl:SameLedExists:$receiptExtract
    Journalamt : $$ReportObject:$$FilterAmtTotal:TBVchColl:SameLedExists:$JournalExtract
    Paymentamt : $$ReportObject:$$FilterAmtTotal:TBVchColl:SameLedExists:$PaymentExtract
    Receiptamt : $$ReportObject:$$FilterAmtTotal:TBVchColl:SameLedExists:$ReceiptExtract
    Contraamt : $$ReportObject:$$FilterAmtTotal:TBVchColl:SameLedExists:$ContraExtract

    [Part:TBTotals]
    Line:TBtotals

    [Line:TBtotals]
    Border : Totals
    Use : TBDetails
    ;Local : Field : Default : Type : String
    Local : Field : Default : Align : Right
    Local : Field : Default : Style : Large Bold
    Local : Field : Default : Border : Thin Left
    Local:Field:DEFAULT:Use:AMOUNT FIELD
    Local : Field : Default:Format:"Dr/Cr"
    Local : Field : TB Name Field : Set as : " "
    Local : Field : Group Names : Set as : "Grand Totals"
    Local : Field : Group Names : Align : Left
    Local : Field : Group Names : Background:YELLOW


    Local : Field : Op Balances : Set as : $$Total:OpBalances
    Local : Field : Sales : Set as : $$Total:Sales
    Local : Field : Op Balances : Border : Thin Left Right
    Local : Field : Op Balances : Align : Right

    Local : Field : Sales : Border : Thin Left Right
    Local : Field : Sales : Align : Right
     


  2. sivam

    sivam Active Member


    This Report is Perfect.

    Report have one Credit and Equal Debit Amount, So this show as Zero.
     
    vinoth, Jaya and Nallasivam like this.


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    He has already been given the solution.......... yet he tries again with another post in another topic................. means he has not read the solutions at all.....

    Right now the collection is for all Group.....so barring Closing Balances..... all column (which is on Voucher type) will be ZERO.

    Most important......... he has not defined the TOTALS at all............... which I asked him..........but not yet replied to me.............
     
    Meena Mhatre likes this.


  4. Venkat1433

    Venkat1433 New Member



    i got it sir... i checked it.. when i am flitering it only one group i am getting the totals now...

    Thank you for your support...
     


Share This Page