Misplaced Pages

Microsoft Dynamics GP

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.

This is an old revision of this page, as edited by Noypi380 (talk | contribs) at 06:38, 18 September 2005. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Revision as of 06:38, 18 September 2005 by Noypi380 (talk | contribs)(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)

Microsoft Dynamics GP is a mid-market business accounting software package that runs on top of a SQL database server. It is a part of Microsoft Dynamics.

The product was originally made by Great Plains, an independent company that produced this software for years. In late 2000, Microsoft announced the purchase of the Great Plains company.

Previous versions (7.5 and prior) could be used with the following database managers: Microsoft SQL Server, Pervasive SQL (Btrieve), or CTREE.

The current version is 8.0. Version 8.0 requires Microsoft SQL Server.

Macros

Great Plains has the ability to record and play back macros that automate data entry. These macros run under the Dexterity Runtime engine. The macros are contained in .mac files that can be created using the built-in macro recorder or through an Excel spreadsheet. Some sample macro code designed to maximize a window might look like this: 

CheckActiveWin dictionary 'default'  form 'GL_Transaction_Entry' window 'GL_Transaction_Entry'
WindowMove dictionary 'default'  form 'GL_Transaction_Entry' window 'GL_Transaction_Entry' pointh 0 pointv 0
WindowSize dictionary 'default'  form 'GL_Transaction_Entry' window 'GL_Transaction_Entry' pointh 884 pointv 697

Some sample Visual Basic code to generate this macro from Microsoft Excel might look like this: 

MyMacroFile="C:\Macros\Maximize.mac"
Set a = fs.CreateTextFile(MyMacroFile, True)
a.writeline ("CheckActiveWin dictionary 'default'  form 'GL_Transaction_Entry' window 'GL_Transaction_Entry'")
a.writeline ("WindowMove dictionary 'default'  form 'GL_Transaction_Entry' window 'GL_Transaction_Entry' pointh 0 pointv 0")
a.writeline ("WindowSize dictionary 'default'  form 'GL_Transaction_Entry' window 'GL_Transaction_Entry' pointh 884 pointv 697")
a.Close

More advanced macros could be used to enter large amounts of data into Great Plains from a Microsoft Excel spreadsheet, saving the user a great deal of time.

External links

Category: