You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
You may have maintenance or reporting macros that you want to run when you're not logged in. I'm working on a set of prebuild maintenance macros for registered users to be available in the near future. As promised in the Macros weekly feature, to schedule a macro to run:
To fire this macro off you need 3 pieces. The dynamics.exe location, dynamics.set location and the macro location. The line to run your macro from a windows shortcut looks something like this:
"C:\Program Files\Microsoft Dynamics\GP\Dynamics.exe" "C:\Program Files\Microsoft Dynamics\GP\Dynamics.set" "C:\users\mpolino\Desktop\login.mac"
Quotes are required. Create a shortcut with these locations and use the windows scheduler to fire off the shortcut. After that your macros will run as scheduled. Any error dialogs are logged in the macro.log file. Now you can run those maintenance macros while you are at the beach!
Originally Posted by Mark 11/18/2005 01:03:00 PM
We covered basic macro information over the last two weeks. This week we've got some advanced features.
1) Move macros from version to version.
Sometimes recorded macros won't run after an upgrade or a service pack. Open the macro file (.mac) in notepad and remove the top line. It will look something like this: # DEXVERSION=DEX 8.00m076 2 2 and indicates the version the macro was recorded in. Since many GP updates add features, rather than changing features this usually works fine.
2) Split up macros.
This was covered in last weeks Weekly Review
3) Allow access to limited areas.
This was more important in past versions but if a user needs to perform a single function behind the system password, you can create a macro that incorporates the password and allows them to perform the funtion. Other items behind the system password are normally not accessible because the password would be required again and the macro has hidden it from the user. BEWARE though, this puts the system password in an unencrypted text (.mac) file so you'll want to limit access to the macro file and track system activity. Also, if you change the system password, you break the macro.
4) Edit a macro by hand.
You can edit the macro (.mac) file with notepad. So if you have a long macro and you need to make a simple change (like a name or system password ;)) you can edit the file. I asked MBS support and developer types if there is a document outlining how the macro language works but I've been repeated told that nothing like that exists.
5) Step through the macro.
You can use the STEP (shift-f8) option to step through your macro one command at a time if you are having problems.
6) Macrotize your reports.
Report Scheduler and Report Groups are great but sometimes you need odd report settings (like yesterday). Remember that you can use macros to setup the report, let you enter the date and then finish printing.
7) Macrotize your maintenance.
Checklinks and Reconcile can both be run with macros. You can review the macro help file to even see how to autoschedule a macro. I'll probably cover it as well on a later post.
Originally Posted by Mark 11/09/2005 09:04:00 AM
