Share
ReportCan you use business alerts to run a utility like reconcile sales documents?
*This post is locked for comments
You’re offline. This is a read only version of the page.
350
Can you use business alerts to run a utility like reconcile sales documents?
*This post is locked for comments
Darn. I guess I cannot enable macro replay through the Set file?
I need to clarify...
The process I was specifically referring to was the batch file and/or Windows Scheduler option to launch Dynutils. Dynutils is a different animal though. Even you can record a macro in Dynutils (it's Dex application after all), macro replay has been disabled for the Dynutils application. This is, a macro will not execute when you use it as a parameter to Dynutils.
Mario, thank you for adding to this information. At this point I have been able to get a login macro to work if I am going into Dynamics GP but for some reason the Utilities macro will just not run. I think I have everything set properly, just like the bat file for the GP macro, except switching out the Dynamics files with Dynutils files, but the macro does not run. The Utilities screen opens but then nothing, and I am not even getting a log either. I am still checking to see if I misspelled something or have something out of place but everything looks accurate.
dynutils.exe dynutils.set DynamicsGPUtilitiesLaunch2.mac cd C:\Program Files (x86)\Microsoft Dynamics\GP2010\
I will keep pounding on it but if you have any other suggestions I would appreciate it. Thanks!
Michael Herring
The process should work to launch Dynutils. You should also be able to record a macro with the actions (including the login process) by launching Dynutils and pressing ALT+F8 on your keyboard at the login window to begin recording the actions you will perform with Dynutils.
The command line in your batch file should be DYNUTILS.EXE DYNUTILS.SET DYNUTILS.MAC assuming you name your macro dynutils.mac.
I've honestly never had a need to automate Dynamics Utilities so I haven't tried it. If it's possible though, it would be by using the dynutils.exe and dynutils.set.
Mike
Mike, thank you very much for your response. I have actually gone back and forth on a couple of versions of a bat file and still can't quite seem to get there. Do you know if this process should work to launch Dynamics GP Utilities, instead of GP? If so should I have the programs to be "Dynutils.exe Dynutils.set XXX.mac" or would I need to add anything else to get utilities to recognize the macro?
Thanks again!
Michael
Hi Michael,
You can't just associate the the macro file with the exe. You need to have the full command line that I included in the instructions below. In order to launch GP with a macro file, you need to have the *.exe, the *.set file, and the *.mac file all in the same command line.
Let me know if you still have trouble after you do this.
Thanks,
MIke
Mike, I am trying to use this process to log into Dynamics Utilities and have run into a couple of issues. When I followed these instructions the Macro file would error telling me that I needed to associate the file with a program in order to run it. Therefore I went into the file Properties and associated the macro with the Dynutils.exe file. Now Dynamics Utilities will open to the login screen however the macro still does not run. Am I missing another step here?
Thank you!
Michael
Ok. In order for this to work, you will need to use the task scheduler inside of Windows to have a batch file run at a particular time. I'm assuming you are already familiar with these two items. If you are not, you may need your IT team to assist you. You should also keep in mind that by following these steps, your GP password will be saved in plain text and will be visible to anyone who has access to the macro file on your machine.
- To begin start GP but do not login yet. On the login screen press Alt+F8. This will start the macro recorder. Choose a location for the macro file. The preferred location is C:\Program Files\Microsoft Dynamics\GP\
- Once you have saved this file, login to GP as you would normally. Select your company and then run the reconcile routine as you would like it to run when it is run automatically. Do not do anything else in GP.
- When the reconcile routine has finished, go to Microsoft Dynamics GP -> Exit.
DO NOT close GP by using the 'X'
- Find the macro file that you have created and open it using Notepad.
- Insert a line to read:
Logging file 'macro.log'
as the second line of your file (after the #DEXVERSION...)
- Save and exit Notepad.
- Now you need to create a batch file that has the command line:
"c:\program files\microsoft dynamics\gp\dynamics.exe" "c:\program files\microsoft dynamics\gp\dynamics\dynamics.set" "c:\program files\microsoft dynamics\gp\dynamics\mymacro.mac"
where mymacro.mac is the file name of your macro.
- Test the batch file to be sure it runs and works
- Schedule the batch file using Task Scheduler in windows.
I know it's a bit involved, but it should work. Let me know if you run into any hitches along the way.
Mike
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (