An aged payables report lists what you owe each supplier, grouped by how overdue each bill is. What is accounts payable?
The Kinetic way
Where to find it: AP Aging Report
- Run the AP Aging Report with an as-of date
- Compare the result to the GL AP balance
- Set the aging columns in the aging report format (age days and labels)
Limits in Kinetic
- The dashboard query zHomepage_APAgedPayables takes open, posted invoices with a balance and ages them from the last payment due date on the invoice schedule.
Good to know in Kinetic
- The article on reconciliation lists AP vs AP Control Account and Received but Not Invoiced vs AP Clearing as BAQs worth building.
What to watch in Kinetic
- Run AP Aging Report with an as-of date. Set the aging columns in the aging report format with age days and labels.
- A future-dated payment leaves the invoice showing as unpaid on a report run as of today.
- The dashboard query zHomepage_APAgedPayables takes open, posted invoices with a balance and ages them from the last payment due date on the invoice schedule.
- Compare the result with the GL AP balance every time. A difference after an upgrade or conversion needs a closer look.
- Confirm the menu path for the report on your version.
Example in Kinetic
Example Pty Ltd runs the AP Aging Report with an as-of date of 30 September. A payment group check dated 3 October for $4,200 was already printed.
| Line | Amount | Tagged to |
|---|---|---|
| Current and 31 to 60 days | $24,600.00 | Per the aging columns set in the report format |
| Check dated 3 October for the supplier | $4,200.00 | Still shows as unpaid at 30 September |
| GL AP balance | $28,800.00 | Compare with the report total |
The report and the ledger agree once you allow for the future-dated check. Without that note, the $4,200 looks like a mistake.
Common mistakes
- Running for the current date when payments are future-dated.
- Not comparing the report to the GL AP balance.
More help
- How to run the Vendor aging report in Dynamics 365 Finance
- How to run the supplier aging report in IFS Cloud
- How to run the A/P Aging Report in CloudSuite Industrial
- How to apply a debit memo to a supplier invoice in Kinetic
- How to close the month in accounts payable in Kinetic
- All Kinetic how-to guides
- Pulsify setup guides
Sources
Last checked 2026-10-19. Confidence: partial.
- www.mayantechs.com/post/mastering-gl-and-subledger-reconciliation-in-epicor-kinetic
- www.epiusers.help/t/117883
Also confirmed by
Common questions
Why does a paid invoice still show?
A future-dated payment leaves the invoice showing as unpaid on a report run as of today.
Is there a dashboard version?
Yes. A system BAQ called zHomepage_APAgedPayables covers aged payables on dashboards.
Should I compare it to the ledger?
Yes. Compare the AP Aging Report result to the GL AP balance.
Does Pulsify run this report?
No. Run it in your accounting system.
Want this done for you?
Book a call to see how Pulsify handles supplier bills in Kinetic.