Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

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

Posted on by 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?

  • Marisol Caamaño Profile Picture
    Marisol Caamaño 90 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans