Dynamics GP ecommerce Integration Technologies: notes for Programmer
November 17, 2010 by GPS Answers
Filed under gps sale
Dynamics GP ecommerce Integration Technologies: notes for Programmer
Free Online Articles Directory
Why Submit Articles?
Top Authors
Top Articles
FAQ
AB Answers
0 && $.browser.msie ) {
var ie_version = parseInt($.browser.version);
if(ie_version Hello Guest
Login
Register
Hello
My Home
Sign Out
Email
Password
Remember me?
Lost Password?
Home Page > Computers > Software > Dynamics GP ecommerce Integration Technologies: notes for Programmer
Dynamics GP ecommerce Integration Technologies: notes for Programmer
Posted: Sep 16, 2009 |Comments: 0
|
]]>
Dynamics GP ecommerce Integration Technologies: notes for Programmer
By: Andrew Karasev
About the Author
Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Russia, Central America: Honduras, Costa Rica, San Salvador, Panama, Nicaragua, Guatemala
(ArticlesBase SC #1239247)
Article Source: http://www.articlesbase.com/ – Dynamics GP ecommerce Integration Technologies: notes for Programmer
We assume that in your case you have established Microsoft Dynamics GP (also known as Great Plains Dynamics in the past) and use it in production for accounting, Sales Order Processing, AP, AR, distribution and logistics. Plus you have working ecommerce website, where integration to GP is very loose: maybe it triggers email to Picking and Packing department, or Sales Order Processing people. In this small publication we would like to review relatively open for end user or in the case of software developer – not difficult to begin integration coding. We do not specifically review here differences between B2B and B2C ecommerce scenarios in Dynamics GP, please review our past articles. There are ready for deployment solutions, we assume that you already did this homework and decided to preserve your investments into your current eCommerce web application, and all you would like to do is robust integration:
1. Real Time versus Batch Mode integrations. Real Time ecommerce transactions move to GP Sales Orders or Invoices is definitely cool to have, however if this is not absolutely required, we recommend you first to think about Batch Mode ecommerce integration. Batch mode means, that ecommerce may have some lookups for your customers if item is available in one of your warehouses (via simple SQL query to your Dynamics GP Company database), however ecommerce transactions are moved to GP Sales Document only once per day, or maybe every hour, if you are larger ecommerce retailer
2. GP Integration Manager. This tool is very friendly to Great Plains users, and it could be extended by programmer via VBA event driven scripts. IM is first choice if you are planning integrate in Batch Mode. Please, do not be mislead by some GP consultants, that IM is for text files only. For advanced ecommerce integration to GP we recommend you to base IM data queries on SQL Server Views (Advanced ODBC based query) and the View itself looks at the existing GP orders and lines and into new ecommerce document – in that case your scenario could be completely automated. Plus IM integration could be called automatically via Windows macro third party tiny applications (or you can purchase Integration scheduling tool from Microsoft Business Solutions, check with your Dynamics GP Partner on that). We helped implement scenarios for large Computer IT integrator and warehouse, where all transactions are coming through B2B ecommerce website on PHP/Linux and GP Integration Manager is scheduled to run every 20 minutes to be close to real time mode integration. OK, now if you think IM is too simple, let’s move on to eConnect
3. eConnect SDK and technology for Dynamics GP. If you are C# or VB.Net ecommerce programmer or programming savvy web master, please review eConnect, as it has set of libraries, which could be added to your MS Visual Studio web projects and you could create, edit, delete virtually all GP Master records: customer, vendor, GL account, Item, Address, Employee, and work transactions: Sales Invoice, Purchase Order, Purchase Receipt, GL Transaction, Customer Payment. Please, note that you cannot post GP Batches (such as popular in ecommerce scenarios Sales Order Processing Batch) – if you need complete automation with Batch Posting you need to consider Alba Spectrum Posting Server or Autopost. Also, eConnect doesn’t cover some rather historical modules, such as Invoicing (usually Great Plains Customers prefer more robust Sales Order Processing module). And plus, eConnect from Dynamics GP doesn’t cover third party Dynamics GP ISV modules, which you may deploy – consider to check with you Great Plains ISV partner if they have extensions for eConnect. If you are on Dynamics GP 10.0 and 9.0 – eConnect is the way to go, however if you are on older version, consider to upgrade to GP version 10.0 prior to deploying eConnect in your ecommerce integration programming
4. Beyond eConnect. If you believe that your integration is SOP only and it is very simple, we offer Alba Spectrum Order Connector. This tool supports all current versions: 10.0 and 9.0 plus older versions: 7.5 and 8.0. You can also combine some Great Plains Dexterity programming to alter business processes in GP as additional help to Integration. We are trying to discourage you from considering direct SQL Server Stored procedures coding, as eConnect already have this work done for you – its initial layout is encrypted MS SQL Server Stored Procedures, plus consider the fact that Dynamics GP Business Logic and Data Flow is complex, and its database is not protected from inexperienced SQL programmer – you can compromise data integrity and incur additional unexpected expenses in involving GP Technical consultants to do data recovery and repair
5. How to get help? Please, feel free to call us: 1-866-528-0577, outside of USA: 1-630-961-5918 or email us help@albaspectrum.com We are very technical and real Dynamics GP Dexterity, SAP Business One SDK programming gurus. We have Great Plains Software Development Factory and could support unlimited Dynamics GP Customization and Programming needs. Plus we speak English, Chinese, Spanish, Portuguese, Russian, and not only as native speaking sales folks, but as real technical consultants. If you prefer skype: albaspectrum
Retrieved from “http://www.articlesbase.com/software-articles/dynamics-gp-ecommerce-integration-technologies-notes-for-programmer-1239247.html”
(ArticlesBase SC #1239247)
Andrew Karasev -
About the Author:
Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Russia, Central America: Honduras, Costa Rica, San Salvador, Panama, Nicaragua, Guatemala
]]>
Rate this Article
vote(s)
0 vote(s)
Feedback
RSS
Print
Email
Re-Publish
Article Tags:
dynamics gp, great plains dynamics
Latest Software Articles
More from Andrew Karasev
On http://ClubHouseGAS.com , Top Dog athletes learn about the benefits of a dynamic warm up. (06:30)
How to Perform Dynamic Football Drills
Coach Rankin has put together a series of drills designed specifically for football players. Start with the warm up clinic and then proceed into these dynamic drills. perform (01:01)
How to Understand Stroke Dynamics – Motion 3
Apple Motion 3 Tutorial, this video will focus on how to understand stroke dynamics. (06:13)
Learn about Dynamic Movement in Rock Climbing
Rock Climbing Tutorial – This video will show rock climbing and dynamic movement. (00:52)
Microsoft Expressions Web – How Dynamic Pages Display Data from Databases
Learn about Dynamic Pages, Agents, and how dynamic pages display data from database (04:53)
Dynamics Gp, Great Plains Dynamics All Versions Support Service
Of course, it is perfect idea to be on the latest Microsoft Dynamics GP version 11.0 (which is supposed to be released in April 2010). Well, you may say, that you had to stop your annual payments for Microsoft Business Solutions annual enhancement program long time ago, or you are on archaic version of Great Plains on Pervasive SQL, Btrieve or Ctree (7.5, 7.0, 6.0, 5.5, 5.0, 4.0 or earlier), or even on Great Plains Accounting for DOS, Windows or Macintosh.
By:
Andrew Karasevl
Computers>
Softwarel
Mar 18, 2010
Dynamics GP Great Plains in Russia, please consider instead SAP Business One
Real life is going on, in early 1990th our company localized Great Plains Dynamics in Russia and CIS, this was done for Great Plains Dynamics version 3.2. Late on Microsoft Business Solutions made crucial decision to restrict its Dynamics GP, formerly known as Great Plains products line to USA, Canada (including French Speaking Quebec province), other English Speaking countries and Latin America (Excluding Portuguese speaking Brazil).
By:
Andrew Karasevl
Computersl
Aug 21, 2009
Corporate ERP Selection Notes: SAP B1, Dynamics GP Great Plains
Corporate ERP System is a must for small and mid-size business, when you plan to lead your company to the point, where the business has stable market value, and it is ready to be open for micro and small capitalization, venture capital, or simply be placed for sale.
By:
Andrew Karasevl
Computers>
Softwarel
Jun 20, 2009
lViews: 223
It and Networking Support for Dynamics Gp Great Plains ERP
Microsoft Dynamics GP ERP, formerly known as Great Plains Dynamics and eEnterprise, is client-server application, meaning that if you are small business and you do not have in house IT department, Dynamics GP support from computer hardware and networking sides might be an issue.
By:
Andrew Karasevl
Computers>
Information Technologyl
Feb 12, 2009
lViews: 250
Microsoft Dynamics Gp Great Plains East European Options Overview for Consultant
Great Plains Software Dynamics and eEnterprise were popular in Europe, prior to Microsoft acquisition of Great Plains Software, and since then Microsoft acquired also such ERP as Navision with strong European market presence. In those days of Navision purchase, Microsoft Business Solutions made a decision to market Navision, or current name Dynamics NAV in Europe and sort of deemphasize Dynamics GP Great Plains
By:
Andrew Karasevl
Computers>
Softwarel
Oct 25, 2008
lViews: 242
Microsoft Dynamics Gp Great Plains Consultants With Industry Expertise
Microsoft Dynamics GP Great Plains certified consultants with average 10 years of experience are available for GP implementation, customization, data conversion, integration, user training and ongoing support. We have experience in such modules as General Ledger, Accounts Payable, Accounts Receivables, Sales Order Processing, Purchase Order Processing, Project Accounting, Fixed Assets, Payroll, ReportWriter, FRx, Crystal Reports for GP, Microsoft Dexterity, eConnect and GP Integration Manager
By:
Andrew Karasevl
Computers>
Softwarel
Jul 23, 2008
lViews: 306
FRx for Dynamics GP Great Plains Recovery notes
If your organization deploys old version of Great Plains Dynamics or eEnterprise: 7.5, 7.0, 6.0, 5.5, 5.0 or earlier and your user workstation, where you had FRx client installed crushed, we would like to recommend you several steps in FRx reinstallation and repair. In the case of eEnterprise your Database is likely MS SQL Server 2000 or 7, older versions of high end Dynamics we also known under Dynamics C/S+ name.
By:
Andrew Karasevl
Computers>
Softwarel
Oct 23, 2009
Barcode Scanning in Dynamics GP Great Plains Notes
This small publication is for existing Microsoft Dynamics GP, formerly known as Great Plains Dynamics, customers with unique Supply Chain Management, Logistics, Transportation, Warehouse Management automation requirements, where out-of-shelf Dynamics GP barcoding add-ons do not fit without further modification.
By:
Andrew Karasevl
Computers>
Softwarel
Jul 31, 2009
Designing Web Pages Using Dreamweaver
Web pages are common terms that people are all very familiar with. No matter how simple or complex a website is, making changes to these particular pages is not quite as easy as it actually sounds.
By:
danl
Computers>
Softwarel
Nov 16, 2010
What Exactly Is Drive Image Software?
A system crash can cause loss of files, and this type of event certainly can cost your organization a substantial amount of money. While a small or even moderate crash can cause stress and panic over lost time and the possibility of lost files since your last backup, a major crash can really wreak havoc. Drive image software, however, provides you with a valuable solution to protect your data and restore your system quickly in the event of even the largest of crashes.
By:
Carla Kaplanl
Computers>
Softwarel
Nov 16, 2010
How Does Drive Image Software Work?
You have likely heard how incredibly valuable drive image software can be for your organization. In the event of a disastrous loss of data from a virus, hardware failure, or a system crash, this software program can help you get your operations up and running again in a fast way. While you know this is a critical type of data insurance to have, you still want to know more about how it actually works before you invest in it.
By:
Carla Kaplanl
Computers>
Softwarel
Nov 16, 2010
Why Does Your Company Need Drive Image Software?
Over the course of your day to day operations, your company’s data files can change drastically. Many users will open and adjust data on dozens of files over the course of a day, and it can be a real nightmare to try to recreate data for even a single day during a disastrous event such as a hardware failure, virus, or other such event that takes your system down in a hurry.
By:
Carla Kaplanl
Computers>
Softwarel
Nov 16, 2010
Why Drive Image Software Is the Right Choice
If you are the IT manager for a small company or the owner of a small business, then you probably already have some form of backup software installed. There are many legal reasons for doing so, not least of which is that you are responsible for the safety of your clients’ and your employees’ information. But, basic backup software may not be enough for you and that is why you should be looking at some of the other products on the market.
By:
Carla Kaplanl
Computers>
Softwarel
Nov 16, 2010
What Are the Advantages of Buying Drive Image Software?
You probably already know and understand the value of having a backup to your computer. We have all heard plenty of horror stories about the many thousands of viruses that are floating around on the internet. We also know people who have either inadvertently or intentionally corrupted the data on corporate networks.
By:
Carla Kaplanl
Computers>
Softwarel
Nov 16, 2010
Why Do You Need Data Backup Software?
It’s pretty obvious why you need to backup your company’s vital data, but why do you need data backup software? There are so many times when computers and servers have crashed and left people scratching their heads in disbelief, and likely even panicking, too. Most everyone knows they need to save their data periodically, but if you haven’t been doing this regularly and your system does crash, you may find yourself in quite a panic, too!
By:
Carla Kaplanl
Computers>
Softwarel
Nov 16, 2010
What Do You Look for in Data Backup Software?
If you’ve decided to purchase data backup software for your business, you have made a great decision. Such a program can really take the guesswork and human error out of saving your precious data files, and this helps to ensure that you can a full and total restore of files if the time comes and you do need to perform a restore function. However, if you have started looking at all of the various products on the market, you are likely confused by the options.
By:
Carla Kaplanl
Computers>
Softwarel
Nov 16, 2010
Dynamics GP Western Michigan: Implementation, Support, Recovery, Upgrade
The best Corporate ERP implementation partner is the local one, right? Well, probably, yes to some extents, especially when your local Dynamics GP Reseller has profound expertise in your industry.
By:
Andrew Karasevl
Computers>
Softwarel
Nov 16, 2010
Dynamics GP Warehousing: Fulfillment, Restocking, Adjustments
Microsoft Dynamics GP offers flexible modules and tools for Distribution and Logistics and general Supply Chain Management. Warehousing logistics is often very unique to your specific business model and you may expect custom programming and integration to have SCM and its parts, such as Warehouse Management System, Trucks Delivery optimization and real time tracking.
By:
Andrew Karasevl
Computers>
Softwarel
Nov 14, 2010
Counterpoint to Dynamics GP Integration Scenarios, Great Plains in POS Implementation Notes
Counterpoint POS application from Radiant Systems is very popular among small and even midsize retailers, including non-for-profit organizations, such as parks, forest preserves, zoos, deli stores. In Counterpoint you can have pretty much all your POS devices, such as barcode laser scanners, customer tabloids, touch screens, credit card processing and signature capturing devices to be implemented.
By:
Andrew Karasevl
Computers>
Softwarel
Nov 13, 2010
Dynamics GP Technical Support: No Customer Left Behind
How about finding Great Plains Dynamics GP VAR, Partner or Reseller who supports all ever released versions of Great Plains (recently renamed into Microsoft Dynamics GP): 2010/11.0, 10.0, 9.0, 8.0. 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 and even going further into the history – Great Plains Accounting for DOS, Windows or Mac 9.5, 9.2, 9.1, and earlier
By:
Andrew Karasevl
Computers>
Softwarel
Nov 11, 2010
Dynamics GP Supply Chain Management: Implementation, Integration, Customization
Supply Chain Management automation for your Corporate ERP system in by all means very serious step and complex project. SCM often includes so-called Warehouse Management System in its core functionality, plus various extensions, usually based on Barcode laser scanning technologies. Sometimes SCM features might be referred as Logistics or even Distribution.
By:
Andrew Karasevl
Computers>
Softwarel
Nov 11, 2010
Dynamics GP Implementation in Wholesale and Retail Trade: POS, Barcoding, WMS
Accounting and Corporate ERP applications are in the transformation to become Barcoding, POS devices friendly, and you may expect them to be implemented in industries, such as Retail and Wholesale.
By:
Andrew Karasevl
Computers>
Softwarel
Nov 10, 2010
Dynamics GP in Supply Chain Management: WMS, Delivery Route Optimization
Microsoft Dynamics GP is very popular and wide spread mid-market Corporate ERP platform, sometimes referred by its historical name Great Plains Dynamics.
By:
Andrew Karasevl
Computers>
Softwarel
Nov 09, 2010
Dynamics GP POS Implementation, Integration, Reporting: Counterpoint, MS RMS
Microsoft Dynamics GP could be implemented as Corporate ERP application for the chain of retail stores, where Great Plains could do all the jobs, such as Restocking, Merchandise Count, Sales.
By:
Andrew Karasevl
Computers>
Softwarel
Nov 08, 2010
Add new Comment
Your Name: *
Your Email:
Comment Body: *
Verification code:*
* Required fields
Submit
Your Articles Here
It’s Free and easy
Sign Up Today
Author Navigation
My Home
Publish Article
View/Edit Articles
View/Edit Q&A
Edit your Account
Manage Authors
Statistics Page
Personal RSS Builder
My Home
Edit your Account
Update Profile
View/Edit Q&A
Publish Article
Author Box
Andrew Karasev has 918 articles online
Articles Categories
All Categories
Advertising
Arts & Entertainment
Automotive
Beauty
Business
Careers
Computers
Education
Finance
Food and Beverage
Health
Hobbies
Home and Family
Home Improvement
Internet
Law
Marketing
News and Society
Relationships
Self Improvement
Shopping
Spirituality
Sports and Fitness
Technology
Travel
Writing
Computer Forensics
Computer Games
Data Recovery
Databases
E-Learning
File Types
Hardware
Information Technology
Intra-net
Laptops
Networks
Operating Systems
Programming
Security
Software
]]>
Need Help?
Contact Us
FAQ
Submit Articles
Editorial Guidelines
Blog
Site Links
Recent Articles
Top Authors
Top Articles
Find Articles
Site Map
Webmasters
RSS Builder
RSS
Link to Us
Business Info
Advertising
Use of this web site constitutes acceptance of the Terms Of Use and Privacy Policy | User published content is licensed under a Creative Commons License.
Copyright © 2005-2010 Free Articles by ArticlesBase.com, All rights reserved.
Andrew Karasev, Alba Spectrum , help@albaspectrum.com 1-866-528-0577 http://www.albaspectrum.com Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal: http://www.pegasplanet.com We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Russia, Central America: Honduras, Costa Rica, San Salvador, Panama, Nicaragua, Guatemala
