Software Information

eCommerce development for Microsoft Great Plains: tools and highlights for programmer


Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise was designed in earlier 1990th as ERP, which can be easily transferable to the winning Database and OS platform and it was originally available on Mac and PC - Mac OS and Microsoft Windows respectively. Graphical platforms battle is pretty much over and now with eCommerce demands, we should look at Great Plains Dynamics tables structure:

? Naming Convention. Great Plains was designed to be ready to move to the winning database platform and probably this is why we see this a bit complicated naming convention in place: SOP10100, RM00101, IV00101 - these are samples: SOP header, Customer master, Inventory master. First - we see module prefix: SOP - Sales Order Processing, RM - Receivables management, IV - Inventory control, etc., then 0 stays for the master files, 1 - so-called work files (before transaction being posted), 2 - open files (after transaction is posted) and 3 - historical files (when you close the year in General Ledger - transactions are moved from open to history files). So as you see - logic is present and structured, but it is not friendly to the developer, who never seen and worked with Great Plains Dynamics.

? Tables Groups. Great plains was designed to first serve mid-size businesses and then with the availability of third party modules - the intention was to compete on corporate ERP market with Oracle, PeopleSoft, SAP and others big players. This is why we see the whole cluster of tables to store, say Sales Invoice: SOP Header, SOP Lines, SOP Distribution, RM Key file, etc.

From the Forms side (or screens) you can see more human-readable names: SOP Entry, RM_Customer_Maintenance, POP_Entry or the like. But these legacy Great Plains Dexterity names do not help eCommerce developer - only probably as the reference on which table works with specific screen.

Let's take a look at the tools available:

? eCommerce - together with eOrder, and other eXXX products it should be considered as legacy and phase out product, based on Microsoft eCommerce server and ASP technology, today Microsoft has new paradigm - .Net and ASPX World

? eConnect - was specially created for eCommerce developers, who integrate Microsoft Great Plains with eCommerce web interface. This tool covers a lot of Great Plains objects creation and retrieving functionality, however it does have restrictions, because it was not intended as replacement to Great Plains Dexterity shell. For example - if you create Orders in SOP via Web interface/eConnect - it is difficult manipulate these orders (transfers to Invoices, backorders, reallocations, etc.). Another issue with eConnect - developers are kind of used to the fact that Microsoft provides free SDK to its products, Microsoft CRM for example has freely downloadable Microsoft CRM SDK. For eConnect you have to pay license and be on Microsoft Business Solutions annual support to get version upgrades. Also if you are ISV and develop your GP integration to your customers - you have licensing issue with Microsoft.

? Custom SOP/AR stored procedures. Microsoft Business Solutions partners in their practice usually have several Great Plains integration projects implemented where integration is realized on the stored procedures level and transactions are created and manipulated in Great Plains SOP. So - you may end up seeking this type of help

Good luck with implementation, customization and integration and if you have issues or concerns - we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com

Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) - Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in San Francisco, San Diego, Chicago, New York, Atlanta, Houston, Dallas, Miami, Orlando, New Orleans, Phoenix, Seattle, Minneapolis, Detroit, Los Angeles


MORE RESOURCES:

Business Wire (press release)

Elliott Terminates Tender Offer to Acquire Epicor Software Corporation
MarketWatch - Nov 21, 2008
... LP and Elliott International, LP (collectively, "Elliott" or "we"), a major shareholder of Epicor Software Corporation (the "Company" or "Epicor"), ...
Epicor drops after hedge fund ends hostile bid Forbes
Hedge Fund Elliott Associates Withdraws Offer for Epicor Software Orange County Business Journal
UPDATE 1-Hedge Fund ends offer for Epicor Reuters
RTT News - Barron's Blogs
all 45 news articles


New York Times

The best thing about the 2.2 iPhone software update
CNET News, CA - Nov 21, 2008
When it some to iPhone software updates, I'm all about the basics. Apple could enable the iPhone to cook my dinner every night, but if it added multimedia ...
First Look: Apple's iPhone 2.2 Software Hits The Street (And ... CRN
Lots to like about new iPhone 2.2 software update Ars Technica
Apple releases iPhone Software v2.2 Apple Insider
G4 TV - infoSync World
all 144 news articles


BBC News

Microsoft to offer free security software to attract beginners
eTaiwan News, Taiwan - Nov 21, 2008
19 to stop selling personal computer security software and to use free personal anti-virus software instead. The new software called Morro can support seven ...
Microsoft: New software not Symantec, McAfee rival Reuters
Microsoft Plans to Introduce Free PC Security Software Wall Street Journal
Spamhaus: Microsoft Now 5th Most Spam Friendly ISP Washington Post
NetworkWorld.com - Bizjournals.com
all 304 news articles


Vertical Releases Feature-Rich Software Update for Wave
MarketWatch - 19 hours ago
... today announced the release of the Wave 1.5 software upgrade to it's award winning Wave IP 2500(TM) Business Communications Solution, the industry's ...


Hann’s On Software bouht by Mediware
Bizjournals.com, NC - Nov 21, 2008
Mediware Information Systems Inc. has bought the assets of Hann’s On Software, a pharmacy-management software provider based in Santa Rosa, for $3.5 million ...
Mediware Acquisition Adds 320 Pharmacy Facilities MarketWatch
Mediware Information buys assets of Hann's On Software - Quick Facts RTT News
Mediware Acquisition Adds 320 Pharmacy Facilities International Business Times
all 19 news articles


AVG Sees Uphill Battle for Microsoft in Its Launch of Free Anti ...
MarketWatch - Nov 21, 2008
AVG, which for eight years has offered free anti-virus software to users worldwide, noted the multiple challenges Microsoft faces in supporting a free ...
AVG sees 'uphill battle' for Microsoft Morro TechRadar UK
Microsoft Announces Upcoming Events for the Financial Community NewsBlaze
Microsoft Announces Upcoming Events for the Financial Community MarketWatch
all 30 news articles


Microsoft’s Mike Neil Keynotes at SYS-CON's 4th International ...
SYS-CON Media, NJ - 18 hours ago
... Black Duck Software, Blackbaud, Blade Network Technologies, Blue Coat, Blue Lane, BlueArc, BlueNote Networks, BluePheonix Solutions, BMC Software, ...
Teaching Everyone to Speak Big Blue New York Times
IBM To Acquire Virtualization Specialist Transitive InformationWeek
IBM To Buy Virtualization-Software Company Transitive NewsFactor Network
eWeek - SearchDataCenter.com
all 95 news articles


Frankly speaking, speech software better but still not great
Seattle Times, United States - 11 hours ago
Getting a computer to turn your speech into words on the screen requires buying expensive, resource-intensive software and mastering a sometimes confusing ...


Authoria Appoints New President and CEO
MarketWatch - Nov 21, 2008
Prior to joining Authoria, Mr. McDevitt was most recently Chief Operating Officer of CDC Software, a $360 million division of CDC Corporation and a global ...


Microsoft purges phony security software from 1 million PCs
Computerworld, MA - 22 hours ago
Windows users have been plagued with a flood of worthless security software in recent months as criminals have discovered that they're money-makers. ...

Software - Google News

home | site map
© 2006