Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Dynamics GP Macro Commands
For those of you who build complex macros, Kevin Gross was kind enough to contribute a Macro…
Macros in GP
Macro Programming - Commands and Syntax
Mark has posted a document that explains the Macro commands that helps you understand and write your own macros,…
Hybrid - Running a macro to automatically close GP Example
The following VBA example shows how a macro file can be started from VBA. This particular example will close Microsoft Dynamics GP when the Check Links window closes. As macros wait for background processes to complete, the macro will not start until the Check Links…
Mark posted a method to record and auto-play macro file using windows tasks scheduler, checkout his post below:
Macros in Microsoft Dynamics GP v 10.0
Yesterday, I was asked why macros that seemed pretty straight forward and worked well in previous releases of Microsoft Dynamics GP, all in a sudden, seem not to work in Dynamics GP 10. Case in particular, a macro was previously written to automate the checklinks of the Sales Work table group and automatically close the application after completing the operation, but now seemed to hung when attempting to close.
After running a few tests, as I suspected, the reason Microsoft Dynamics GP is not quiting is 3-fold:
1) The Navigation Pane feature is an internal Dexterity window. When control is returned from the check links process, the focus is immediately returned to the navigation pane, not the work area form (BuiLtin form), causing the macro command to fail.
To fix this, the navigation pane needs to be disabled first when the macro begins its execution:
CommandExec dictionary 'default' form 'Command_System' command NavigationPane
2) Macros and Progress Windows are enemies. This…
Weekly Review: Macro Basics
A macro is a function that allows the automation of certain events in a program. In Great Plains, macros can be used to take out some of the annoying parts. For example, when we transfer money, we always transfer it one way, from Money Market to operating. Everything is the same but the dollar amount. So, I build a macro to fill in everything but the amount. Now I just run the macro, add an amount and I'm done.
Building a macro in GP is easy but…
Weekly Review: Schedule Your Macros
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:
- Start GP, don't log in.
- At the Welcome window hit ALT-F8 to start recording. Name the macro and save it to a location where you can find it.
- Log in as you normally would. (The macro will record your password. You may want a separate, maintenance only login for automatic macros)
- After you are…
Weekly Review: Advanced Macro Tips
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…
Weekly Review: Macro Pauses
When building a macro, you can pause to allow for user input with the Insert Pause button. The problem is that the user has to know to go to Tools->Macro->Continue after they input their information. This extremely non-intuitive.
A better option is to build multiple macros. Let each macro stop before…
Macros in GP
Amy Walsh detailed the complete steps for creating Macros with Mail Merge functionality, checkout his blog post…
On Vacation Last week
Sorry all, I was on vacation at the beach last week and only got 1 post in. However, being at the beach got me to thinking about how to save time!
Are you saving enough time? Do you use Smartlist, FRx, Quicklinks and Macros?
Macros have been around…