Solved

Automating some functions in Great Plains

Posted on 2006-06-27
5
392 Views
Last Modified: 2008-03-06
i am wondering if it is possible to automate (run nightly) the process that i do about once a week now. I go to the following menu options within Great Plains and run reconcile.

Tools>Utilities>Sales>Reconcile-Remove Sales Documents>Reconcile Sales Documents

Tools>Utilities>Purchasing>Reconcile Purchasing Documents>Reconcile and Print Report

Tools>Utilities>Inventory>Reconcile

i typically have to run a couple of exe files prior to being able to run the reconcile (clearbatchactivity.exe and  clearinactivedexlocksession.exe).

is there anyway to automate this process, to run nightly? we use GP 8.0 and SQL 2000.
0
Comment
Question by:sammaell
5 Comments
 
LVL 8

Accepted Solution

by:
RWJDCom earned 250 total points
ID: 17007353
There are several different macro programs out there that you can use to record what you do on the computer and create a script that you can run with a click of a button.  There is also another program you can use that's pretty good too it can be found at http://www.tethyssolutions.com/product.htm.

I hope this helps.
0
 
LVL 3

Assisted Solution

by:DennisL
DennisL earned 250 total points
ID: 17011911
Look into Process Server for Great Plains, that should have what you're looking for.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Let’s list some of the technologies that enable smooth teleworking. 
The viewer will learn how to set up a document for the web and print and the recommended PPI for printing.
This video shows how use content aware, what it’s used for, and when to use it over other tools.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now