Hot Web For You Online
Welcome to Hot Web For You Online!

Internet Articles


Microsoft Great Plains e-Commerce ? additional considerations for programmer
By Andrew Karasev


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

For more information about this article and/or the author visit mailto:help@albaspectrum.com

For more information, news and articles see:

Web Design Harrogate - Web Design Harrogate
...ust got a new job in web design harrogate. She has been looking for a new job doing web design harrogatefor some time now and she considers herself really lucky to have found the perfect job. She is...
Visit Web Design Harrogate...

Software Engineer - Software Engineer
...nagement and particularly focuses on a methodical approach to the error-free design and building of software. A Software Engineer will developed software with formal methods, Analysis and Design. Usin...
Visit Software Engineer...

Clive Roberts - Clive Roberts
...or British Airways. Which used SQL2005 (tables, stored procedures, triggers); Reporting Services for the invoices; Notification service to sent the email; VS.net 2005 for the protocols to add the file...
Visit Clive Roberts...

Advertising Agency Bristol - Advertising Agency Bristol
...therwise sales would slump and the business could be in trouble. An effective advertising campaign can work wonders for the health of a company and continued advertising will help to ensure that the ...
Visit Advertising Agency Bristol...

Website Design Bristol - Website Design Bristol
...proud of the way that your web pages look or do they lack a certain web presence? Has the site looked the same for the best part of a decade and could you be found guilty of not moving with the times...
Visit Website Design Bristol...

Website Design York - Website Design York
...site design York. He has wanted to get into website design Yorkfor a long time but he always felt that no decent firm would look at him because he did not have enough experience. However, although h...
Visit Website Design York...

Web Design Manchester - Web Design Manchester
...ecognised as quickly as possible so that sales can quickly take an upward spiral. Making your presence felt isn`t always that easy though and a great place to start will be your company`s website. As...
Visit Web Design Manchester...

Design Agency Manchester - Design Agency Manchester
... 2 years and when you first started up in business it was just what you needed to give you an immediate online presence. That was then and this is now, a few years down the line, and the time is righ...
Visit Design Agency Manchester...


Click For More Detailed Information on:
best study to you ::your tech science ::big study store ::technological online ::hot technological to you

Home  |  About Us  |  Contact Us  |  Articles  |  Special Reports  |  Links  |  Site Map

Copyright © 2003-2010. All Rights Reserved.


Valid CSS!