Great Plains Consultant: Microsoft Dynamics Gp Data Conversion
Microsoft Great Plains ERP or new name Dynamics GP requires precise approach in implementation, user training, initial data migration and conversion, reporting, EDI and possible customization and interface modification. Microsoft Dynamics GP consultant selection is often critical to the implementing process success. In this small publication we would like to review data massage and conversion recommendations and scenarios:
1. Data Export from your legacy ERP or accounting application. There are few possibilities, and this is dependent on your legacy MRP application platform. Usually old ERP allows you to export data in tab delimited or comma delimited text file format. However cheap small business accounting packages might be lacking export tool, and if this is your case, you should export data in the form of reports. Reports could be further massaged in Excel and then you should come to the next step – Great Plains Integration Manager data import
2. GP Integration Manager. IM can read text files as well as ODBC data sources. If you are sort of giving up in using IM and thinking that it doesn’t work in your case – you should read samples of advanced ODBC data sources. Advanced ODBC allows you to create advanced SQL Select, group and other aggregated statements. On MS Windows 2003 Server as well as on Vista or Windows XP workstations Microsoft Text driver has known issues and if you think it doesn’t do the job – we recommend you to call us in order to help you with advanced ODBC driver configuration
3. Excel data massage techniques. Here you typically process your initial export text file and make needed corrections
4. Data Conversion levels. Ideally you should import GL Chart of Accounts, Master records, such as Customers, Vendors, Employees, then you import your work transactions. In some cases you need to keep restricted number of open sales invoices while you are awaiting collection or payments
5. Great Plains Historical Data Conversion. This is what we do not really recommend or at least try to avoid that. GP History conversion is really tough process. Plus you will likely going to get data integrity issues while doing future check links in GP
About the Author
Andrew Karasev, Alba Spectrum http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please visit our information portal Pegas Planet: http://www.pegasplanet.com . If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant support to new and existing clients via web sessions for the customers in CA, IL, WI, NY, FL, IN, MI, TX, GA, NE, NM, AI, NC, SC, OR, WA, DC, DE, PA, VI, AZ, LA
Import GPS data into Google Earth
|
|
Weather Proof Magnetic Box for H1000,E1050 $43.98 E1050 Weatherproof Magnetic Box for the H1000. The sturdy weather proof box made especially for the H0001 features a magnetic mount for more application uses for the Passive GPS Data Logger… |
|
|
KJB Security H-3100INT Sky TRX World Wide Passive Logger w/ Internal Antenna $550.00 H-3100INT Sky TRX World Wide Passive Logger w/ Internal Antenna. SkyTRX GPS Systems are designed to provide accurate tracking data in an all in one inclusive package. Our sophisticated circuitry and small sleek design offers a robust solution to asset management at an affordable price. These GPS Vehicle Tracking Unit are a great way to track your vehicles or mobile assets. When you need to find ou… |
|
|
KJB Security Track Stick II Passive GPS Data Logger … |
|
|
Omron HJ-720ITC Pocket Pedometer with Advanced Omron Health Management Software … |
|
|
Timex Ironman Men’s Road Trainer Heart Rate Monitor Watch $64.50 Timex Ironman Road Trainer features target zones, average heart rate, recovery timer, max zone calculation, digital transmission and an owner replaceable battery.Features Included: 100-hour chronograph with lap and split, either in large digitsAlarm with 5-minute backupINDIGLO Night-Light10-workout memory chronograph or interval basedTarget heart rate zones with time in zone and audible alerts50-… |
|
|
Polar FT60 Women’s Heart Rate Monitor Watch (Purple) $239.95 For committed exercisers-the STAR Training Program tells how often and how intensively to train.Creates a training program based on personal goals and sets new weekly training targetsFitness test measures aerobic fitness at rest in just five minutesDisplays calories burnedItem SpecificationsColorPurpleHeart RateNoGPS EnabledNoCadenceNo… |
|
|
Garmin POWER/DATA Cable For GPS 101008200 $24 Garmin POWER/DATA Cable For GPS 101008200 |
|
|
Garmin / GPS, 128MB DATA CARD / 010-10226-03 $70.67 Garmin – GPS, 128MB DATA CARD – 010-10226-03 |
|
|
Garmin 128MB Garmin GPS Data Card 0101022603 $67.43 Garmin 128MB Garmin GPS Data Card 0101022603 |
|
|
iTrail GPS Data Logger $249.95 Product Overview: This GPS data logger captures location, speed, time Pinpoint an actual address online in Google Maps or Google Earth Small size makes it ideal for carrying it around or hiding it in a car, bag, etc. 120 hour life battery for continuous reliable GPS tracking Motion detection feature starts GPS tracking with movement to conserve battery All it Takes is this Tiny GPS Data Logger to Find Out Exactly Where Your Car Has Been The smallest GPS data logger yet, this 1.5 inch GPS data logger fits easily in a backpack, car, or in your pocket to capture GPS location points and detailed information like speed and time. The iTrail sleeps when there’s no movement to conserve battery, and springs into action when movement is detected to capture up to 120 hours of GPS location data. Perfect for tracking family members or vehicles, simply plug the iTrail into your computer to quickly and easily download everywhere the iTrail’s been including details like time, speed, and exact addresses visited in Google Maps and Google Earth. Key Benefits: Find out exactly where your family members, car, or employees have been Access your iTrail reports online Detailed reports Small enough to be hidden anywhere–extremely portable Tough exterior for outdoor use Automatically enters sleep mode to conserve battery power when standing still Popular Uses for the iTrail GPS Data Logger: Analyze vehicles routes to improve efficiency to save money and time Find out exactly what your kids are doing Monitor new teen drivers Perfect for law enforcement or private investigators Record your route when hiking or biking Features: Displays exact addresses and GPS location data in Google Maps and Google Earth Check speed, time, and exact address Small size - only 1.5" x 1.5" Water resistant for outdoor use Automatically enters sleep mode to conserve battery power when standing still 120 hours of continue tracking with powerful internal battery Export your travel data in multiple formats such as HTML, PDF, MS-Word, CSV, and more)� Includes: iTrail GPS Data Logger USB charge/transfer cable Silicone casing |
|
|
Bluetooth GPS with Data Logger $69.56 - US Global Sat bluetooth GPS receiver with data logging memory- SiRF Star III- 20 Channel all-in-view tracking- NMEA 0183- WAAS / EGNOS- 32′ Bluetooth wireless range- Set time / distance intervals- Stores 60,000 waypointsUSGBT335 |
