1. Create a macro based home page with buttons like - consolidate files , scan files and report
2. On click to consolidation, system opens the upload file option and user selects excel file to upload it. Other file format if used will throw error
3. Upload files will consolidate and throw duplicate row errors (if any)
4. Scan file will give option to user to scan the records in text file. It will handle no record found and duplicate scan error. On submit system will enable generate report button. On this report will be generated based on report selection. All scanned records will be removed from the consolidated file.
3. Generate report will regenerate report of already scanned based on date and show I scanned report with ageing. And alos create summary report date wise - total records consolidated, total scanned and total unscannes