Trial Balance - On pressing Enter display Ledger Vouchers directly instead of Ledger Monthly Summary

Discussion in 'Tally Developer' started by PHOENIX HELIOS, May 30, 2020.

    
  1. PHOENIX HELIOS

    PHOENIX HELIOS New Member


    Dear Experts

    I'm struggling to find a solution for opening directly ledger voucher instead of first going to ledger monthly summary and then selecting the month.

    In Trail Balance, if you press enter on any ledger, Tally will take to Ledger Monthly Summary of the selected ledger. After that I need to select the month and then press Alt+F1 to change the period for the whole year. The process becomes very cumbersome when you have to go through a lot of ledgers.

    Is there a way I can bypass this ledger monthly summary? Please help
     


  2. jgkumar1976

    jgkumar1976 Member



  3. PHOENIX HELIOS

    PHOENIX HELIOS New Member


    How can I do this? Please help sir.

    I tried creating Trial Balance TDL of my own and then linking those ledgers with Ledger Voucher view. But there is one problem - the value of Stock is shown as closing balance instead of opening balance. Due to this there is always difference between Total of Cl Balance Dr Side and Total of Cl Balance Cr Side. If you observe Tally's main Trial Balance. The value of stock is Opening Balance. Same is the problem in Tally sample TDLs relating to Trial Balance. Even here I have searched for Trial Balance TDL codes but same problem.

    So I thought of modifying the main Trial Balance of Tally. But here is where I'm stuck.

    In case of Ledger Voucher view I was able to modify according to my needs thanks to Jay Kumar Sir's posts here in TDLExperts. But I could not find a single post relating to modification of Tally's default Trial Balance.

    Your guidance will be of immense help.
     



  4. In sample there is code for trial balance. I have taken and modified.
    [Report: Simple Trial balance]

    Form : Simple Trial balance
    Title : "Trial Balance"

    [Form: Simple Trial Balance]

    Parts : Simple TB Part
    Height : 100% Page
    Width : 100% Page

    [Part: Simple TB Part]

    Lines : Simple TB Title, Simple TB Details
    Repeat : Simple TB Details : Simple TB Ledgers
    Scroll : Vertical
    CommonBorder: Yes

    [Line: Simple TB Title]

    Use : Simple TB Details
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Centre
    Local : Field : Simple TB Name Field : Set as: "Particulars"
    Local : Field : Simple TB Amount Field: Set as: "Amount"
    Border : Flush Totals

    [Line: Simple TB Details]

    Fields : Simple TB Name Field
    Right Fields: Simple TB Amount Field
    Option : Display On Enter
    [Field: Simple TB Name Field]

    Use : Name Field
    Set as : $Name
    Variable : LedgerName
    Display : Ledger Vouchers
    [Field: Simple TB Amount Field]

    Use : Amount Field
    Set as : $ClosingBalance
    Border : Thin Left

    [Collection: Simple TB Ledgers]

    Type : Ledger
    Filter : NoProfitsimple
    Fetch : Name, ClosingBalance

    [System: Formula]

    NoProfitSimple : NOT $$IsLedgerProfit



    I hope this will help you.
     


  5. aohpak

    aohpak New Member


    Sir, if there was a search option in it, it would be very good.
     


Share This Page