A/P Aged Payables Report Screen

Overview

Note: Depending on how your system is set up, this desktop screen may also be available as a web screen. For more information, see the Web Screens Getting Started Guide or the help for Sage 300 web screens.

The Aged Payables report groups outstanding transactions into a current period and four aging periods by document date or due date.

Use the report to analyze your payables.

You can print detailed or summary reports;

• The detailed report lists all outstanding documents for each vendor.
• The summary report prints one line for each vendor number, including the current balance and the balance in each aging period.

Note: You also print the Overdue Payables By Due Date and the Overdue Payables By Document Date reports using the Aged Payables Report screen.

When to Print

Print the Aged Payables report when you need a listing of the status of your payables on a given date, such as at the end of a fiscal year or period, or when you want to identify documents or balances you may need to write off.

Information Printed on This Report

• The Due Date/Applied Number/Applied Type column lists the due date for documents at the left, and the document number and type of applied details at the right.
• The Current column contains documents that are not yet due. Credit notes, debit notes, and prepayments appear in this column if you select As Current for the Age Credit Notes And Debit Notes and Age Prepayments options in the A/P Options screen. (You can choose whether to include prepayments when printing the report.)
• The vendor contact and phone number, and your company's credit limit with the vendor are listed if you select the Contact/ Phone/Credit option.
• Subtotals (for a single currency company), or subtotals by currency (for a multicurrency company), if you select Vendor Group or Account Set as the primary sort order. Subtotals appear on both the summary and the detail report.
• Extra space appears between each vendor record if you select the Space For Comments option.
• Miscellaneous payments appear as "MC" in the Document Type or Applied Type column.
• Reports aged by due date can display aged retainage for each vendor. (This option is not available if the report is aged by document date.)

• The summary version of the report includes one line for each vendor number, listing the current balance in the vendor's account and the balance in each of four periods.