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
Lincoln Stretch rentals Alsip ..Microsoft Business Solutions Great Plains has many years of successful... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
At the end of XX century, in the late 1990th... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
I've been active in the Cisco Certification track for four... Read More
Need software to record your voice, streaming audio or musical... Read More
It is really interesting that a bug can create problem... Read More
I suggest that you do not spend a lot of... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Stealing company information used to be the specialty of spies... Read More
When reading an article where some term is used often,... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
If you are in a business that passes documents around... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Manufacturing in the USA is far away down from mid... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
New post-recession era has new features, which didn't exist in... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
It's no secret that software companies operate in a very... Read More
Three highly respected names in Human Resources have joined forces... Read More
Western Springs shuttle limo ..GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
We would like first emphasize the change in the paradigm.... Read More
Learning how to program software seems like a daunting task... Read More
Background: For many organizations like ours, the interim target of... Read More
Adware is a type of Spyware program that displays some... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
Beginning with Domino version R4 it has integration with the... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
(1) Avoid using the same variable again and again for... Read More
The research in the field of Natural Language Processing usually... Read More
Microsoft Business Solutions Great Plains is very popular ERP platform... Read More
Are you a whiz at calculating financial information? Not the... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
The first thing that you will notice about Linux Red... Read More
The most important things you can do for your computer... Read More
It is possible that if one avoided all sources of... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
Well, even if the combination might look very unusual, we... Read More
Following tips help you to learn a software in lesser... Read More
Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
Software |