| |
Microsoft Great Plains: exchange & brokerage - implementation notes
By Andrew Karasev
If you company is small
or mid-size special products or materials exchange broker, you probably have
custom in-house made exchange application. Nowadays exchange is done over the
internet, so you might have advanced web-based exchange application. Microsoft
Business Solutions Great Plains could play the role of the backend: accounting,
sales and purchasing ordering, backordering, allocation, collection. In this
case we expect tight integration between your exchange application and Great
Plains. In this small article we consider industry / market niche specifics and
the ways to realize these requirements:
Exchange
Transaction. Exchange
transaction usually has two parts: Sales and Purchasing. This transaction
should be translated into Great Plains as Sales Order in Sales Order
Processing (SOP) and Purchase Order in Purchase Order Processing (POP).
Assuming that you have web developers and C#, VB.Net programmers, you can
deploy eConnect Distribution - this is Software Development Kit with sample
codes, you can create or modify
Great Plains objects,
such as Sales Order, Customer record, Purchase Order, Vendor record. One
warning about eConnect - it is designed based on general ERP application
principles: you can create work transaction only - you can not post
transaction, this is left for the Great Plains user
Bill of Lading.
In materials selling, when you order something you probably know number of
packs or bundles, but you do not know exact weight or length. You get this
information when you receive Bill of Lading. You need Bill of Lading
automatic integration and qty update in Sales Order or Purchase Order. At
this moment you do Sales Order allocation. eConnect, mentioned above should
do the job
Agent Commission.
You could use Salesperson, associate him/her with items sold in Sales Order
and then calculate and pay commission, using your own formulas.
Reporting. In the case of integrated web application with
Great Plains, we would expect heterogeneous
sql queries and reporting, based on these queries and stored procedures. To
produce nice and flexible reports - you usually deploy Crystal Reports and
publish them in your web application.
Transaction Posting.
As mentioned above - this should be preferably done by Great Plains user with
approval logic. However if you have thousands transactions per day or hour
and it is physically not possible, you should go beyond eConnect functionality
and post transactions automatically. You need custom stored procedures,
posting and transferring Sales Orders. You can create these procedures
yourself or purchase the ones, available on the market.
Customization Tools:
Great Plains Dexterity, Modifier with VBA, Transact SQL scripting to name the
most popular.
Good luck and you can
always seek our help in customization, implementation, integration and support.
Call us: 1-866-528-0577 or 1-630-961-5918,
help@albaspectrum.com
About the Author
Andrew Karasev is Chief
Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains,
Microsoft CRM customization company, serving Chicago, California, Arizona,
Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe,
Russia and having locations in multiple states and internationally (
http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports
and Microsoft CRM SDK developer
Article Source: http://www.simplysearch4it.com/article/4757.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/4757.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 ...
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 SAP ERP ...
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 still a core ...
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 should ...
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, XML: Web Services.
...
|
|
| |
