put a opening balance tag on above in ledger....

Discussion in 'Requests' started by bikash agarwal, Jul 26, 2018.

    

  1. hello members,
    can someone help me with a TDL for putting a "opening balance" tag on above in ledger....
    :: can see the pic attached for position :
     

    Attached Files:




  2. i want to add opeining balance before this : e.g Opening Balance : - 20050 .00
     



  3. thankyou sir, for your support .......i solved opeing balance infort part...thank you sir....
     
    Password likes this.


  4. Rajsrisrimal

    Rajsrisrimal Member


    Sir,
    can you provide same for us all or to me at rajsrisrimal@gmail.com
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code:
    [#Line : LV Title]
        Add : Field : After : LEDMailName : LVOPeningBalance
    
    [Field : LVOPeningBalance]
        Use     : Name Field
        Set as     : $$String:"Opening Balance: " + $$LocaleString:($OpeningBalance:Ledger:##LedgerName)
        Color     : Blue
     


  6. rajiv jaiswal

    rajiv jaiswal Member


    can we have the opening balance total as Cr or DR
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Code:
    [#Line : LV Title]
        Add : Field : After : LEDMailName : LVOPeningBalanceT, LVOPeningBalance
    
    [Field : LVOPeningBalanceT]
        Use         : Name Field
        Set as         : "Opening Balance"
        Color         : White
        Background    : Red
        Width        : 13
        Align        : Right
        Border        : Thin Box
    
    [Field : LVOPeningBalance]
        Use         : Amount Field
        Set as         : $OpeningBalance:Ledger:##LedgerName
        Color         : Yellow
        Background    : Black
        Format        : "DrCr, No Zero"
        Width        : 15
        Align        : Left
        Border        : Thin Box
    
     
    Jaydeep Shah likes this.


  8. ONKAR

    ONKAR Active Member


    @bikash agarwal,
    see this code

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

    [Field : LVOPeningBalance]
    Use : Name Field
    Set as : $$String:"Opening Balance: " + $$LocaleString:($OpeningBalance:Ledger:##LedgerName)
    Color : Blue


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

    [Field : LVClosingBalance]
    Use : Name Field
    Set as : $$String:"Closing Balance: " + $$LocaleString:($ClosingBalance:Ledger:##LedgerName)
    Color : red
     
    K V Shah likes this.


  9. rajiv jaiswal

    rajiv jaiswal Member


    can we show opening balance as starting balance of ledger.not that changes after another month
     


  10. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Finaly done, sea code

    [#Line : LV Title]

    Add : Field : After : LEDMailName : LVOPeningBalance

    [Field : LVOPeningBalance]
    Use : NAME Field
    Set as:$Address:LEDGER:##LEDGERnAME;+","+$StateName+","+$PinCode:LEDGER:##lEDGERnAME
    Color : Blue
    Line:2
    Width:50
    Background:WHITE
    Border:THIN BOX
    Style:TINY
    Type:String
    Skip:Yes
    ;+++++++++++++++++++++++++++

    [#Field:LV TITLE]
    Color:DPINK
    Local:Style:DEFAULT:Height:16
    Border:THIN BOX
    ;Background:pINK


    [#Field:DSP MainDateTitle]
    Color:DPINK
    Border:THIN BOX
    ;Background:pINK
    Local:Style:DEFAULT:Height:16

    ;++++++++++++++++++++++++++++++

    [#Part:LV ScrTitle]
    Add:Line:AT END:NEWLVTITLE, NEWLVTITLE1



    [Line:NEWLVTITLE]
    ADD: Left Field:NEWLVTITLE,NEWLVTITLE1
    Add:Right Field:NEWOPBAL,NEWCLBAL
    ;Local:Field:SIMPLE PROMPT:Background:DPINK
    Local:Field:SIMPLE PROMPT:Border:THIN BOX
    Local:Field:NAME FIELD:Border:THIN BOX
    [Line:NEWLVTITLE1]
    Add:Left Field:NEWLVTITLE2,NEWLVTITLE3
    Add:Right Field:NEWSUBDRAMT,newsubcramt
    ;Local:Field:SIMPLE PROMPT:Background:pINK
    Local:Field:SIMPLE PROMPT:Border:THIN BOX
    Local:Field:AMOUNT FIELD:Border:THIN BOX
    [Field:NEWLVTITLE]
    Field:Simple Prompt, Name Field
    Local:Field:Simple Prompt:Set as:"GSTIN No. :"
    Local:Field:name field:Set as:$PARTYGSTIN:Ledger:##LedgerName
    ;Local:Field:NAME FIELD:Background:WHITE
    Local:Field:NAME FIELD:Skip:Yes
    [Field:NEWLVTITLE1]
    Field:Simple Prompt, Name Field
    Local:Field:Simple Prompt:Set as:"Contact Person :"
    Local:Field:NAME FIELD:Set as:$LEDGERcontact:LEDGER:##LEDGERNAME
    ;Local:Field:NAME FIELD:Background:WHITE
    Local:Field:NAME FIELD:Skip:Yes
    [Field:NEWLVTITLE2]
    Field:Simple Prompt, Name Field
    Local:Field:Simple Prompt:Set as:"CELL No. :"
    Local:Field:NAME FIELD:Set as:$LEDGERMOBILE:LEDGER:##LEDGERNAME
    ;Local:Field:NAME FIELD:Background:GREY
    Local:Field:NAME FIELD:Skip:Yes
    [Field:NEWLVTITLE3]
    Field:Simple Prompt, Name Field
    Local:Field:Simple Prompt:Set as:"E-mail ID :"
    Local:Field:NAME FIELD:Set as:$Email:LEDGER:##LEDGERNAME
    ;Local:Field:NAME FIELD:Background:GREY
    Local:Field:NAME FIELD:Skip:Yes
    [Field:NEWOPBAL]
    Field:Simple Prompt, AMOUNT Field
    Local:Field:Simple Prompt:Set as:"OP. BALANCE :"
    Local:Field:AMOUNT FIELD:Set as:$OpeningBalance:Ledger:##LedgerName
    Local:Field:AMOUNT FIELD:Format:"DR,CR"
    ;Local:Field:AMOUNT FIELD:Background:WHITE
    Local:Field:AMOUNT FIELD:Border:THIN BOX
    Local:Field:AMOUNT FIELD:Skip:Yes

    [Field:NEWSUBDRAMT]
    Field:Simple Prompt, AMOUNT Field
    Local:Field:Simple Prompt:Set as:"DR SubTotal :"
    Local:Field:AMOUNT FIELD:Set as:$$Total:dspvchdramt
    Local:Field:AMOUNT FIELD:Format:"DR,CR"
    ;Local:Field:AMOUNT FIELD:Background:GREY
    Local:Field:AMOUNT FIELD:Skip:Yes
    [Field:NEWSUBcRAMT]
    Field:Simple Prompt, AMOUNT Field
    Local:Field:Simple Prompt:Set as:"CR SubTotal :"
    Local:Field:AMOUNT FIELD:Set as:$$Total:dspvchCramt
    Local:Field:AMOUNT FIELD:Format:"DR,CR"
    ;Local:Field:AMOUNT FIELD:Background:GREY
    Local:Field:AMOUNT FIELD:Skip:Yes
    [Field:NEWCLBAL]
    Field:Simple Prompt, AMOUNT Field
    Local:Field:Simple Prompt:Set as:"CL. BALANCE :"
    Local:Field:AMOUNT FIELD:Set as:$cLOSINGBalance:Ledger:##LedgerName
    Local:Field:AMOUNT FIELD:Format:"DR,CR"
    ;Local:Field:AMOUNT FIELD:Background:WHITE
    Local:Field:AMOUNT FIELD:Border:THIN BOX
    Local:Field:AMOUNT FIELD:Skip:Yes
     
    mpal2311 likes this.


  11. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    share screenshot.
     


  12. Jay kumar tailor

    Jay kumar tailor Well-Known Member



  13. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2018-9-8_11-32-6.png
    SEA SCREENSHOT
     
    chintamani likes this.


  14. mpal2311

    mpal2311 Active Member



    Good Work.
     


  15. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Thanks sir, mpal2311
     


  16. Jenny

    Jenny Active Member


    HOW TO GET "CASH" OPENING BALANCE???
     


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $OpeningBalance
     


  18. Bipin Damania

    Bipin Damania Active Member


    Dear Amitji and All Colleague

    I have Shifted Opening Balance Line from Bottom Part To Top of Body Part...

    Thank you

    upload_2020-1-10_13-58-20.png
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Nice idea and implementation.....Congrats....:)

    Ensure, it remains the same when you activate "Running Balance" and columnar.
     


  20. Bipin Damania

    Bipin Damania Active Member


    Dear Amitji

    Yes, it remains the same after activate "Running Balance" and not showing in Columnar Report.
    Thank you for the guidance.

    OpBal Line Shift Running Balance.jpg
     
    Amit Kamdar likes this.


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Good...it is perfect.... :):confused:
     


  22. arinda

    arinda New Member


    >Set as : $$String:"Opening Balance: " + $$LocaleString:($OpeningBalance:Ledger:##LedgerName)
    How to add current date/time/datetime here instead? Asking for knowledge purpose
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use MachineDate and MachineTime
     


  24. Bipin Damania

    Bipin Damania Active Member


    Thank you Amitji :)
     


Share This Page