The ability to get GP to run a check links and reconcile automatically via a schedule would transform the admin of larger sites.
I would love to reconcile our SOP and POP each night and IV over weekends, automatically and have the resulting reports written to a directory for me to review. Even if it meant passing params to GP application via windows scheduler or having another application to run on the server. Alternatively hooks into these processes for GP Addin would help.
This is a hidden pain of GP admin currently.
This also relates but not depends on another suggestion, of moving the reconcile and check links into SQL for easier management.
Comments
Though this has been implemented into the Fall 2020 release of GP, it was done in the most awkward way.. not allowing for selection of the actual time it should run...
I say awkward because usually at those times (midnight) you run other SQL maintenance, like backups, DBCC checks and other routine tasks.
Also, it should have been implemented by using SQL Store Procs, like other suggested, to be able to schedule it thru a SQL Agent job, and not need to keep a GP client up & running to perform this task.
Category: System
Congratulations Tim this has been implemented!!!!!!
Category: System
If these can be moved to SQL Server stored procedures and implemented as set based operations, we could then schedule them via a SQL Server job. The results could be placed in a table and picked up by users via the Dex interface. I would prefer to see all these changes implemented as part of a "Microsoft Dynamics GP Diagnostic Utilities" type product.
Category: System
There are a ton of GP customers who would love to schedule the Inventory Reconcile
Category: System
Same as https://experience.dynamics.com/ideas/idea/?ideaid=1da33132-a427-e811-bbd3-0003ff68b9cf
Category: System
Administrator on 4/5/2021 1:35:06 PM