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
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
monthly home cleaning Buffalo Grove ..It's all about turn times in the eMedia industry! The... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
Are you a whiz at calculating financial information? Not the... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
Now that spyware is the single most dangerous threat to... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Domino server is a buffer between the operation system and... Read More
It is possible that if one avoided all sources of... Read More
Homeland security, airport security, Internet security ??" these days we???re... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
Great Plains Integration Manager scripting and translation - overview for... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Document Manager and Version HistoryIn previous articles I have discussed... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
It's not very often I get excited about a software... Read More
Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More
You might think you don't need a firewall... Read More
Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More
Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
Are you lost in the mess of documents that get... Read More
User interfaces and accessibility are some of the most important... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
As we could imagine, if you are reading this article... Read More
scheduled maid service Mundelein ..Some companies that are in need of fleet management may... Read More
Fundraising software lets you connect with donors in a way... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Is your PC is slow and wimpy? Then you need... Read More
The adware and spyware definitions list is very long. But... Read More
There are plenty of articles out there about how to... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
While I was preparing some personal background information for a... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
It is really interesting that a bug can create problem... Read More
Introduction to C++Why Learn C++?C++ may at first seem like... Read More
Almost all new and major brand of PCs come with... Read More
The stakes are high when considering security, privacy, and savings,... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
Stealing company information used to be the specialty of spies... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
During the years of our consulting practice, which comes back... Read More
Software |