An aged payables report lists what you owe each supplier, grouped by how overdue each bill is. What is accounts payable?
The IFS Cloud way
Where to find it: Order Report > MC Supplier Ledger Detailed Age Analysis
- Run MC Supplier Ledger Detailed Age Analysis from the order report to list open supplier invoices
- Supplier Open Balance History gives open balances at a past date
- The report comes out as a PDF. To get it into Excel, add the report query as a Quick Report. IFS Cloud has limited support for Excel report layouts.
- For an audit list at a chosen date, the Supplier Ledger Open Items and Supplier Ledger Analysis reports give the balance at the end of a period or day.
- To use Supplier Open Balance History, create a category first, then add the balance date by hand. IFS generates the open balances for that date, and you can export the result to Excel.
- Another way to get a file for your auditor is the Audit Interface. Set it up for your country with the report type gdpdu, then use the Assistant to export the data with the data source CUST_AGE_ANALYSIS_AV and an output path.
Limits in IFS Cloud
- The MC in the report name means multicompany. An audit is normally for a single company, so check the report before you send it. If you have only one company in the installation, it is not an issue.
- A list built by hand is a point in time snapshot. It does not follow late postings, such as invoices booked into the old year after the new one has opened. The standard open items reports do.
- Supplier Open Balance History may not use exactly the same method as the Supplier Ledger Open Items report. Compare the two before you rely on it.
Common mistakes
- Running it without checking the date.
- Ignoring unallocated credits.
- Not tying it to the ledger.
- Leaving bills in draft.
More help
- How to run the Vendor aging report in Dynamics 365 Finance
- How to run the AP Aging Report in Kinetic
- How to run the A/P Aging Report in CloudSuite Industrial
- How to apply a credit note to a supplier invoice in IFS Cloud
- How to close the month in accounts payable in IFS Cloud
- All IFS Cloud how-to guides
- Pulsify setup guides
Sources
Last checked 2026-10-19. Confidence: partial.
Also confirmed by
Common questions
Which IFS Cloud report lists open supplier invoices by age?
MC Supplier Ledger Detailed Age Analysis, run from the order report. It lists the open transactions for all suppliers.
How do I get the aged payables list into Excel?
The report is a PDF. Add the report query as a Quick Report, or use Supplier Open Balance History, which exports to Excel.
How do I see what was owed at the end of last month?
Use Supplier Open Balance History with that balance date, or the Supplier Ledger Open Items or Supplier Ledger Analysis report for the end of a chosen period.
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 IFS Cloud.