View Point Vista Software - Output to MS Access

Job ID: 33249275

Budget: $1,500 – $3,000 CAD

We use View Point as the ERP for our construction company. Due to SOX controls on access we have some limitations in granting access to various functions. I am looking to have a database tool (MS Access or other) to be developed that import data from existing reporting (you will not have direct data base access to simply pick and choose fields to be used). We have a number of reports that customer master data, and the aged trial balance that shows balance by project that the customer owes. I am looking for a customer contact tool that will hold some customer master data, but will also allow for the addition of more data by a user. Those additions would stay in Access and will not pass back to our ERP. I would like to update the data base daily toshow invoices that remain unpaid. Lastly, I am looking for a call management function that would allow staff to make collection follow up calls (date/time/user stamped comments). Before uplading files, I would need a standard non-disclosure signed to proceed. Thanks