show opening balance in ledger

Discussion in 'Tally.ERP 9' started by bharat shah, Mar 27, 2021.

    
  1. bharat shah

    bharat shah Member


    how to show opening balance at starting of ledger as show in attached file.i searched at ledger configuration
    but cannot find it
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You have to add the code for the same...........
     
    bharat shah likes this.


  3. bharat shah

    bharat shah Member


    amit sir i am not getting the amount correctly

    [#Part: LV Body]
    Add: Line: Before: DSP VchDetail: DSP VchOpBal1LedWise
    [Line: DSP VchOpBal1LedWise]
    Field :Info Field ; DSP VchDate, Info Field
    Right Fields : DSP VchDrOpAmt1LedWise, DSP VchCrOpAmt1LedWise, DSP VchLedBalance
    Local : Field : Info Field : Info : $$LocaleString:"Opening Balance"
    Local : Field : Info Field : Style : Normal Bold
    Local : Field : Info Field : Cells : If ##DBBillExplodeFlag Then @@NumDateTitleCells + 1 Else @@NumDateTitleCells
    Local : Field : Info Field : Align : Right
    Local : Field : Info Field : Color : Blue
    Local : Field : DSP VchDate : Inactive : Yes
    Local : Field : DSP VchLedBalance : Inactive : Yes
    ;Space Top : 0.5
    [Field: DSP VchDrOpAmt1LedWise]
    Use : Amount Field
    Set as :$OpeningBalance:Ledger:##LedgerName


    [Field: DSP VchCrOpAmt1LedWise]
    Use : Amount Field
    Set as : $OpeningBalance:Ledger:##LedgerName
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $LedOpeningBalance:Ledger:##LedgerName
     
    bharat shah likes this.


  5. bharat shah

    bharat shah Member


    Thank you amit sir. i got the value but how to hide it print because double opening balance is coming
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use Invisible or Inactive Attribute............. $$InPrintmode

    Check developer on how to use.........
     
    bharat shah likes this.


  7. bharat shah

    bharat shah Member


    ok got it
     


  8. bharat shah

    bharat shah Member


    Amir Sir how to decrease the gap as show
     

    Attached Files:



  9. Samiksha

    Samiksha New Member


    If you are using existing Tally's code, find the PART of Op.Bal or the next PART ........and you will find the attribute ... Space Top or Space Bottom. remove it.
     
    bharat shah likes this.


  10. bharat shah

    bharat shah Member


    my code is above and i have not define any attribute for space
     


  11. subash pal

    subash pal Member


    I want to opening balance "0" or "Nill" or "-" instead of Empty, Please Help me sir
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    change amount field to "number field"
     
    subash pal likes this.


  13. subash pal

    subash pal Member


    Thank you sir
     


  14. subash pal

    subash pal Member


    I changed Amount field to Number Field , but Dr Cr Symbol not show, Please suggest sir
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You cannot bake the cake and eat it too......as the saying goes...........
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    try using Format in your Field.......... learn from the developer .... how to use various options of format.
     


  17. subash pal

    subash pal Member


    ok thank you sir i will try it
     


  18. subash pal

    subash pal Member


    Requesting on all Developer

    how to use various options of format in Field.
     


Share This Page