Pages

Sunday, November 10, 2013

How to Record Macro in MS Dynamics GP

Hi friends hopefully you all will be fine. These days I am receiving many queries regarding Macros in Dynamics GP, many of the users perform routine repetitive tasks in dynamics GP. Macro is a very useful functionality to perform routine repetitive tasks in Dynamics GP (all versions). Let us have a look on how you can record macro for any window in MS Dynamics GP.
For simplicity to learn as starting point, I am using vendor maintenance window.

Following are some simple steps to record macro to create, maintain or update vendors in Dynamics GP;
·         Go to 
                purchase series>>>>cards>>>>vendors
o   On vendor maintenance window you will find “Macro” in “Tools” menu
o   In order to play any macro first you have to record it so click on Record or otherwise you many also open window using short keys (Alt+F8)
§  Give path to save macro file and save it on any easy accessible location on your system.
1.       Using Tab key go to the respective fields on vendor maintenance window i.e.
a.       for creating vendor go to Vendor ID field and type Vendor ID
b.       using tab move to vendor name field and type vendor name
c.       Using tab move to address ID and type address ID
d.      Using Mouse go to vendor class and type class name, it is assumed that you are using vendor classes.
2.       After completing data entry click save to save updated records and return to Tools menu from where we started recording macro, to stop recording.
3.       Following is final shape of Macro recorded for creating vendors in sample company (Fabrikam); (Note that, you can use Notepad to open your recorded macro file)

Tuesday, November 5, 2013

GP unable to connect with database engine

it can occur if the you rename SQL instance name, provided while installing Dynamics GP, if it is the case follow these line.

for windows Server 2008R2

windows folder>>>sysWOW64>>>odbcad32.exe>>>system DSN

double click Dynamics GP and provide sql server name you want to connect and press next until you finished the wizard. 

Restart GP and enjoy :)