I have used DEVONthink for a few years to store invoices and other documents that relate to our company. These are manually added via the inbox as pdf’s, I annotate a reference number to the invoices using a text box, then file away into an “invoices” group.
What would be really handy would be a way to sum up all the invoices that relate to a particular reference number (the text box that I added).
I fully appreciate that if a solution was possible within DT, that I would need to edit each one of these documents in some way.
Was wondering if any of you DT experts had any ideas? I barely scratch the surface with my DT knowledge!
My current thinking is that I will need to export all the invoice documents to an external database (maybe FileMaker), then add fields for amount and reference number for each invoice record. Is there a simpler method and staying within DT?
At least for the OCRd documents, you could check out the result of the document amount placeholder, as suggested by @cgrunenberg. That might save you some work. For handwritten documents, that’s not an option, of course.
To be honest, I think you are making this too complicated and expecting too much from DEVONthink given your situation. Unless you have a large number of incoming invoices which would benefit by an investment in automation, I think:
process incoming as you do. Add the reference info you mentioned into the PDF if you like, but perhaps more valuable would be to append that info into the file name. If pertinent info in the file name, then it opens the possibility of simpler use of DEVONthink rules (should that be of value) to add meta data or tags or whatever.
put a new line item in your database or spreadsheet of the invoice and do you summing (and other computations that you may wish, e.g. sum by Vendor or something) there. Filemaker is of course more sophisticated and complex than a spreadsheet. I’d go with a spreadsheet unless you have more complex needs. Numbers if free in macOS, and of course there is Microsoft Excel. Record your reference information, file name, perhaps a link to the DEVONthink file, etc. as a spreadsheet column or a Filemaker database field.
Use the information inspector panel (Devonthink > Tools > Inspectors > Show) if you’re running the Pro or Server editions.
As you can see in the screenshot, there are Generic and Custom panels
Custom fields are set up in Devonthink > Settings > Data