Leah
4Penny.net
Points: 7116

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...

4Penny.net
Version: All
Section: Dynamics GP,SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3