Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
eCommerce development for Microsoft Great Plains: tools and highlights for programmer > NetSparsh - Viral Content you Love & Share

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

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

GlobeSt.com

New Software Revolutionizes Site Planning
GlobeSt.com
... Areas to create, store and share work orders for properties and facilities. We sat down with Casey Rue, the founder and CEO of Common Areas, to talk about the new software, what users can expect and how it will impact the commercial real estate ...


Forbes

What It Will Take For The Software Services Industry To Navigate A Digital Future
Forbes
The global economy is going through a phase of accelerated change. More than 30 billion devices will be connected to the internet by 2020. These networks generate extensive data that yields insights for private and public institutions. With these ...


Clarkson professor gets grant to compare DNA software
WatertownDailyTimes.com
Ms. Matthews, an associate computer science professor at Clarkson University, is leading a team that has been awarded a $75,000 Brown Institute Magic grant for her project, Decoding Difference in DNA Forensic Software. “Simply put, when computers are ...


TechCrunch

Kaspersky pulls plug on Europol joint venture after EU parliament ...
TechCrunch
Fresh political woes for Russian security firm Kaspersky, which has reacted angrily to a vote in the European Union Parliament last week to ban its software ...

and more »

The Independent

iPhones will share your exact location with 911 in next software - WSMV News 4
WSMV Nashville
Apple is rolling out a new feature in its next iPhone software update to send emergency responders instant, precise location information in the US. The update, coming in iOS 12 later this year, calculates a caller's location based on data collected ...
iOS 12: New iPhone software update will share location with emergency servicesThe Independent
Apple's new iPhone software includes a feature that could save lives13abc Action News
iPhones will share your exact location with 911CNNMoney
Apple Newsroom
all 313 news articles »

CIO

14 reasons why software projects fail
CIO
Every software project begins with big dreams and grand visions. Somewhere in an alternative universe, there is a project that fulfills every dream but all too often software projects in our universe stumble toward the finish line and sometimes cross ...


TechRadar

Best helpdesk software of 2018
TechRadar
Zendesk Support is a software package that provides organization to put a variety of customer support interactions in one accessible database. It has the features for an efficient workflow, including web widgets, the ability to search a customer's ...


Deutsche Bank CIO shows how to do software right in the digital era
CIO
Most CIOs can talk all day about how they're leveraging machine learning, blockchain and other emerging technologies to differentiate their businesses. But IT leaders rarely discuss how they're improving the performance of their software, a critical ...


Software Stocks Flying High As Acquisitions, IPOs Drive Up Valuations
Investor's Business Daily
Acquisitions by Salesforce.com (CRM) and Workday (WDAY) — as well as initial public offerings by DocuSign (DOCU), Zscaler (ZS) and Smartsheet (SMAR) — are driving up valuations of computer software stocks to a point where a pullback may be needed ...


Sun Sentinel

Ultimate Software ranks No. 1 mid-sized company for 'best place to work in IT'
Sun Sentinel
This is the second consecutive year Ultimate Software was named at the top of mid-sized organizations in the annual ranking of top technology workplaces. Quicken Loans in Detroit was top-ranked among large organizations, and Cloud for Good in Asheville ...

and more »
Google News

Design a Web Album Using Adobe Photoshop- Part 2

So let's begin crunching down these 300 images using Adobe... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Introduction To ISDN, Part II

In the previous ISDN article, we looked at how and... Read More

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

Putting Screensavers Under Control

No matter how much you enjoy your favorite screensavers, sometimes... Read More

Microsoft CRM Customization ? Programming Closed Email Activity

Microsoft CRM is CRM answer from Microsoft and attempt to... Read More

Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights

Microsoft Great Plains is one of the Microsoft Business Solutions... Read More

Getting Technical Support Help Online

Sometimes your PC will start acting strange for no apparent... Read More

Internet Relay Chat - A Basic Introduction

What is IRC?IRC is Internet Relay Chat. It is a... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

Lotus Notes Domino and Web: Application Development ? Tips for Programmers

Beginning with Domino version R4 it has integration with the... Read More

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

Microsoft Great Plains is one of three Microsoft Business Solutions... Read More

Crystal Reports for Microsoft Great Plains ? Overview for Developer

Microsoft Great Plains is main accounting / ERP application... Read More

Software Review: Xsitepro Total Site Management Software

It's not very often I get excited about a software... Read More

Internet Faxing Service Review

The Internet is reshaping every form of communications medium, and... Read More

SQL scripts for Project Accounting: Microsoft Great Plains series ? overview for developer

Microsoft Business Solutions Great Plains has Project Accounting module where... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... Read More

ERP Remote Support: Microsoft Great Plains Analysis ? Pluses & Minuses

Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More

Outlook... Not Just for Email! Using Your Outlook Calendar

Microsoft Outlook is one of the most widely used software... Read More

eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

eStore Advantage allows front-office applications to communicate with back-office business... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More