Gps On Sale
Gps On Sale

Exporting Data from Dynamics GP Notes for Consultant

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), 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, 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, 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, 5.0, 4.0 or Microsoft Dynamics GP 7.5, 8.0, 9.0, 10.0 or 11.0, you can export via SQL Server direct Select statements, see #2.  If you are on Pervasive SQL 2000 or Ctree (7.5, 7.0, 6.0, 5.5, 5.0, 4.0, 3.2 and earlier), we recommend you to consider deploying connection via ODBC (Pervasive or Ctree drivers are usually available from CD #2 of your respected version of Great Plains Dynamics).  Very good option is Microsoft Access, where you use ODBC connection in linked tables

5. Data Export from Great Plains Accounting for DOS, Windows or Macintosh.  There are two methods: report export to the file (feel free to call us for GPA reports discovery and printing help), or via ODBC driver (this method is typically more complex, as you need to have original GPA diskettes to generate DDF file, required for ODBC driver).  We saw customers, who are converting from Great Plains Accounting to SAP Business One recently

6. Data Export from all Great Plains (including GPA) service announcement.  If you are walking away from Microsoft Dynamics GP, Great Plains Dynamics/eEnteprise or Great Plains Accounting, we are happy to extract all desirable data from GP to Excel, MS Access, coma or tab delimited text files.  We are also experienced in EDI data export from Dynamics GP

7. Data Import to SAP Business One.  If you are migrating from Great Plains to SB1, we are offering SAP B1 Data Transfer Workbench data preparation and integration setup service, including advanced ODBC migration (from text files, directly from Oracle, or MS SQL Server or cross platform ODBC queries)

8. Data Import to Microsoft Dynamics GP, Great Plains Dynamics or Microsoft Great Plains.  We offer Great Plains Integration Manager setup,. user training, including Advanced ODBC data import service, where migrate in cross platform scenarios (Oracle, text file, MS SQL, MS Access, MS Excel, etc.), we are also offering ecommerce data import to Microsoft Dynamics GP in quasi real time (GP Integration Manager) or real time (eConnect ecommerce integration programming, Alba Spectrum Order Connector to Sales Order Processing Invoices or Sales Orders)

9. Custom Ongoing Dynamics GP Data Import/Export Programming in Great Plains Dexterity.  If you need really flexible and advanced custom Great Plains data import or export add-on, feel free to call us to discuss Dynamics GP Dexterity Software Development options.  Of company is Microsoft Dynamics GP Source Code Partner (we have access to Dexterity Source code, which allows us to see how original GP business logic is coded in Dynamics.dic Dexterity Sanscript codes)

Gps On Sale For Sale

eBay Logo  

ON SALE Android 6.0 7


ON SALE Android 6.0 7″ 2DIN Touchscreen Car Radio DVD Stereo GPS 3G WIFI CAM


$179.00


SAMSUNG GALAXY S III SGH-I747 - 16GB -Blue+  MINT+ UNLOCKED+ ON SALE !!!


SAMSUNG GALAXY S III SGH-I747 – 16GB -Blue+ MINT+ UNLOCKED+ ON SALE !!!


$69.95


[On sale]Car Universal 12/24V To 5V LED 2 USB Charger Adapter For Cell phone GPS


[On sale]Car Universal 12/24V To 5V LED 2 USB Charger Adapter For Cell phone GPS


$0.99


ON SALE~Apple iPhone 5 32GB Factory Unlocked Excellent Cosmetic Smartphone White


ON SALE~Apple iPhone 5 32GB Factory Unlocked Excellent Cosmetic Smartphone White


$79.99


1 GM GPS NAV DISC # 20940248 6.0c 2011 update ON SALE 2008-2010 Hummer H2


1 GM GPS NAV DISC # 20940248 6.0c 2011 update ON SALE 2008-2010 Hummer H2


$88.88


SHARP SH-M02-EVA20 EVANGELION Limited Edition Unlocked Brand NEW Now on Sale !!


SHARP SH-M02-EVA20 EVANGELION Limited Edition Unlocked Brand NEW Now on Sale !!


$470.00


Polar FT60G1 GPS Old Stock Brand New excellent condition on sale


Polar FT60G1 GPS Old Stock Brand New excellent condition on sale


$179.00


On Sale Car Nylon Interior panel Audio Stereo GPS Molding Removal Tools Peugeot


On Sale Car Nylon Interior panel Audio Stereo GPS Molding Removal Tools Peugeot


$4.69


ON SALE 8'' 2Din In Dash Touch Car Stereo GPS DVD Player Radio  for Toyota Camry


ON SALE 8” 2Din In Dash Touch Car Stereo GPS DVD Player Radio for Toyota Camry


$124.60


7 inch HD Touch Screen CAR TRUCK 4GB GPS Navigation Navigator SAT NAV On Sale


7 inch HD Touch Screen CAR TRUCK 4GB GPS Navigation Navigator SAT NAV On Sale


$47.99
































Magnetic Mount, WizGear [2 PACK] Universal Air Vent Magnetic Car Mount Phone Holder, for Cell Phones and Mini Tablets with Fast Swift-Snap Technology, - With 4 Metal Plates


Magnetic Mount, WizGear [2 PACK] Universal Air Vent Magnetic Car Mount Phone Holder, for Cell Phones and Mini Tablets with Fast Swift-Snap Technology, – With 4 Metal Plates


$8.99


WizGear Universal Air Vent Magnetic Car Mount Holder Black Setting your phone on a mount in your car has never been easier! WizGear Air Vent Car Mount for smartphones saves you the hassle of placing your smartphone securely to make sure it doesn’t fall just push it in the air vent! The WizGear Air Vent Mount features a magnetic technology, which means your smartphone will be secure and have no ch…

Garmin vívoactive HR GPS Smart Watch, Regular fit - Black


Garmin vívoactive HR GPS Smart Watch, Regular fit – Black


$188.48


Run, bike, swim, golf, ski and more with vivo active HR, the GPS smartwatch with Elevate wrist heart rate technology. Outside of your more active moments, its built-in activity tracker counts steps throughout the day and measures calories burned. The sunlight-readable, high-resolution touchscreen features smart notifications such as call, text, email, social media alerts and more. Customize your w…

Fitbit Blaze Smart Fitness Watch, Black, Silver, Small (US Version)


Fitbit Blaze Smart Fitness Watch, Black, Silver, Small (US Version)


$149.95


Get fit in style with Fitbit Blaze—a smart fitness watch that helps you maximize every workout and every day. With advanced technology in a versatile design, this revolutionary device is built to track your workouts, monitor your performance stats, and gauge your progress. PurePulse continuous heart rate and multi-sport modes enhance every exercise, while next-generation features like Connected …

Garmin vívoactive Black


Garmin vívoactive Black


$114.99


GPS Smartwatch for the Active Lifestyle Ultra-thin GPS smartwatch with a sunlight-readable, high-resolution color touchscreen Built-in sports apps, including GPS-enabled running, biking and golfing plus swimming and activity tracking, let you view your stats even when away from your phone Pairs with your smartphone to gently vibrate and display alerts for incoming calls, texts, emails and cale…

Polar M400 GPS Smart Sports Watch


Polar M400 GPS Smart Sports Watch



Developed for runners who want a comfortable and durable running watch with sporty design and advanced GPS and training features. Track and record running as well as your other exercise, and monitor your performance accurately. Connect with the Polar Flow mobile app and stay active and motivated….

Tagged with:

Filed under: GPS Navigation Systems

Like this post? Subscribe to my RSS feed and get loads more!