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
![]() |
|
![]() |
|
![]() |
|
![]() |
In order to implement VLANs in a network environment, you'll... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Remember back in the days where screensavers were the coolest... Read More
The most important benefit of XML is its simplicity. Though... Read More
Microsoft Word is one of the most popular office applications... Read More
Viruses and spyware usually show up on your computer one... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
Just when you thought you were Web savvy, one more... Read More
If there still are few unprotected computers left, I haven't... Read More
Spyware and malware are large problems for Internet users today... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
Many Webmasters have never bothered to view their website's server... Read More
If you've been using MySQL database to store your important... Read More
The fact that a software tester is a most infamous... Read More
Since technology changes so quickly, it is hard to begin... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
Once upon a time not so long ago, there was... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
The Internet is reshaping every form of communications medium, and... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
Some companies that are in need of fleet management may... Read More
Domino server is a buffer between the operation system and... Read More
People often ask me: What image file formats will Photoshop... Read More
Let us give you - developer some hints in the... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
Are you a database professional? Do you work with a... Read More
Using professional icons in your application or website can bring... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
Corporate ERP/MRP selection might be tough one, especially considering very... Read More
A wiki is an editable text-based website. But you don't... Read More
Microsoft has never released a service pack for Windows98 SE,... Read More
The software giants don't do everything and don't always produce... Read More
Need software to record your voice, streaming audio or musical... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Spyware is software or hardware installed on a computer without... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
When Windows fails to boot it is normally caused by... Read More
Microsoft Great Plains is main accounting / ERP application... Read More
Spyware is like the new technological nuclear weapon on the... Read More
The stakes are high when considering security, privacy, and savings,... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More
At the end of XX century, in the late 1990th... Read More
Background: For many organizations like ours, the interim target of... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
SyncUp, a file synchronizer is designed to assist the home... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
Microsoft Business Solutions Great Plains might be considered as ERP... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
In today's business world it's all but impossible to escape... Read More
Are you a whiz at calculating financial information? Not the... Read More
Microsoft Outlook is one of the most widely used software... Read More
In linux, one of great commands for finding out information... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
Software |