I am trying to find accounts that have not paid. I can tell this by physically looking at each individual account to see if a period (ex: 03/08, 04/08, 05/08 etc.) is missing. Of course that is impossible because there are thousands of accounts.
Each account is broken into different tables and among them are "customers" and "transactions". How do I have CR look at each account and tell me which period is missing? Help!