I would like to somehow schedule a job to perform the aging process in receivables each morning, so that when anyone looks at the customer's balance and aging buckets, the last aging date is always current. I have found a stored procedure called rmagecustomer, which I'm hoping I can copy and manipulate in order to create a sql job to execute it.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Auto-Age Customers
- Thread starter Luvsql
- Start date
luvsql,
Did you get this figured out? This would be a good thing for many of my clients. If you got it figured out, it would be great if you could share. Otherwise, it seems like something I should do. I can't believe they didn't force me to do this sooner!
Did you get this figured out? This would be a good thing for many of my clients. If you got it figured out, it would be great if you could share. Otherwise, it seems like something I should do. I can't believe they didn't force me to do this sooner!
Dukester0122
IS-IT--Management
Probably better if you could share it to the group. Tks.
- Status
Similar threads
- Locked
- Question
- Locked
- Question