Dein erstes Forum » Electronic Data Interchange we recom

Exporting Data from Dynamics GP Notes for Consultant Computers Articles | January 4 Wholesale Mathieu Perreault Jersey , 2010
There might be situations, where you need to extract info from Microsoft Dynamics GP (formerly known as Great Plains Dynamics or Microsoft Great Plains) table. ?In this small publication we will describe you two scenarios.

First, when you need one tame data export for following data conversion into future Corporate ERP accounting system (when you are walking away from Dynamics GP to something like SAP Business One, Oracle eBusiness Suite, etc.), and second - when you need ongoing data export for feeding data into something like industry compliance or reporting systems (including simple EDI):
1. Dynamics GP custom report in Report Writer. ?Here, we assume that you need one-time export. ?This method doesn't require from you to be programmer. ?Simply open ReportWriter (Microsoft Dynamics GP -> Tools -> Customize -> Report Writer) Wholesale Kyle Connor Jersey , then click on Reports tab and New. ?Now, let's assume that you need to export all your customers: give report My Customers name, Series - Sales, pick main table RM Customer MSTR. ?Now, click on Layout to open Layout place desired fields Customer Master table on the layout: likely in the report body section (likely Customer ID and Customer Name to be required). ?Then, click Microsoft Dynamics menu and save report. ?Now, in Dynamics GP interface Wholesale Mark Scheifele Jersey , Report -> Customized, select product Microsoft Dynamics GP, series Sales, and your report should be seen now available for selection. ?You can print report to the file and then import text file into Excel
2. Exporting data directly from MS SQL Server Dynamics GP tables. ?If you are comfortable to do direct SQL Select statements (and maybe linking several tables in one records pulling), please review GP tables structure: Microsoft Dynamics GP -> Tools -> Resource Description -> Tables. ?This method is useful in both scenarios (when you walk away from Great Plains Dynamics GP or when you need ongoing data export). ?Couple of comments here, as we know that programmers are very brave in their methods and may decide to alter Great Plains tables. ?Please, do now alter Microsoft Dynamics GP tables Wholesale Josh Morrissey Jersey , as their metadata is also stored in Dynamics.dic and other dictionaries (to be available for Great Plains Dexterity programmed GP user workstation business logic)
3. EDI data export from Dynamics GP. ?For the purposes of Electronic Data Interchange we recommend you consider formatted SQL Select statement (where you imitate EDI typically fixed length header, body and trailer)
4. Data export from old versions of Great Plains. ?First of all - Customized Report method should work for all versions of Great Plains, Dynamics GP and Microsoft Great Plains, see #1. ?If you are on Great Plains Dynamics on Microsoft SQL Server: 7.5, 7.0, 6.0, 5.5 Wholesale Connor Hellebuyck Jersey , 5.0, 4.0 or Microsoft Dynamics GP