Great thread and very helpful for a similar project we are working on. Our routine produces a list that identifies missing documents, and e-mails it away, using a DB query and the For Each Row task. Looks like this:
Please send us the following items:
March, 2014, C. Bank Statements, PNC #0567
March, 2014, C.Bank Statements, Chase #1111
March, 2014, D. Credit Card Statements, Chase #7159
March, 2014, E. Sales Tax, ST-50
April, 2014, C. Bank Statements, PNC #0567
April, 2014, C.Bank Statements, Chase #1111
April, 2014, D. Credit Card Statements, Chase #7159
April, 2014, E. Sales Tax, ST-50
May, 2014, C. Bank Statements, Chase #9999
May, 2014, C. Bank Statements, PNC #0567
May, 2014, D. Credit Card Statements, Chase #7159
May, 2014, E. Sales Tax, ST-50
Or we will nag you endlessly. Thank you, Laserfiche Workflow
We used tracking as the item was indexed, and then ran a bunch of SQL. We were concerned about the overhead of searching folders, plus needed to allow for bank accounts being added and closed over time. Workflow remains a delight every time we set something up!