Keeping in view Pan Number Errors in e-tds/e-tcs return, some trick is required to aovid PAN errors in Quarterly TDS data. If a person/deductor enter PAN numbers manually in TDS/TCS return data, there are lot of changes of errors. Errors do not depend upon a particular person, but it is human. Manual interaction in Data Entry generate such type of errors.
To avoid PAN Number errors in preparation of Quarterly Salary Data, a simple utility has been prepared in Microsoft Access named TDS Salary.
File Size 3.75 m.b. (Download )
Installation :- Just download and use.
How to Use : - Two tables = Data and Employees
Two Forms = Data Entry and Employees
Two Queries = Refresh Data File and Name Search
Two Forms = Data Entry and Employees
Two Queries = Refresh Data File and Name Search
- Base Data or Master Data of employees can be stored in Employees Table and Quarterly Data will be stored in Data Table.
- To store Quarterly data , Data Table can be stored after pressing refresh Data File.
- Data entry can be done through both forms either from Data Entry Form or from Employees Form. Vice versa links are available in both forms.
- Use query "Refresh Data File" after adding new entry. There will a meesage to ask
"Are you sure you want to run this type of action query ?
Form information on how to prevent this message from displaying every time you ran an action query,click help."
Press Yes to Run and again Press Yes to update Data file.
No comments:
Post a Comment