Hi Jody

This issue is not "solvable" on a tech forum. There is an error somewhere in your data, probably a misposting, and it is up to you to find it.

That being said, here is my strategy for dealing with this kind of issue. Steps 1 thru 3 deal with prevention, steps 4 thru 9 deal with resolution.

1. When retrieving from AR into GL, always make sure to assign entries to "Period Based on Date". If "Specific Period" or "Subledger Period" are selected, then there is no way to reconcile except for the current moment.

2. Don't run AR period end as of a month-end date until the GL is ready to be closed for that month and until you have an Aged TB that agrees to the GL AR balance as of that month.

3. As soon as you meet the above conditions, run AR period end and then immediately close the GL period in the fiscal calendar. That way the GL won't change causing the Aged TB to not agree to the GL.

4. If there is a discrepancy, post all GL batches and retrieve from the AR subledger and post in GL.

5. Check to see what the discrepancy is RIGHT NOW.

6. If the figures tie right now, then you are done and you can explain away the prior discrepancy as a timing difference that self-corrected. If the figures don't tie, then you need to identify the period(s) where the discrepancy occured.

7. Scan through a GL detail listing of the AR account and look for anything with a source code that doesn't start with the letters AR (specifically looking for GL source codes). These are red flags - nothing should post to the AR account except for transactions that feed from the AR subledger.

8. Repeat step 5 as of the last month-end. Check to see if the discrepancy has changed from the RIGHT NOW discrepancy. If it has, then you need to investigate the details further.*

9. Continue working back month by month until you have identified changes in the discrepancy that match the amount you need to reconcile. If you have run a Period End, you won't be able to work back before the date of the period end, and you are stuck.

*How to investigate further is a subject for my next posting, in case you are at this point and would like to know.

Steve