Balance After Every Entry

Discussion in 'Tally Developer' started by bollindia, Apr 22, 2013.

    
  1. bollindia

    bollindia Member


    This is not mine abut i want to share all with you
    Code:
    ;Display Transcsion wise Balance
     
     
    [#Menu : Gateway of Tally]
     
     
    [#Part: LV Body]
    Total : MGDrCrTotal
     
    [#Line : DSP VchAccTitles]
    Add : Right Field : MGTitle
     
    [Field: MGTitle]
    Use      : Amount Title Field
    Info      : "Balance"
    Align    : Right
    Style    : Normal Bold
     
     
     
    [#Line : DSP VchAccDetail]
    Add : Right Fields : MGDrCrTotal,MGTotal
    Border : Full Thin Top
    ;;Border : Thin Bottom
     
    [Field : MGTotal]
        Use        : Amount Field
        widtth    : @@amountwidth
        Set as    : $$NettAmount:@@LedOpening:$$SubTotal:MGDrCrTotal
        Style      : if $$InPrintMode then "Normal" else "Normal Bold"
        Format    : “DrCr”
        Inactive  : $$IsVoucher AND NOT ##IsCCReport AND @@ShowForex
        Invisible  : NOT ##IsLedgerReport
     
    [Field : MGDrCrTotal]
    Use        : Amount Field
    widtth    : @@amountwidtth
    Set as    : $$NettAmount:#DSPVchCrAmt:#DSPVchDrAmt
    Invisible  : Yes
     
    [#Field : DSP VchNumber]
    Invisible : ##BankRecMode OR $$InDraftMode OR NOT ##DBKDispVchYesNo
     
    [#Field: DSP VchType]
    Invisible : ##BankRecMode OR $$InDraftMode OR NOT ##DBKDispVchTYesNo
     
    ;;—————— Print —————————————————————-
     
    [#Line: LV OpeningBalance]
    Add : Right Fields : MGTotal
    Local : Field : MGTotal : Set As : “”
     
    [#Line: LV FCOne]
    Add : Right Fields : MGTotal
    Local : Field : MGTotal : Set As : “”
    Local : Field : MGTotal : Border : Full Thin Top
    Local : Field : MGTotal : Indent : 0 mms
     
    [#Line: LV FCTwo]
    Add : Right Fields : MGTotal
    Local : Field : MGTotal : Set As : “”
     
    [#Line: LV FCThree]
    Add : Right Fields : MGTotal
    Local : Field : MGTotal : Set As : “”
    Local : Field : MGTotal : Border : Flush Totals
     
    ;;——————Display————————————————-
     
    [#Line: DSP VchOpAmt]
    Add : Right Fields : MGTotal
    Local : Field : MGTotal : Set As : “”
     
    [#Line: DSP VchCurTotalAmt]
    Add : Right Fields : MGTotal
    Local : Field : MGTotal : Set As : “”
     
    [#Line: DSP VchClAmt]
    Add : Right Fields : MGTotal
    Local : Field : MGTotal : Set As : “”
     
    ;;——————————————————————————————-
     
    ;EOF
     

    Attached Files:



  2. bollindia

    bollindia Member


    aaa.JPG


    I wants to show Total of Last Row and Balance With Dr. and Cr.
     


  3. G Vijay

    G Vijay Member


    very good TDL... let me try 2 queries...
     


Share This Page