Dynamics,Integration,Consultan computer Dynamics GP Integration Consultant Newsflash: Great Plains M
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
This small publication is not intended to be technicalinstructions, it is rather highlights: 1. If integration Manager doesnt have destinationconnector. If you are trying to importlarge amount of data to such add-ons as Analytical Accounting, GrantManagement, Invoicing, and even some objects in GP Project Accounting, chancesare high that Integration Manager doesnt help you, as it doesnt havedestination connectors for these Dynamics GP modules 2. Customized Dynamics GP screens. If you have third party Great Plains Add-ons,where such popular screens as Sales Transaction Entry, Purchase Order Entry,Payable Management Transaction, Inventory Transfer windows are altered in GreatPlains Dexterity realm then Integration Manager could still be deployed,however you should add VBA scripts on such events as Before Integration, BeforeDocument Commit, etc. These VBA scriptsshould open old-fashioned ADO connection to custom Add-On tables and matchregular GP business records with required custom tables counterparts. If you are not ardent VBA programmer and ifyou are not really familiar with Great Plains customization architecture,probably this method doesnt make you to feel enthusiastic. This is why we would like to offer you a waymore simple method of Great Plains data feeding GP macros 3. Great Plains Macro recording. The idea is very simple you open the window,where you add new Great Plains object, such as Analytical Accounting DimensionCode and switch on Macro Recording. Eachwindow in GP 10.0 has tools menu. Openthe data feeding window and tools->Macro->Record. Then, dont switch windows and applications,simply make data entry for two objects and then tools->Macro->Stop. Now you are ready to data automationmiracle. Open macro file in text editor andopen new Excel worksheet. Copy macrobody lines into single Excel row, but multiple cells, and using series createthousand macro body lines by copying data from another Excel table into Excelform of macro lines. Then save macroback into text file. Now macro is readyto feed thousand of new records into customized Great Plains form 4. Macro power. Macro is capable to feed data into Great Plains without customizationrestriction. Feel free to practice macrodata integration in such complex Great Plains modules as Manufacturing, Bill ofMaterials, Non-profit extensions, to give you one of the most challengingexamples
Dynamics,Integration,Consultan