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

---

IBM Lotus Domino or Microsoft Exchange?

IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

Healthcare Preventive Maintenance Software

Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as... Read More

Microsoft Great Plains - Microsoft RMS Integration ? overview

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

25 Things Mapping Software Can Do For You

1. With mapping software you can create a report that... Read More

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Pros and Cons of Using FREE Software in Your Business

Itâ??s easy to understand why you might be drawn to... Read More

Bridging the Gap between Paper and Data

The cornerstone of successful automated office systems is the ability... Read More

5 Time-Saving Tips in Microsoft Word

Whether you have used Microsoft Word for years, have just... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

Great Plains Accounting Migration to Microsoft Great Plains - Overview for IT Specialist

This is a short article, written in question/answer/FAQ style to... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More

Ukraine IT Myths Dispersed

While Ukraine is becoming a new popular IT outsourcing destination,... Read More

Software: What Suits Me?

Almost all new and major brand of PCs come with... Read More

Reduce Pop-ups and Annoying Ads

There is many things more frustrating than surfing a website... Read More

The XP Firewall Isnt Enough

You might think you don't need a firewall... Read More

Microsoft Great Plains Food Processing ? Implementation & Customization Highlights

Microsoft Great Plains might be considered as ERP platform to... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More

Running a Program on a Remote Server Using SSH

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

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Protect Your Most Vital Business Asset with Security Software

Homeland security, airport security, Internet security â?" these days weâ??re... Read More

Internet Security Threats: Who Can Read Your Email?

Before being able to choose a secure Internet communication system,... Read More

Corporate ERP: Standard vs. Rich functionality ? Microsoft Great Plains

Traditionally we were considering functionally rich systems, such as SAP,... Read More

Protect Your Computer...and Your Business!

We all take the computer for granted. I mean, all... Read More

Create A Flash Presentation For Free With Open Office

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

When is a Software Engineer Not a Software Engineer?

The title of "software engineer" has got to be among... Read More

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Microsoft CRM Lotus Notes Domino Connector FAQ

Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More

How To Develop Software For Your Business

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

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More