comparing data fields
We are using QB as our main database to track our Project management dates. Our client uses another database. We need to have both databases show the same data. We can not do bulk imports into the Cli...
Forum Discussion
They do not use QB, so we can't sync our data into their system. Unfortunately, we are forced to manually input data into their system.There are no other options than a manual input. I do currently have their data set up on a table. (I pull an excel report out of their system and import it to our system), so I do use lookup fields for some of the data. However our management wants our team to use our QB to input the data. So we will have to have two sets of data, there's no way around that. We want our QB data to be the source data, but we can't go through hundreds of projects and hundreds of tasks on a daily basis to see what is different between the two systems. So we need a way to see what data has changed in QB, compare it to the data on the table of the imported data and show the differences, so that we can have a data entry person manually change it in the Clients system without going project by project, task by task.