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.
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.
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.
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.
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
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
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
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
Thanks Sir, I am not very expert , please write it elaborately . Not only for me , it will help all members.
Thanks Sir, I am not very expert , please write it elaborately . Not only for me , it will help all members.
Sir please give the full code . It will very help me . Sir please . Previous programe is also done by you only.
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 .