Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Auto Overdue Letters

Posted on by 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

  • GrapeFruit Profile Picture
    GrapeFruit 1,240 on at
    Re: Re: Auto Overdue Letters

    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

  • callen Profile Picture
    callen 4,595 on at
    Re: Auto Overdue Letters

    You could try using a macro to run the letters and schedule the macro to run at night using Windows Scheduler.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,064 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans