TDL for Cash Control

Discussion in 'Free Source Codes' started by JObimon Arackal JOhn, Apr 9, 2013.

    
  1. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member


    Actually i am learning TDL by referring available books in the market .and available resource in

    the web.
    I tried to make a tdl enhancement as part of learning activities.
    The code is given below. please go through it. if somebody can tell me how to improve the codes or

    increase the performance or any defects of these tdl it will help me in my study of TDL language

    Thanks in advance.
     

    Attached Files:



  2. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member


    Removed error
     

    Attached Files:



  3. admin

    admin Administrator Staff Member


    Great :) Keep it up sir :)
     


  4. Aniket

    Aniket New Member


    good one..
     




  5. Balaji

    Balaji New Member


    How to use this TDL ??
     


  6. bharat.barai

    bharat.barai New Member


    I HAVE INSTALLED CASH CONTROL TDL. WHAT IS THE USE OF THIS TDL. PLS INFORM. THANKS WITH WARM REGARDS
     


  7. sayed

    sayed Member


    How to use this TDL ??
     


  8. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    Try to make payment in cash 20000 or more it will not accepct.

    As per IT Act a business firm in india can not make a single cash payment above 20000 to a single party. If it is more than 20K it will not accept.
     


  9. HVPatel

    HVPatel Active Member


    Great work Sir,
    But
    Cash Dis-allowance U/s 40 A(3) of IT Act,
    If we pay in cash to a party in a single day more then 20000/- it is Disallowed.

    Above code validate & Worked if single cash transactions for Rs. 20000/- or above.
     

    Attached Files:



  10. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member




    It allows Multiple transactions

    My intention of this code was Slightly different.

    An accountant Executive who is in hurry to enter transactions; may club bills of different date and enter in a single date ( In my previous company My Assitant always do when bills are received( on Weekly Basis) from different site ).Some times it may go Rs:20000/- above. In that cases It First looks violation of rule, even though bills are of different date. When She clubs the bills and enters as single entry it remembers her that she is trying to enter amount more than 20000.Hence she split the entry date wise (may be two or more date According to the amount) and will enter.If the total bills are less than 20000 she will enter as a single bill. It save a lot of time.


    Since you understood the problem, I hope that you will give a better solution.
     


  11. HVPatel

    HVPatel Active Member


    Yes Sir,
    I am trying to make for the code as per IT Act. since 1 year, but not success yet.
     


  12. sanjaygori

    sanjaygori New Member


    how to entry in contra as cash deposit in bank
     


  13. dipu369

    dipu369 Member


    very good sir , You are controlling only one time . But It is mandatory to control Cash i..e, You can not take more than 2 lacs from a party in total financial year . First you can not take more than Rs.10000/- from anyone and also in aggregate in a single financial year you can not take total 200000/- all together . So sir how to restrict user for entering that one . If user put any party at the time of Receipt voucher entry , the program check previous cash transaction of that party whether it is below 2 lacs or not .
    please give me the solutions
     


  14. dipu369

    dipu369 Member


    the below program will check the present entry of Cash not more than 10000/- but it will not check the said party 's previous cash transactions from the ledger that it will not exceed Rs. 200000/- in a financial year . Please do the needful .

    your program is given below :

    [#Field: ACLSAmt] ;; This field for Receipt, Payment, & Contra Entry

    Control : VchCashLimit : NOT $$IsEmpty:$$Value AND $$Value > 10000 AND @@IsCashLedPresent AND $$IsReceipt:$VoucherTypeName

    [System : Formula]
    VchCashLimit :"Cash Disallowance U/s 40A(3) of IT Act."
    IsCashLedger : $$IsLedofGrp:$LedgerName:$$GroupCash
    IsCashLedPresent : $$FilterCount:AllLedgerEntries:IsCashLedger > 0
     


  15. dipu369

    dipu369 Member


    the below program will check the present entry of Cash not more than 10000/- but it will not check the said party 's previous cash transactions from the ledger that it will not exceed Rs. 200000/- in a financial year . Please do the needful .

    your program is given below :

    [#Field: ACLSAmt] ;; This field for Receipt, Payment, & Contra Entry

    Control : VchCashLimit : NOT $$IsEmpty:$$Value AND $$Value > 20000 AND @@IsCashLedPresent AND $$IsReceipt:$VoucherTypeName

    [System : Formula]
    VchCashLimit :"Cash Disallowance U/s 40A(3) of IT Act."
    IsCashLedger : $$IsLedofGrp:$LedgerName:$$GroupCash
    IsCashLedPresent : $$FilterCount:AllLedgerEntries:IsCashLedger > 0
     


  16. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member



    Filter "AllLedgerEntriesCollectionA" with Party Filter.

    there must be tow control. One is for the day and another is for year.
    For that purpose
    1) "AllLedgerEntriesCollectionA" should filter with CurrentDayFilter & PartyFilter
    2) "AllLedgerEntriesCollectionA" should filter with CurrentFinancialYearFilter & PartyFilter
    I think you can easly do
     


  17. dipu369

    dipu369 Member


    Thanks Sir, I am not very expert , please write it elaborately . Not only for me , it will help all members.
     


  18. dipu369

    dipu369 Member


    Thanks Sir, I am not very expert , please write it elaborately . Not only for me , it will help all members.
     


  19. dipu369

    dipu369 Member


    Sir please give the full code . It will very help me . Sir please . Previous programe is also done by you only.
     


  20. dipu369

    dipu369 Member


    Sir have you started ?
     


  21. dipu369

    dipu369 Member


    Sir PLEASE Give me the code , i will be grateful to you
     


  22. dipu369

    dipu369 Member


    Sir I have tried in another way i.e., if I calculate the total cash receipt of any particular ledger and get the value then we can compare with the amount of Rs. 200000/-
    Is n't it ?

    So I have tried to get the total cash transaction from receipt voucher FORM . But here sales , journal voucher all type of voutype are coming . How to stop that other voutype because I want only Receipt voucher . Please help me and guide .
     

    Attached Files:



Share This Page