How do I check if an AR aging report is complete when ARs are being processed continuously?
I have an AR aging report which is a snapshot at the time it was ran. I need to find out if all ARs were included in the report when it was ran. Normally, it would work if I just queried the database for all open ARs. But because ARs are continuously updated throughout the day, it's not as easy since the resutls of the query will be different than that of the report.
Which date fields and balance amounts can I use to test if it was complete? Any ideas?
Solution: How do I check if an AR aging report is complete when ARs are being processed continuously?
Perhaps as part of your AR Aging procedure, you could insert all the data into a temp table, run the report from the temp table.