Microsoft Great Plains e-Commerce ? additional considerations for programmer

Microsoft Great Plains, designed back in 1990th as database transferable and graphical platform independent ERP application ? Great Plains Dynamics/Dynamics C/S+/eEnterprise. For eCommerce developer the most important is to understand Great Plains tables structure and business processes in Sales Order Processing, Accounts Receivables, Inventory Control (inventory items allocation, backordering, etc), posting to Bank Reconciliation and General Ledger. And this is where Great Plains structure seems to be not transparent. Let's give you highlights:

1. Great Plains Tables Structure. Open Great Plains, if on version 7.5 or prior, Tools->Resource Description->Tables, then you should select Sales series, explore these tables:

2. Sales Order Processing module (SOP)

? SOP10100 ? Sales Order Processing header

? SOP10200 ? Sales Order Processing lines

? SOP10102 ? Sales Distribution Work and History ? it is how Invoices will be distributed in GL ? in case if you are creating quote or sales order with the following processing in GP backend ? you do not need distribution

3. Accounts Receivable module:

? RM00101 ? Customer Master

? RM00102 ? Customer Address Master ? each customer can have multiple addresses for delivering, billing, statement mailing, etc.

4. Possible issues and recommendations:

? If using eConnect ? you may decide to transfer Sales Orders to Invoices automatically with eConnect ? this might be tricky and additional scripting might be needed, especially if you are doing automatic order allocation by line item. If you are trying to relay on eConnect exclusively and not researching Great Plains Architecture ? you will need additions to eConnect from third party vendor, such as Alba Spectrum Technologies, which has the whole set of SOP populating stored procedures

? If you are not using eConnect and creating your own custom stored procedures ? you should probably create orders or other objects in Great Plains and then look at the way how they were recorded in SOP tables

? If you feel that you need to relay on Great Plains engine behind the scenes (because you feel that imitation will require you to rewrite substantial portion of Great Plains logic) ? you could deploy Dexterity triggers from Great Plains side ? this solution requires professional Dexterity programmer and is more reliable and upgrade ? proof

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! [email protected]

Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia

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

Forbes

Hard Questions Raised When A Software 'Glitch' Takes Down An Airliner
Forbes
Defects in software code – strings of numbers and letters – can do it too. Late last month, a Lion Air Boeing 737 Max 8 jetliner crashed into the Java Sea off Indonesia, killing all 189 passengers and crew, due to what investigators described as a ...


Opinion: How old-school manufacturers can reinvent themselves and beat back the software giants
MarketWatch
The software giants start with enormous technological momentum. Nearly all innovation in physical goods now requires a heavy dose of software. The Internet of Things, cloud computing, big data analytics and artificial intelligence are coming together ...


Business Insider

Wall Street thinks these 5 public software companies could get acquired in mega-deals amid the market downturn
Business Insider
"While the list of public software company acquisitions has been relatively short," Berg wrote, "the aggregate valuations have been at a premium level that we consider to be at the upper end of historical ranges." Now with the stock market in a ...

and more »

Forbes

The Good Software Company With The Scary Stock
Forbes
The first story is about publicly traded Autodesk, which sells nifty software for the design of parts and buildings. Engineers are addicted. Does that make it a guaranteed annuity? Consider these addictive products of the past: Netscape, Novell's ...


Harvard Business Review

How Software Is Helping Big Companies Dominate
Harvard Business Review
Even outside of the tech sector, the employment of more software developers is associated with a greater increase in industry concentration, and this relationship appears to be causal. Similarly, researchers at the OECD have found that markups — a ...


Forbes

Software Composition Analysis Startups: Investors Are Looking For These Three Qualities
Forbes
Given these impressive injections of capital into the software composition analysis market, some young entrepreneurs may see an opportunity to break into SCA with their own solutions. However, with all the competition from established players, these ...


Forbes

How A Mysterious Tech Billionaire Created Two Fortunes—And A Global Software Sweatshop
Forbes
rom an office suite on the 26th floor of the iconic Frost Bank Tower in Austin, Texas, a little-known recruiting firm called Crossover is searching the globe for software engineers. Crossover is looking for anyone who can commit to a 40- or 50-hour ...


AppleInsider

Black Friday 2018: Here are the best software deals for Mac and iOS users
AppleInsider
Black Friday 2018: Here are the best software deals for Mac and iOS users. By: Roger Fingas. Wednesday, November 21, 2018 9:43 AM. People typically think of physical goods when it comes to Black Friday, but it can also be a good time to grab Mac ...


Coingape

Bitcoin Abc New Software Release, Transactions Immutable After 10 Confirmations
Coingape
The market is in deep red since the bitcoin cash split. Many crypto enthusiasts are not in favor of BCH fork which resulted into Bitcoin ABC and Bitcoin Cash SV (Satoshi's Vision). One such crypto enthusiast, named Bob McElrath took Twitter ...

and more »

Economic Times

Facebook says outage was due to a server software problem
Economic Times
WASHINGTON D.C. [USA]: Facebook said Tuesday users had trouble accessing the social network and its other applications such as Instagram for a chunk of the day due to a server software problem. It was the second instance in the past two weeks in which ...

and more »
Google News

10 Steps To Secure And Manage Your Passwords

Passwords protect your most sensitive personal, financial and business information.... Read More

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

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

Four Easy Ways To Prevent Spyware

How would you like to prevent spyware and adware from... Read More

MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

If you look back to the history, you will see... Read More

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the... Read More

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

C++ Tutorials: 3, Program Flow (If, Else, While, For)

Program Flow is what you think it is. How the... Read More

Microsoft Great Plains IV: Inventory Management

Great Plains Inventory Management (IV) module gives your business a... Read More

Free Preventive Maintenance Software

While several preventive maintenance software manufacturers offer free trials for... Read More

Brand Your Websites URL With a Favicon

Have you ever noticed that when you look at your... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

10 Ways to Learn a Software

Following tips help you to learn a software in lesser... Read More

Are You Waiting for Microsoft Longhorn Operating System

I love new technology. I am still ready to wait... Read More

The Death of Windows

I have always regretted how Microsoft price gouges and rips... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

Vlans

In order to implement VLANs in a network environment, you'll... Read More

Microsoft CRM Implementation & Customization: MS CRM Fax Gateway

With this small article we are continuing Microsoft Business Solutions... Read More

Did You Ever Want to Completely Erase Everything on Your Computer?

Did you ever want to erase everything on your computer?... Read More

Great Plains Dexterity Programming ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More

The True Meaning of Freeware

The vast majority of us will have, at some point,... Read More

Great Plains Dexterity ? Microsoft Great Plains Customization Overview

Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Microsoft CRM ? Consulting in the Post-Recession Time

New post-recession era has new features, which didn't exist in... Read More