We would like a routine/module which will read or listen on a particular directory for PDF documents. This should parse the new PDF documents arriving in this location and parse out the information. After that store that information into Quickbooks. I have uploaded two PDF for review. It has a fixed structure in place. I need to create an estimate in QB using the same information. Currently, we are doing cut and paste into QB. I would like to automate this process.
In QB, it should create the Customer Name (if it does not exist), create a new estimate#, and then add items (if they do not exists in QB). If they do, then the description in the PDF needs to be seen in Estimates and update the price too for that Item.
Why do we need to do that? We are Value Added Reseller (VAR) and we get quotes from our distributors and then we have to provide same quotes to our end-customer on our letterhead. Currently this process is getting too tedious.
I would prefer a "C" language routine, but open to other options too.