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
Chicago limo Skokie ..2005 ? Back to the Future.What does the future hold?... Read More
This article will not attempt to advocate the use of... Read More
Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
We are in a transition phase in the Managerial Administration... Read More
This article is the fourth of a series of articles... Read More
Words we choose to describe things and phenomena often show... Read More
Manufacturing in the USA is far away down from mid... Read More
Do you want to get quality software at a reasonable... Read More
In linux, one of great commands for finding out information... Read More
The title of "software engineer" has got to be among... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
If you have Microsoft Great Plains as main accounting and... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
What is Interactive Mapping?Interactive mapping is a visual display medium... Read More
Fortunately one of the most common reasons cited for the... Read More
Whether you are a small consultancy firm, a medium sized... Read More
It???s easy to understand why you might be drawn to... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
When you double-click a layer in the Layer Palette, you... Read More
We'll give you non formal view, based on our consulting... Read More
limo O'Hare Bonfield ..Our hosted solution allow you to run your own search... Read More
Some companies that are in need of fleet management may... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
I completed an experiment recently. I wanted to find out... Read More
How many steps does it take you to locate and... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
There are several kinds of software piracy. The bottom line... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Once a business idea is selected, it is highly recommended... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
If there still are few unprotected computers left, I haven't... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
The title of "software engineer" has got to be among... Read More
When it comes to screenplay software each screenwriter needs to... Read More
The Internet is reshaping every form of communications medium, and... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
Trying to figure out a stream in banning one email... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Software |