I'm fairly new here, but I was wondering if anyone could help out/point me in the right direction.
I have a fairly large project and need to find thousands of invoice copies scattered around in a Dropbox account and file them with their check copy and purchase order copy.
I have Excel spreadsheets of the check numbers, invoice numbers and PO numbers, but not sure where I would begin?
The issue is some of the invoices are separated individually and others are all merged in one pdf, so I would need to be able to get the content from all of the pdfs to search for the invoices and then match those to the check copy they belong to.
So, I have one folder with all 3000 check copies and another folder with the 2200 po's.
I am able to find some in Finder - they're also all in DocuSign.
The problem there are a number of single files with 100+ invoices in one file all for different vendors etc that need to be split then merged in to the check copy they belong to.
I appreciate any help - I'm pretty new at this, but am in a major time crunch to get this completed.
It sounds like the first step is to explode the merged invoice files into a one invoice per file structure. Is there a naming scheme you need to stick to?
Also, not all PDFs are equal. Are these PDFs containing text, or scanned documents?
The final file which would be check copy with the invoices listed in the remittance, then followed by the invoice(s) and po(s) attached - that's what I meant by merge.
Some PDF's are scanned and others have text, some are hand written and hardly legible it's kind of a mish mash of everything.
The PO's and the Check Copies are all uniform in the same format all digital copies downloaded from our software. They are all named and in one location - it's the invoices that are the major problem.