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 released Service Pack 2 (SP2) for the Windows XP... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
1. With mapping software you can create a report that... Read More
Best Software Act! is very popular CRM for small and... Read More
Is your PC is slow and wimpy? Then you need... Read More
There are two major WYSIWYG(What You See Is What You... Read More
Microsoft CRM is new player on the CRM software... Read More
The US House of Representatives has recently passed the "Spy... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
Buying accounting software is a major investment. It's an important... Read More
Have you ever noticed that when you look at your... Read More
Did you ever want to erase everything on your computer?... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
Spyware and malware are large problems for Internet users today... Read More
Are you lost in the mess of documents that get... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Find out why Spyware Removal from computers is important and... Read More
Pirated software is on the increase and now accounts for... Read More
When reading an article where some term is used often,... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
The Windows registry is a huge database that ensures normal... Read More
Most people understand that the "hardware" part of their computer... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
Microsoft CRM is now on the scene and it is... Read More
After seeing many people complain about their weak Internet security... Read More
If you are software developer or database administrator - we... Read More
There are certain pluses and minuses in both cases and... Read More
Handling character strings in Java is supported through two final... Read More
Today's business world is fast-paced. No matter what it is... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
In a previous article, I wrote about OpenOffice... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
In order to implement VLANs in a network environment, you'll... Read More
Our hosted solution allow you to run your own search... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
In the early days of the personal computer, we're talking... Read More
We all take the computer for granted. I mean, all... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
A wiki is an editable text-based website. But you don't... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Remember old good days when your company probably had Great... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
All your software is stored on a hard-drive. But how... Read More
An operating system (abbreviated OS) is essentially the path through... Read More
People often ask me: What image file formats will Photoshop... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
After almost two decades of existence, Quark has become the... Read More
The objective for Zandi Digital is to make available clever... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
Well, even if the combination might look very unusual, we... Read More
While I was in college, if you would have asked... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
The intentions of this short tutorial are not to teach... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
Trying to figure out a stream in banning one email... Read More
In the real world a "fire wall" is a fireproof... Read More
The most important benefit of XML is its simplicity. Though... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Great Plains is one of the Microsoft Business Solutions... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
Software |