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! 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 California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia

---

Software Tools To Help Your Business Sell More

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

How To Develop Software For Your Business

Software development is a risky business.Many software developers are barely... Read More

Explore the Internet in a Whole New Way

For a long time now Microsoft's Internet Explorer has ruled... Read More

Assertion in Java

Assertion facility is added in J2SE 1.4. In order to... Read More

Selecting Microsoft Great Plains Partner/VAR/Reseller: ERP Implementation & Customization ? Overview

In the case when you represent mid-size or mid-size-to-large business,... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights

Logistics automation is often considered as barcoding extension to Sales... Read More

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More

What You Should Know About Installing Screensavers

Do you remember that frustrating feeling when you find an... Read More

netstat - Linux Command to Display Networking Information

In linux, one of great commands for finding out information... Read More

Microsoft Great Plains RW: Report Writer

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Getting Technical Support Help Online

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

Computer Phones ? Facts and Fallacies

The stakes are high when considering security, privacy, and savings,... Read More

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More

Linux vs Windows Operating Systems

With so many Microsoft Windows related viruses, errors, and other... Read More

Fast Car Knoppix

Small can be beautiful! Working with Knoppix for the past... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

Dont Choose Adobe When Working With PDF

While Adobe is the most known maker of PDF tools,... Read More

Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

It would be easy to think, like most people apparently... Read More

Create A Flash Presentation For Free With Open Office

The intentions of this short tutorial are not to teach... Read More

Microsoft Great Plains Implementation for Large Corporation ? Overview for VP IT

Microsoft Business Solutions Great Plains was historically designed to serve... Read More

Free Microsoft Word Online Training Tutorial Resources

Microsoft Word is one of the most popular office applications... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

Best Spyware Removers

Finding the best spyware removers to detect and remove spyware... Read More

Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

Usually workflow & messaging is realized in CRM and then... Read More

Microsoft CRM Customization ? Programming Closed Email Activity

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

Microsoft CRM Integration With Microsoft Office Documents ? Overview For System Integrator

Microsoft CRM is CRM application, maintained and supported by Microsoft... Read More

PHP On-The-Fly!

IntroductionPHP can be used for a lot of different things,... Read More

Groupware: What Works the Way Businesses Do?

GroupwareThe internet is full of 1.5 million to 7 million... Read More

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More

Perfectly New Database Query Tool - Foxy SQL Pro Released

Are you a database professional? Do you work with a... Read More

Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

When Great Plains Software introduced the first graphical accounting application... Read More

Bill of Lading ? Custom Reporting for Microsoft Great Plains ? Overview for Consultant

Bill of Lading is required report for Logistics and Freight... Read More