Skip to main content

From the Microsoft Dynamics GP Blogs: AR aging routine; GP utilities; Start or stop SQL; Collections management

by MSDW Reporter
Editorial Team,
August 31 2018

This week on the Dynamics GP blog roundup:

  • Jo's did you know: You can set your AR aging routine to run automatically in all GP databases
  • GP utilities user permissions
  • Start/stop SQL by batch file
  • Known issue with collections management and customer combiner

Jo's did you know: You can set your AR aging routine to run automatically in all GP databases

On her blog, Jo deRuiter stated that sometimes clients tell her that they want to set up automatic functionalities in databases. At times this requires coding or macros.  But there's one routine that's easier to do than that, according to deRuiter.

She stated that some of these "routines" can be set to run as maintenance plans at the end of the day so that reports are always accurate. One of her favorite routines to set up is a routine to run the AR aging process automatically.  

You can find the instructions to set this routine up here.

GP utilities user permissions

On her Tips, Tricks & Thoughts on Microsoft Dynamics GP from a Canadian Perspective blog, Jen Kuntz wrote about what permissions are required for GP utilities.

Kuntz stated that if you're going through any service pack install or upgrade, you might have to update a lot of workstations. Kuntz stated that when her company upgraded its Dynamics GP recently, everyone was needed to help with installs, including some IT team members who didn’t have any GP access.

Here's how you do it and what permissions are required:

<... class="become-member ms-auto me-auto">

FREE Membership Required to View Full Content:

Joining gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About MSDW Reporter
More about MSDW Reporter