[Rodopi] No 'On Hold Late' on weekends

[Cary Fitch]

I don't do this type of programming.  BUT, from other experience, I assume it will block the SAT/Sun effects but,   Will it then actually do the suspend on Monday?   Also you may have to Block FRI/SAT not SAT/SUN because the proceedure runs at midnight,not "in the day" and it may need to be defeated then.   $0.02   Of course the proof of the pudding is in the eating!   Cary Fitch   ----- Original Message ----- From: Scott Collins To: [EMAIL PROTECTED] Sent: Thursday, June 03, 2004 1:49 PM Subject: [Rodopi] No 'On Hold Late' on weekends We use Rodopi 5.2 sp3 and I have been passed the request to NOT put customers on hold for late payment on the weekends when our accounting staff is not available.  I believe I have found the stored procedure that puts the accounts on hold but I wanted to check with some of you Rodopi and SQL gurus to be sure I'm looking in the right place, as well as make sure this should work and not cause any additional problems.  Below are the first dozen or so lines of the SP along with my simple edit.  If I am correct, this should prevent the procedure from running on Saturday and Sunday and if I am reading the procedure correctly, any users who would have went on hold over the weekend will be found and put on hold when the procedure runs on Monday.  Anyone see any errors in my thinking? CREATE Procedure Maint_OnHoldLateSuspend         @CustomerID int = NULL,         @Proc int = 0 output As set nocount on if datename(dw, getdate()) IN ('Saturday', 'Sunday')         return 0 select @Proc= 0 declare @DateLateSuspCC smalldatetime,                 @DateLateSuspCheck smalldatetime,                 @DateLateSuspACH smalldatetime,                 @DateLateSuspCorpCheck smalldatetime,                 @BillingDate smalldatetime