# How to run the AP aging report in Sage 300 CRE

In Sage 300 CRE, run the AP aging report as at your chosen date. Check the total ties to your accounts payable balance and look at items over 30 days.

An aged payables report lists what you owe each supplier, grouped by how overdue each bill is.

## The Sage 300 CRE way

Where to find it: Accounts Payable > Reports > Invoice Registers > Open Invoices w/ Cut-off Date

1. Run Open Invoices w/ Cut-off Date for a past date.
2. Or use the AP Aging dashboard reports (Mobile Dashboard).
3. Because Accounts Payable in Sage 300 CRE is a close-year application, you do not roll back a period to age at a past month end. Use the report cut-off date instead.
4. That answer names Invoice Aging w/Cutoff Date under Reports > Cash Management. The TUG 2017 reconciliation lab names Accounts Payable > Reports > Invoice Registers > Open Invoices w/ Cut-off Date. Check which menu your version shows.
5. Run the aging, then compare it with the General Ledger. The TUG lab lists Accounts Payable > Reports > GL Reconciliation > Period End Report for AP (RP) accounts as the third report to agree.
6. For the dashboard, the v22 release notes describe AP Aging - Vendor Detail (open invoices with invoice number, invoice date, accounting date, invoice amount and remaining retainage payable) and AP Aging - Vendor Summary.

## Limits in Sage 300 CRE

- Dashboard AP Aging - Vendor Summary shows aging periods and an open retainage column.
- The dashboard Vendor Summary grid shows open amount, open retainage amount, average days open and each aging period, with drill-down by vendor.

## Good to know in Sage 300 CRE

- The TUG lab warns to check the Open Invoices w/ Cut-off Date report for negative values. A check dated before the invoice accounting date by mistake can put AP out of balance with the GL.
- The v22 release notes also list an AP Open Invoice Detail dashboard report, with the invoice balance, open retainage and net amount owed for each vendor.

## Common mistakes

- Running the report without a cut-off date when you want a past month end.
- Reading the dashboard Vendor Summary as if retainage were already paid. It has its own column.

## Common questions

### Which report shows invoices open at a past date?

Open Invoices w/ Cut-off Date, under Accounts Payable > Reports > Invoice Registers. Sage 300 CRE users also name Invoice Aging w/ Cutoff Date.

### Is there an aging dashboard?

Sage v22 release notes describe AP Aging dashboard reports. The Vendor Summary shows aging periods and an open retainage column.

### Why might aging not match the ledger?

Entries made to the AP account outside AP are one cause. Compare the Period End Report for AP Accounts, the GL balance and Open Invoices w/ Cut-off Date.

### Does Pulsify run this report?

No. Run it in your accounting system.

## Sources

- https://communityhub.sage.com/us/sage_construction_and_real_estate/f/sage-300-construction-and-real-estate/253613/moving-accounts-payable-retention-to-accounts-payable
- http://docs.sage.com/docs/en/customer/300cre/22/open/ReleaseNotesAcctMgmt_22.pdf
- https://cdn.ymaws.com/www.tugweb.com/resource/resmgr/2017_Regional_Workshop/2017_Regional_Session_Materials/1-6_and_1-7_Reconciliation_L.pdf
- https://communityhub.sage.com/us/sage_construction_and_real_estate/f/sage-300-construction-and-real-estate/274840/ageing-after-moving-to-next-month-ap-and-ar

Source: https://www.pulsify.tech/how-to/run-an-aged-payables-report-in-sage-300-cre/ (last checked 2026-10-19)