Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to Determine Wheth...

How to Determine Whether AP Invoices Are Being Paid on Time

(0) Share

Report

Posted on by Community Member Microsoft Employee

My client recently sent me this:

Is there an easy report/smart list I can run to see if our invoices have been paid on time (within the payment terms)? I have experimented with some smart lists but none are really providing me with this.

This seems like an easy request, but it is difficult to answer. I think the problem is there is no field that says when a given invoice was paid. Instead you would have to look at the date of the documents applied to a given invoice. The issue there is you lose the one-to-one relationship since multiple credit documents could be applied to a single invoice.

Any creative thoughts??

*This post is locked for comments

All responses (1)

Answers (0)

Victoria Yudin 22,766 on at

Like (0)

Report

Re: How to Determine Whether AP Invoices Are Being Paid on Time

Lyndy,

I don't think there is any out-of-the-box report or SmartList that will help with this. If your client is open to a custom report or already has SLB, you could use this view to create a report for them: victoriayudin.com/.../sql-view-ap-apply-in-gp.

You are right about multiple payments (and don't forget about credits and returns) applied to the same invoice - if all they want is an invoice date and a date it was fully applied, you could use my view as a start, but alter it to only show the last payment/credit/return and only if the original invoice is now fully applied.