Solution:

This article explains how to use the report option grid in the As of Aging Report.

The As of Aging report is a snapshot in time of what was open as of a particular date. The report totals should balance against General Ledger (GL) as long as everything has been released and posted in GL, there are no open sessions, no journal entries to that account in GL, and the Accounts Payable (AP) account is not used in other modules.

The As of Aging is not based on a single AP control account. It does not differentiate between accounts if using multiple control accounts. Also, this report uses the APDIST, APYDST, APMAST, and APYMST tables.

As of report or a Normal Aging report:

• Select “NO” for As of to show all payables that are currently open
• Select “YES” for As of to show open payables as of a particular date

Report Type:

• Past Due – groups payables by past due aging periods
• Transaction Posting Date – groups payables due as of the invoice posting date, not the invoice date
• Forecast – groups payables by future aging periods, it uses due date

© Copyright Sage Software