Microsoft Great Plains e-Commerce - additional considerations for programmer

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: 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

Accounts Receivable module:

RM00101 – Customer Master RM00102 – Customer Address Master – each customer can have multiple addresses for delivering, billing, statement mailing, etc.

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
 
 
About the Author
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

Article Source: http://www.simplysearch4it.com/article/2036.html
 

If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/2036.html" as shown above and make it hyperlinked.

Some other articles by Andrew Karasev

SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article we would like to ... SAP Business One in Illinois: implementation, upgrade, customization, integration Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of diversified mid-size businesses, engaged in light assembly, shipping and receiving and distribution to their wholesale and ... SAP Business One Chicago Market Review, plus customization, integration & data conversion SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development companies, now it is part of ... Microsoft Dynamics GP Office Stack Integration advances – Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains Dexterity is ... eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and reporting. As software programmer you ... Microsoft Dynamics GP Dexterity Customization Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual Studio development, eConnect, ...