Section 40A(3) cash payment limit daily basis

Discussion in 'Tally Developer' started by jgkumar1976, Apr 28, 2020.

    
  1. jgkumar1976

    jgkumar1976 Member


    Admin sir how to collect the cash and debtor -creditor group and filter the daily cash entries please assist

    this is helpful for section 40A(3)

    thank you
    Waiting for your reply asap
     
    Akhilkumarj likes this.


  2. jgkumar1976

    jgkumar1976 Member


    Voucher Collection

    Voucher Having cashGroup entry for particular ledger then
    check if there is Debit values then
    check Date field and store in a variable and
    then Count the Voucher on that day and
    The Sum of Debits Value for A Day
    if sum of Value is More than 10000 then store in variable


    any body assist me to how ,as object or something else
     


  3. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Make A collection of Payment Vouchers.
    Compute Sum for date <>
    Put Filter For Cash.
     


  4. jgkumar1976

    jgkumar1976 Member


    I tried lot a time but result zero
    Would you pls write me that collection
    Need collection daily
     
    Last edited: May 2, 2020


  5. jgkumar1976

    jgkumar1976 Member


    Be
    becos there will be accepts the cash entry voucher in journal also
     


  6. jgkumar1976

    jgkumar1976 Member



    sir pls look the code i struck at getting only cash payments daily and cash receipts daily
     


  7. jgkumar1976

    jgkumar1976 Member


    getting collections little bit late , even used keepsource : ().

    is there any option to get fast ??
     

    Attached Files:

    Akhilkumarj likes this.




  8. jgkumar1976

    jgkumar1976 Member


    To Admin Amit Sir
    [system :formulae]

    TransLedFilter : $.LedgerName = #MydspLedger or $AllLedgerEntries[1].ledgername = #MydspLedger or $AllLedgerEntries[2].ledgername = #MydspLedger or $AllLedgerEntries[last].ledgername = #MydspLedger or $AllLedgerEntries[3].ledgername = #MydspLedger or $AllLedgerEntries[4].ledgername = #MydspLedger or $AllLedgerEntries[5].ledgername = #MydspLedger



    I am Using Filter Like This , i think this wrong but getting results correctly, if vouchers having ledgers upto five items ,
    please suggest required
     


  9. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  10. jgkumar1976

    jgkumar1976 Member



  11. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    above Rs.200000/- cash limit
     


  12. PHOENIX HELIOS

    PHOENIX HELIOS New Member


    My Cash Receipt Report
     

    Attached Files:






  13. Actually 40A 3 report is not only for a single voucher above Rs.XXX. we have to total of each ledger for each day, and then it will correct report
    see as above i have done it and getting perfect report.
    even payment from bank or cash paid in bank should not be a part of this report

    also variable set by button to set limits ( previously 20,000, now 10,000. and you can set limit for ledger specific.

    for eg. payment to transportation is allowed upto 35,000 for each voucher.
     


  14. jgkumar1976

    jgkumar1976 Member



  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Your Filter is wrong..........Use......$$IsLedOfGrp:$Name:$$GroupCash
     


Share This Page