This project involves adding functionality to an? existing Microsoft Access/VBA? application used in back office accounting. The main features? of the existing app are: ? importing sales data from text source files; parsing the data; the entry of expenses; report generation; and export of sales and expense data to Quickbooks through a third party QODBC driver which allows the Quickbooks tables to be modified via SQL. Originally, I had included debugging? of this app? in this request; however, the problems with the code have been eliminated, and? I have modified the bid request accordingly.
Your job, i.e. the functionality that needs to be added, is syncronization of? the expense table and line entry table with a set of four? entry and? line entry? tables based on the type of the? expense (eg Bill, Check, Credit, Sales Receipts).? Also, syncronization of vendor and? account tables need to be performed.? The user would be prompted to resolve additions, deletions and renaming of entries.
I would also like a the ability to select the directory of my source text files in a browser window, after which the table? links would be updated.