DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In
Leah 2/28/2018 10:18:24 AM

View that shows number of invoices paid per month and if they were paid late

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

A user on the GPUG forum just asked "I'm trying to create a SmartList that shows number of invoices paid per month and if they were paid late"

Please note that there is a difference between the day the payment is received, and the date of the apply. In this view, I'm using the date that the payment was received.

That sounded like a good blog, so here it is...

Version: All
Section: Dynamics GP,SQL Scripts