Actually, you can get it to work the way it has in the past. Enable Print Vendors with Zero Balance to get the results expected. I think a recent update changed the report.
I just spent hours trying to figure out why a customer's Aged Payables Report did not tie to the GL for the first time this year. She never ran it with Print Vendors with Zero Balance but this is the only way we can get the consistent and correct results as in the past. The report is now significantly longer but correct.
We found is that unless you select to Print Vendors with Zero Balance, the report excludes open entries as of our report date when the vendor balance is zero today. It appears to now use the system date to determine a vendor’s zero balance and whether that vendor should be included on the report, not the Aged as of date selected.
Without Print Vendors with Zero Balance
With Print Vendors with Zero Balance
I don’t know when this changed however, in Version: US Business Central 17.1 (Platform 17.0.18204.19326 + Application 17.1.18256.18732) the Aged Accounts Payable report will not include open entries as of the reporting date if the current vendor balance is zero unless you select to Print Vendors with Zero Balance.
The Vendor - Balance at Date does not have this issue and is an alternative depending on what information you need in your report.
