Microsoft Great Plains: exchange & brokerage ? implementation notes

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,

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 ( ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer

In The News:

SFGate (blog)

Syapse brings precision medicine software to one of world's largest hospitals
SFGate (blog)
SyapseScreenShot2.jpg Palo Alto company Syapse said Thursday it will bring its “precision medicine” software, which aims to tailor treatments to the underlying genetics of diseases, to cancer-treatment centers run by the Hospital Corp. of America, one ...

and more »

Four Software Stocks to Buy Ahead of Q4 Reports
In our opinion, the recent exchange-rate fluctuations do not reflect changes in sector fundamentals, and we think most Software-as-a-Service (SaaS) and applications software companies can still execute in line with consensus estimates this year because ...

and more »

Council shuns IRIS shared software consortium
Bay of Plenty Regional Council has hatched a software surprise, opting not to join a consortium of New Zealand regional councils using a shared, purpose-built software platform. The council, on the east coast of the North Island, will implement ...


Microsoft gives away more Office software to attract mobile users
SEATTLE (Reuters) - Microsoft Corp made its popular Word, Excel and PowerPoint applications available for free on Android tablets on Thursday, marking the latest step in its drive to get as many mobile customers as possible using its software.
You can download Microsoft's Office for Android tablet apps todayTechRadar

all 295 news articles »

The Register

Five years of Sun software under Oracle: Were the critics right?
The Register
Oracle-Sun anniversary Back in 2010, critics worried that Sun Microsystems' software portfolio would wither on the vine once Oracle got its hands on it. Five years on and the worst fears have proven baseless, yet former Sun diehards have had plenty to ...

The business case for email encryption software
Email encryption software is used by enterprises to automatically encrypt email messages and attachments that contain or are likely to contain sensitive information. So, for example, a business may choose to deploy email encryption when forwarding ...


Advent Software options unusually active ahead of deal news
San Francisco-based Advent Software's shares jumped as much as 13 percent to an all-time high of $42.85 on Wednesday, after a Bloomberg report said SS&C plans to offer $45 per share for Advent. Reuters has not independently verified the information, ...
Midday movers: Petrobras, Advent Software & moreCNBC
Update: Is Advent Software An Acquisition Target? (ADVS)Seeking Alpha (registration)
Advent Software (ADVS) Stock Soaring Today on Acquisition
Investor's Business Daily -Reuters UK
all 40 news articles »

Kansas City Star

Intuit will undo unpopular changes in its TurboTax software
Kansas City Star
Intuit, having admitted one mistake, says it will undo another. Changes in its popular TurboTax software caught many users by surprise. The changes required them to upgrade — and pay more — to use some of the same tax forms this year as last tax season.
TurboTax totally caves in price hike outcryUSA TODAY
Intuit reverses course on TurboTax software changesChicago Tribune
Intuit to undo unpopular changes in its TurboTax softwareThe Olympian

all 20 news articles »

Daily Mail

Tesla's P85D Will Get Even Faster Thanks To A Software Update
Tesla's P85D is already fast. Really, really fast. Push the button to put the car into “Insane” mode (really — that's what it's called) and it'll do 0-60 in 3.2 seconds. Now it's about to get even faster. And get this: It's getting faster because of ...
Tesla's 'insane mode' just got FASTER with over-the-air software upgradeDaily Mail
Tesla Model S P85D's 'Insane Mode' Gets A Software Upgrade, Now Goes 0.1 ...The Inquisitr
Tesla Model S P85D To Get Software Update That Makes It Even FasterUbergizmo (blog)
The Escapist -CarAdvice -Headlines & Global News
all 31 news articles »

The Guardian

Are there any trustworthy sources for downloading software?
The Guardian
In practice, it's safest to download software directly from the original source, but not all companies are equally trustworthy. Microsoft and Mozilla (Firefox) should be fine, for example, but Oracle (Java) and Adobe will foist unwanted programs on you ...

Google News

Microsoft Great Plains Payroll Module Customization Scenarios

It is now common thing when large corporation selects mid-market... Read More


Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Rapid Application Development - Is it Really a Need of Today?

Rapid Application Development (RAD) is a software development methodology. In... Read More

Software Process Improvement -A Successful Journey

Background: For many organizations like ours, the interim target of... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

Is Your Family Protected?

When you think... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

What is Groupware?

Vince Lombardi once said that, "The achievements of an organization... Read More

Microsoft Great Plains Nationwide Remote Support

ERP Consulting industry is on the way to serve clients... Read More

Bill of Lading ? Custom Reporting for Microsoft Great Plains ? Overview for Consultant

Bill of Lading is required report for Logistics and Freight... Read More

Make or Break Factors - When Considering Estimating Software

Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

Google Brings the Earth to Your Desktop

Google Inc. has launched a new software package that allows... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More

Microsoft Great Plains international implementation ? USA / Mexico ? overview for consultant

Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More

Benefits of Integrating Online Chat Software with CRM

Customer Relationship Management (CRM) is a strategy and processes used... Read More

CRM 101: Customer Relationship Management for Beginners

Customer Relationship Management, abbreviated "CRM," is the term for a... Read More

Passwords Used In Microsoft Word Documents

You would like to protect your documents, wouldn't you? Reasons... Read More

Anti-Virus Software

Anti-virus software is used to find, remove or fix files... Read More

Backing Up And Restoring Your MySQL Database

If you've been using MySQL database to store your important... Read More

Introduction To ISDN, Part II

In the previous ISDN article, we looked at how and... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More