An aged payables report lists what you owe each supplier, grouped by how overdue each bill is. What is accounts payable?
Before you start
- Reports authorisation
The SAP B1 way
Where to find it: Vendor Liabilities Aging report
- Open Financials > Financial Reports > Accounting > Aging > Vendor Liabilities Aging. It is also under Business Partners > Business Partner Reports > Aging, or in the Reports module.
- In Group By choose vendor or buyer. Set the vendor code range and a Vendor Group or Properties. Pick Control Accounts if needed.
- Set the Aging Date. It defaults to today. Change it to look at liabilities due next week, for example.
- Set the Interval. Choose Days, Months or Periods. With Days there are up to four fields (defaults 30, 60, 90 and 120). You must fill the first.
- Tick Display Vendors with Zero Balance, Display Reconciled Transactions or Ignore Future Remit as you need, then run.
- On the report choose Age By: due date, posting date or document date. Export.
Limits in SAP B1
- Documents with an installment show one row for each installment.
Good to know in SAP B1
- Example from the help: intervals of 20 and 50 days give up to 20 days old, 21 to 50 days old and 51 days or older.
- Future Remit shows open liabilities where the aging date has not yet reached the Age By date. A $100 bill due 1 May with an aging date of 28 April sits in Future Remit.
- Number of Days Outstanding is the gap between the due date and the aging date.
- Translate Leading Currency at Aging Date converts foreign currency documents at the rate on the aging date and not the rate posted.
Words SAP B1 uses
- Business partner. The master record for a vendor or customer.
Common mistakes
- Leaving the Aging Date on today when you want a month-end view.
- Running it for a vendor range that leaves out some vendors.
More help
- How to run the Aged Accounts Payable report in Business Central
- How to run the AP Aging report in MYOB Acumatica
- How to run the supplier ageing report in Sage 200
- How to apply a credit memo to a vendor invoice in SAP B1
- How to close the month in accounts payable in SAP B1
- All SAP B1 how-to guides
- Pulsify setup guides
Sources
Last checked 2026-10-19. Confidence: confirmed.
Common questions
What is the ageing report called?
Vendor Liabilities Aging. An earlier name in older notes was Vendor Ageing, but SAP help uses Vendor Liabilities Aging.
Can I change the age buckets?
Yes. Set the Aging Date and the Interval in days, months or periods. The defaults are 30, 60, 90 and 120 days.
Can I run it for one vendor group?
Yes. You can group by vendor or buyer and pick a vendor range or vendor group, then export the report.
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 SAP B1.