News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Add the date of vendor...

Microsoft Dynamics SL (Archived)

Add the date of vendor's last payment to an aging report

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

When we run an AP Aging report in order to decide what vendors to pay in a certain week, we'd like to see when those vendors were most recently paid on that report. This can be a factor in the payment decision-making process. (X got a check last week, Y didn't get a check last week; if both vendors have an open invoice this week but we can only pay one, we'd like to pay Y, the one who didn't get one last week.) What field name(s) should be added to an aging report that would show this detail?

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (1)

Marisol Caamaño 90 on at

Like (0)

Report

RE: Add the date of vendor's last payment to an aging report

I think there is field about last check's amount, but you can get this information from apdoc table.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Add the date of vendor's last payment to an aging report

Although I can't add this field myself to the report, this was still helpful. Now, is there a field that will show the amount of that last check?
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Add the date of vendor's last payment to an aging report

AP_Balances.LastChkDate

John Joyce

Senior Applications Consultant

JJoyce1215@gmail.com

(781) 704-7515

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans