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
![]() |
|
![]() |
|
![]() |
|
![]() |
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
While I was preparing some personal background information for a... Read More
Using professional icons in your application or website can bring... Read More
In this small article we will be looking at the... Read More
Are you a database professional? Do you work with a... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
We'll give you non formal view, based on our consulting... Read More
Spyware and malware are large problems for Internet users today... Read More
People often ask me: What image file formats will Photoshop... Read More
We would like to give you several situations, when you... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
C++ Function templates are those functions which can handle different... Read More
When you buy a computer, it most likely comes with... Read More
You turn on your computer, and it doesn't look quite... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
Finally, you have some time to personalize your desktop with... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
Many reasons made GBM a unanimous choice for experts, one... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
The Windows registry is a huge database that ensures normal... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
When Great Plains Software was designing and developing Great Plains... Read More
Program Flow is what you think it is. How the... Read More
Shareware is software that you can try before you buy;... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
How to delete the user? This is the first problem... Read More
Looking at all the ads which promise to get rid... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
As seeing large number of implementations ? in our case... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Manufacturing in the USA is far away down from mid... Read More
Microsoft Business Solutions Navision serves both European and American megamarkets.... Read More
In this short FAQ style article we would like to... Read More
So let's begin crunching down these 300 images using Adobe... Read More
The software giants don't do everything and don't always produce... Read More
... Read More
XML parser is a software module to read documents and... Read More
There are so many different programs that clutter up your... Read More
If you are in a business that passes documents around... Read More
Using professional icons in your application or website can bring... Read More
Did you ever want to erase everything on your computer?... Read More
The purpose of Project Management Software is to provide an... Read More
Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Each Industry and market niche has business specific and unique... Read More
Microsoft Word is one of the most popular office applications... Read More
It's no secret that software companies operate in a very... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
There are several kinds of software piracy. The bottom line... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
In this small article we will show you the possible... Read More
Scrapbooks are very popular these days. I think that almost... Read More
We live in a post-industrial age where information is the... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Spyware is like the new technological nuclear weapon on the... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
Software |