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
Mercedes Benz s500 rentals Salem ..Think of this, first we had the HAM Radio, then... Read More
Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More
People often ask me: What image file formats will Photoshop... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Before September of 1995, Microsoft ignored the Internet because their... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
This article is the third of a series of articles... Read More
Bill of Lading is required report for Logistics and Freight... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
OEComplete is a utility for managing the personal information of... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
If you are in a business that passes documents around... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
It would be easy to think, like most people apparently... Read More
1. With mapping software you can create a report that... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
Following tips help you to learn a software in lesser... Read More
Microsoft Business Solutions is now in process of creating so... Read More
User interfaces and accessibility are some of the most important... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Dowagiac cheap limo service ..Just the thought of a duel-boot scares many people away,... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Usually workflow & messaging is realized in CRM and then... Read More
Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
Not every software testing project can or should be automated.... Read More
2005 ? Back to the Future.What does the future hold?... Read More
The Internet is reshaping every form of communications medium, and... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Trying to figure out a stream in banning one email... Read More
The java programming language is becoming more and more popular... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
Microsoft Retail Management System serves retail single store as well... Read More
Are you ready? SQL Server 2005, the next-generation data management... Read More
It won't matter how effective your WinRunner Team is if... Read More
Enabling Chinese input is quick and easy, there are only... Read More
Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More
The term "document management" and "paperless office" is the subject... Read More
In our case ? we serve Microsoft Business Solutions ERP... Read More
If you have Microsoft Great Plains and support it for... Read More
Great Plains Integration Manager scripting and translation - overview for... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
Software |