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  

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


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


$75.50


[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


Apple iPhone 5s New Other - 64GB 32GB 16GB AT&T Unlocked Smartphone ON Sale!


Apple iPhone 5s New Other – 64GB 32GB 16GB AT&T Unlocked Smartphone ON Sale!


$300.00


ON SALE ANDROID OS 9


ON SALE ANDROID OS 9″IN DASH MULTIMEDIA PLAYER GPS fit BMW E46 3 Series


$214.00


ON SALE Universal 2DIN Android 7.1 Car in Dash DVD Player Stereo GPS Camera


ON SALE Universal 2DIN Android 7.1 Car in Dash DVD Player Stereo GPS Camera


$219.50


ON SALE fit Toyota Camry 2007-2011 Car DVD Player GPS Navi Radio Stereo+CAMERA


ON SALE fit Toyota Camry 2007-2011 Car DVD Player GPS Navi Radio Stereo+CAMERA


$172.99


ON SALE Stereo Android 6.0 Car 7


ON SALE Stereo Android 6.0 Car 7″ GPS NO DVD Navigation WiFi 4Core Radio OBD2


$139.98


ON SALE Car Dash DVD GPS DVR Android 7.1 2GB RAM fit AUDI A4 S4 RS4 B7 B9


ON SALE Car Dash DVD GPS DVR Android 7.1 2GB RAM fit AUDI A4 S4 RS4 B7 B9


$275.00


ON SALE Cam+Android 7.1 2Din Car in Dash Radio GPS Stereo WiFi DTV/TPMS/OBD


ON SALE Cam+Android 7.1 2Din Car in Dash Radio GPS Stereo WiFi DTV/TPMS/OBD


$109.99


ON SALE Android 6.0 Double Din Car Stereo Radio GPS Wifi HD Mirror Link BT DVD


ON SALE Android 6.0 Double Din Car Stereo Radio GPS Wifi HD Mirror Link BT DVD


$168.95


Comfort Glow BDISC6 Original Brown Box Ceramic Disc Heater 5,200 BTUs


Comfort Glow BDISC6 Original Brown Box Ceramic Disc Heater 5,200 BTUs


$72.80


“The Original Brown Box” ceramic disc heater. Kosta Pelonis introduced the first ever ceramic disc heater in the late 1980′s. The superior heating performance, high energy efficiency, and sturdy steel cabinet have amazed consumers for over 30 years. Many owners report that their original brown box Pelonis disc heater is still performing exceptionally. The BDISC6 features 4 ceramic disc heating ele…

Teresamoon watch , Mens Date PU Leather Strap Sport Quartz Army Watch (Green)


Teresamoon watch , Mens Date PU Leather Strap Sport Quartz Army Watch (Green)


$3.99


★Please DONOT wear this watch when diving. Also avoid the use in extreme hot or cold temperature. ★If mist or droplets found inside watch surface, please contact manufacturer immediately for maintenance to prevent moisture corrosion of the internal components. ★Clean the strap by a soft cloth on regular bases is highly recommended. ★Too much water contact will shorter watch life….

Big promotion ! Teresamoon watch Christmas Cheapest Quartz Sport Wrist Watch Men (Rose Gold)


Big promotion ! Teresamoon watch Christmas Cheapest Quartz Sport Wrist Watch Men (Rose Gold)


$2.50


★Please DONOT wear this watch when diving. Also avoid the use in extreme hot or cold temperature. ★If mist or droplets found inside watch surface, please contact manufacturer immediately for maintenance to prevent moisture corrosion of the internal components. ★Clean the strap by a soft cloth on regular bases is highly recommended. ★Too much water contact will shorter watch life. ★100% S…







WizGear Universal Air Vent Magnetic Phone Car Mount Holder with Fast Swift-Snap Technology for Smartphones and Mini Tablets, Black


WizGear Universal Air Vent Magnetic Phone Car Mount Holder with Fast Swift-Snap Technology for Smartphones and Mini Tablets, Black


$6.99


WizGear Universal Air Vent Magnetic phone 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…

WizGear Universal Stick On Dashboard Magnetic Car Mount Holder for Cell Phones and Mini Tablets with Fast Swift-snap Technology


WizGear Universal Stick On Dashboard Magnetic Car Mount Holder for Cell Phones and Mini Tablets with Fast Swift-snap Technology


$7.99


WizGear Universal Stick On 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 stick it on your car dashboard! The WizGear Air Vent Mount features a magnetic technology, which means your smartphone will be secure and have…







Fitbit Charge 2 Heart Rate + Fitness Wristband


Fitbit Charge 2 Heart Rate + Fitness Wristband



Fitbit Charge 2 Heart Rate and Fitness Wristband. Make every beat count. Get PurePulse continuous, automatic wrist-based heart rate tracking–all-day, during workouts and beyond–all without an uncomfortable chest strap Use continuous heart rate to better measure calorie burn all day and help you stay on track toward weight goals Maximize your workouts using simplified heart rate zones (Fat Burn, …


Heavy Duty Pull Up Assist and Powerlifting Stretch Bands By Draper's Strength - Add Resistance For Stretching, Exercise, and Assisted Pull Ups. Free E-workout Guide (Single Band or Set) 41-inch


Heavy Duty Pull Up Assist and Powerlifting Stretch Bands By Draper’s Strength – Add Resistance For Stretching, Exercise, and Assisted Pull Ups. Free E-workout Guide (Single Band or Set) 41-inch



Why Draper’s Strength? LIFETIME DURABILITY – built to last and maintain their elasticity over many years of training. The secret to extreme durability and muscle building tension is the continuous latex dipping process that creates 100′s of micro layers in Draper’s Strength bands. MULTI FUNCTIONAL – used for ankle, knees, legs, thighs & wrists. Aids in weight loss. Perfect for strength-conditi…


Spy Tec M2 Waterproof Weatherproof Magnetic Case for STI GL300 / GX350 Real-Time GPS Trackers


Spy Tec M2 Waterproof Weatherproof Magnetic Case for STI GL300 / GX350 Real-Time GPS Trackers


$14.95


You need your GPS Tracker to do its job under any condition, and if you want to keep your GL300 tracker looking and functioning like new, a quality case is essential. Not only does the GL300 case protect your tracker with a durable outer layer of PC and ABS plastics, but it significantly enhances the function of the tracker. By applying the magnetic case to any flat, metal surface, you can effecti…

Tagged with:

Filed under: GPS Navigation Systems

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