RachelW
4Penny.net
Points: 7053

3/6/2020 2:43:33 PM

Inactivate customers that have not been invoiced in xx days

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu
I got a request today to inactivate customers that have not been billed in x days. The code is below
4Penny.net
Version: All
Section: 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