1,240
Hi All,
Is it possiable to enable the Overdue letters to be scheduled to run and print overnight to speed up the process?
Currently the queries are run out of collection main window – Query. it takes too long to run during business hours and also slows the system down.
Thanks.
*This post is locked for comments
Hi Callen,
Thanks for your reply, it is really helpful.
But I still have some problems while implementing this to our system.
We have 6 letters need to be run once a month, and they need to be done within 1-2 days.
I dont know how i can schedule them to run during the night all in one go. Because once GP starts to run letter2, the data for letter1 will be deleted from the table. (am i right?)
I also tried to export the letter1 data by using PDF creator before i ran letter 2. But instead of exporting the whole lot in one go, GP printed the letters based on customer numbers. For example i have 200 customers in letter1. It will generate 200 PDF files and i have to manually rename the file and click export one by one... (I end up with killing my GP session to get out of it)
Another possible solution i can think of is reducing the number of letters we need to run. The reason we have 6 letters is because we can not find a way to make the query accept multiple customer class IDs. In "Collection Management Build Query" window, it allows me to enter a range for the customer class ID. But what we need is to be able to exempt some customer class IDs from being selected.
Any comment will be greatly appreciated
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (