Ledger without Transaction

Discussion in 'Tally Developer' started by Manoj Garg, Oct 8, 2012.

    
  1. Manoj Garg

    Manoj Garg Member


    Dear Experts,

    How to know the list of ledgers that have no transactions.

    Rgds,
    Manoj
     


  2. Gunasekaran

    Gunasekaran Member


    Dear Manoj:
    Please Check the Tally.ERP9 Rel 3.0 Above
    Display-Audit&Compliance-Audit&Analysis-Verification of Chart of acounts-Not Used Ledgers.

    Thanks And Regards
    Gunasekaran.S
     


  3. admin

    admin Administrator Staff Member


    Ledgers which does not have Debit or Credit Transaction Amount, those are not having vouchers

    $$IsEmpty:$DebitTotals AND $$IsEmpty:$CreditTotals
     


  4. Manoj Garg

    Manoj Garg Member


    Thanks to Gunasekaran.S and Admin Sir.
     


  5. sowmyashree v s

    sowmyashree v s New Member


    Hello,
    please tell me how to extract/export the stock summary from the tally through xml interface. I'm using $$NumStockItems, as a function type but it is not extracting complete information, I want to extract the stock list of articles and its corresponding shades please help me
     



  6. how can i delete ledger having no transactions? ledger only belong to Sundry Debtors and Sundry Creditors Group.
    Plz help me..
     


  7. mpal2311

    mpal2311 Active Member


    Got this codes from surfing the net. Sharing with you.

    [#Menu : Gateway of Tally]


    Item : Delete Empty Ledgers : Display : EmptyLedgerReport

    [Report : EmptyLedgerReport]

    Title : "Ledger Master"
    Use : MS Report

    [Report : MS Report]

    Form : MS Report

    [Form : MS Report]
    Height : 100% Page
    Width : 100% Page
    Part : MS Report, MS Report1


    Button : Gr DeleteSelected
    Button : Gr Btn Select All,Gr DeleteAll
    Key : Gr Shift Down Select


    [Part : MS Report]
    line :MS Report Title , MS Report
    Repeat : MS Report : My masterSCSD


    Scroll : vertical
    Common border : yes

    [Line : MS Report Title]
    Field : MS Report sl, MS Report

    Border : thin Top Bottom

    Local : Field : Default : Style : Normal bold
    Local : Field : MS Report sl : Set as : "Sl. No"
    Local : Field : MS Report : Set as : "Name of Sundry Debtors"


    [Line : MS Report]

    Field : MS Report sl, MS Report


    [Field : MS Report Sl]
    set as : $$line
    Width : 5
    Border : Thin Left Right

    [Field : MS Report]

    set as : $Name
    Width : 25


    [Part : MS Report1]

    line :MS Report Title1 , MS Report1
    Repeat : MS Report1 : My masterSCSD1

    Scroll : vertical
    Common border : yes

    [Line : MS Report Title1]
    Field : MS Report sl1, MS Report1

    Border : thin Top Bottom

    Local : Field : Default : Style : Normal bold
    Local : Field : MS Report sl1 : Set as : "Sl No"
    Local : Field : MS Report1 : Set as : "Name of Sundry Creditors"


    [Line : MS Report1]

    Field : MS Report sl1, MS Report1


    [Field : MS Report Sl1]
    set as : $$line
    Width : 5
    Border : Thin Left Right

    [Field : MS Report1]

    set as : $Name
    Width : 25

    [Collection : My masterSCSD]

    Type : Ledger
    ChildOf : $$GroupSundryDebtors ;; $$GroupSundryCreditors
    BelongsTo : Yes
    Compute : IsEmptyObject : $$IsEmptyObject
    Filter : ONlyempty


    [Collection : My masterSCSD1]

    Type : Ledger
    ChildOf : $$GroupSundryCreditors
    BelongsTo : Yes
    Compute : IsEmptyObject : $$IsEmptyObject
    Filter : ONlyempty


    [Button: gr DeleteSelected]
    Title : "Delete Selected"
    Key : Alt + D
    Action : Delete Object
    Mode : Display

    Scope : Selected Lines

    [Button: Gr DeleteUnselected]

    Title : "Delete All"
    Key : Ctrl + E
    Action : Delete Object
    Mode : Display

    Scope : Unselected Lines

    [Button: Gr DeleteAll]
    Title : "Delete All"

    Key : Ctrl + D
    Action : Delete Object
    Mode : Display

    Scope : All Lines

    [Button: GR Btn Select All]
    Title : "Select All"

    Key : Ctrl+A


    Action : Select All
    Mode : Display

    [Button: Gr Btn Select None]
    Title : "Select None"

    Key : Ctrl + 8


    Action : Unselect All
    Mode : Display


    [Key: Gr Shift Down Select]
    Title : "Select"
    Key : Shift + Down


    Action : Toggle Select
    Mode : Display

    [System : Formula]
    ONlyempty : $$IsEmptyObject
     


  8. psjain_jal

    psjain_jal Member


    Got this codes from surfing the net?????????????????????????

    from which sit you got it?????????
     


  9. mpal2311

    mpal2311 Active Member


    As you have mentioned on this site that your sister's marriage is in this month. Your presence is more important there, instead of surfing the net and finding the TDL codes to copy and paste.
     


  10. Alok Roy

    Alok Roy New Member




    Hi Manoj Sir do you remember this post.......
     


  11. Manoj Garg

    Manoj Garg Member


    what is the problem in this post.
     


  12. anil sharma

    anil sharma New Member


    Dear Experts,

    I create a report 'month wise expenses',how to compare with last year expenses,i attached my Report
    Pls help me.

    sno apr may jun jul aug sep....
    1 Tea Expenses
    2012-13 100 200 300 400 500 600
    2013-14 200 300 100 200 300 900

    2 Conveyance
    2012-13 100 200 300 400 500 600
    2013-14 200 300 100 200 300 900
     

    Attached Files:

    • mwe.txt
      File size:
      3.6 KB
      Views:
      67


Share This Page