Breaking

Click here for Free Course

TDL for Total of Selected Lines in Ledger Account

TDL for Total of Selected Lines in Ledger Account

Friends, Today we discuss a TDL which make an automatic total of each selected line in Tally. As you know, You can select any entry by Space Bar without open, but you get total only when you remove selected items.  This TDL help you to make an automatic total on top of the screen. TDL provides you the net balance of selected lines if you select Dr. and Cr. both items, If you select only debit side items then it will show you debit balance, or if you select Credit side items then this TDL show you total of credit balance of ledger.

Following Images show you how this TDL work:

Net Balance when you select Debit and Credit both field


Credit Balance when you select only Credit side


Debit Balance when you select only Debit side


Below is the source code for the TDL. Just copy and paste the source code in notebook file.


Code Start

[#Line : LV Title]
Add : Field : After : LEDMailName : RBCLineselectedTotal

[#Line : DSP VchDetail]
    Option        : RBCSelectedLinesTotalOnFocus    :  ##IsLedgerReport
   
[Field : RJSelectedTitle]
Use : Short Name Field
Set as :"Selected Total :-"
Color : Black


[!Line: RBCSelectedLinesTotalOnFocus] ;Line to Call Selected BillsTotal Function

    On        : Focus    : Yes    : Call    : RBCSelectedLinesTotal

[Function: RBCSelectedLinesTotal]

    0010    : Set    : RBCSelectedLinesTotal    : ($$CollAmtTotal:RBCSelectedLinesColl:$TotalLedVchAmt)
    0011    : Set    : RBCIsLineselected         : (NOT $$IsEmpty:##RBCSelectedLinesTotal)
   
[Field: RBCLineselectedTotal]
           
            Use                : Name Field
            Set as            : if ##RBCIsLineselected AND NOT $$IsEmpty:($$ReportObject:$$CollAmtTotal:RBCSelectedLinesColl:$TotalLedVchAmt) Then $$String:@SelectedTotal + $$String:@SelectedTotalVal Else ""
            Width            : 60
            Align            : Centre
            Invisible        : NOT  ##IsLedgerReport OR NOT $$InDisplayMode
            SelectedTotal    : $$LocaleString:"Entries Selected for : "
            SelectedTotalVal: $$String:##RBCSelectedLinesTotal:"DrCr"

[System: Variables]
    RBcSelectedLinesTotal : 0
    RBCIsLineselected     : NO
   
[Variable: RBcSelectedLinesTotal]

    Type    : Amount
   
[Variable: RBCIsLineselected]
    Type    : Logical

[Collection:RBCSelectedLinesColl]
   
    Data Source    : Report    : Selected
    Fetch        : Name, TotalLedCrVchAmt,TotalLedDrVchAmt, TotalLedVchAmt
    Client Only    : Yes

Code End

5 comments:

  1. PLS HELP ME HOW TO CALCULATE IN LEDGER SELECT LINE TOTAL

    ReplyDelete
    Replies
    1. You need to copy the code or download the file and integrate to tally addon. After that open the ledger and press space bar on each entry. On the top of the ledger screen you can see the balance (dr, cr, or net)

      Delete
  2. Hi, Nice to see my code here.

    RBC in code stands for Rawat Bartwal & Co, Chartered Accountants, Dehradun. Contact 70551451996

    ReplyDelete
    Replies
    1. Its our pleasure your visit on our website. Yes we get the code from outsource and we implement code just little bit. Thanks to you to develop this code. This is very useful code to make party easy reconciliation.

      Delete
  3. SIR PLEASE MAKE CODE FOR SHOW CLOSING BALANCE OF ALL LEDGER ON ENTRY TIME

    ReplyDelete

No spam allowed ,please do not waste your time by posting unnecessary comment Like, ads of other site etc.