Running AR Aging from SQL

Running A/R aging can take a while. In previous tips we’ve seen that cleaning up paid transactions via Paid Transaction Removal can help speed this up . Well, this week we look at how to run A/R aging from SQL, skipping the interface all together.
Running this script in SQL server will perform an A/R aging through the current date. Changing the @I_dAgingDate variable changes the date the aging runs through.
SET NOCOUNT ON
DECLARE @O_iErrorState int, @I_dAgingDate datetime
SELECT @I_dAgingDate = convert(varchar(10), GetDate(), 102)
EXEC dbo.rmAgeCustomer 0, '', 'þþþþþþþþþþþþþþþ', @I_dAgingDate, 127, 0, 0, '', @O_iErrorState OUT
--SELECT @O_iErrorState
SET NOCOUNT OFF

Group Project

I apologize for not being on the call tonight. I am getting married this week and I honestly did not have time to do a conference call. I thought I might have been able to squeeze it in, but I just could not. I am also out for Friday, because it is the day of my rehearsal and dinner. I can handle the site content or the survey. I am ok with either. But please give me a part of the project that can be completed after next week, because I will be out of the country next week, but I am flexible with what you deligate as my part. I will get whatever you need me to do done in a timely manner when I return. Thanks! John

Communications - 8/2

We had our second meeting and I think we are forming nicely. Greg has stepped up to project manager (Blog entry 8/1). Greg I will gladly step up to the task in your absence.

Meeting minutes

• General consensus of the group was the uncertainty of project deliverables prior to project due date. In addition, the final project due date could not be determined unaminously. I posted a request from Professor Kanabar concerning these items.
• Raynette will begin a project file, level 1 plan so that we can pass it around for a WBS.
• Martin and Jacob have volunteered to do the programming
• I will set up a FTP site for file storage/repository of our group files

Thanks.

Jim R

I volunteer to be the Project Manager

Hello everyone,
I do not have much experience creating website so I volunteer to be the project manager. I will do up document templates and put them on the blog site tomorrow.

Thanks,
Greg

Communications

Teleconference Minutes:

• Create a blogspot for the group - all of group can author here.
• Begin a repository for the individual scope documents. It was initially suggested for the blog but a general location for file swapping is preferred.
• Coordinate the next meeting tentative for 8:00 PM Thursday August 2, 2007