Jude
4Penny.net
Points: 7384

8/30/2017 1:27:58 PM

Apply all available RM documents

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

Warning - this is a very powerful and dangerous script

AND IT IS UNTESTED IN A LIVE ENVIRONMENT

I'm just posting it here as a shell for future use. 

USE AT YOUR OWN RISK. 

BACKUP YOUR DATA. 

That being said, this script is designed to look at all the unapplied payments in your environment and insert apply records. 

There are three scripts. The first backs up RM20101. The second restores it. The third is the script that does the work. 

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