Q. Why doesn't the AR Aging Detail with Prepays as of report match the GL account information?
A. You want to be sure that all invoices have been released and posted to the GL. The AR Aging Detail with Prepays As Of report does NOT list invoices that have NOT been released/posted to the GL yet. This report is intended to match the GL account information not the AR Aging screen. Note: If this report is still not matching the GL account information after all transactions have been released and posted to the GL then it may be due to Posted Journal Entries against the AR GL account. These JE's will not be accounted for on the AS OF report yet will affect the GL Account balance and could explain why you are seeing a difference between the two.
Back dating records may also be a possible cause for the Aging As Of reports to not match the Trial Balance at a specific given time. For Example: If the user current date is 10/05/2009 and they enter in an Invoice and Credit Memo dated 10/5/2009. But then on the same day the user applies the Invoice and Credit Memo (dated 10/5) against each other via an AR Offset upon saving the Offset they decided to backdate the offset to 9/30/2009. This will cause the As Of report to temporarily not match the Trial Balance due to the fact that the report will pull in the offset backdated to 9/30, but it will not account for the Invoice and Credit memo records until 10/5/2009. The reports will come back in line after the 10/5/2009 date.
Note: You need to be looking at two GL accounts when it comes to the AR Aging As Of Report. This is due to the fact that we include Prepayments. Attached are some Print Screens <<Ar-Aging_versus_GL_Reports_2011-04-14.docx>> that show how the AR Aging can be compared to these two reports.
|