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:

From Mainframe to the Cloud: The History of ERP Software
Enterprise resource planning (ERP) software is one of the oldest software categories out there. In fact, if you trace its lineage back to the original MRP specs outlined by APICS, ERP software dates back more than fifty years. As a result, ERP software ...


​Open source leader 'livid' at TPPA software patent capitulation
The president of the New Zealand Open Source Society is "livid" that New Zealand's Trans Pacific Partnership Agreement negotiating team appears to have already conceded the country's newly-minted ban on software patents.

The Register

Be wary of that Russian. He might HAMMERTOSS a software nasty at you
The Register
Security researchers have blown the lid on another Russian cyberspy crew, rated as the most sophisticated yet by security firm FireEye. APT29 – which has only been operational since around the end of last year – uses a strain of malware called Hammertoss.

and more »


US likely to scale back planned limits on intrusion-software exports
The U.S. Department of Commerce said on Wednesday it will revise regulations intended to restrict the export of software that can be used to break into computers and smart phones. An initial draft of the regulations, published in May, attracted ...

and more »

Daily Mail

Genetic Access Control software checks genetic profile of users developed
Daily Mail
Websites could soon block people from accessing their content due to their race or gender following the development of software that checks the genetic profile of users. The Genetic Access Control application works by requesting access to information ...

Syracuse councilors: No money for software until our computers are back on
SYRACUSE, N.Y. – The Syracuse city council today tabled a request to pay $125,000 toward new software because some councilors are angry that their own access to city computers has been shut off. The councilors, who lost computer access July 1 after ...


No Tumor Left Behind: FDA Clears NeuWave Software for Procedures
NeuWave Medical, a Madison, WI-based maker of medical devices that use microwave energy to zap tumors, has received FDA clearance to sell new software that it says can help doctors more easily monitor each step of the procedure, and more confidently ...
NeuWave Medical Inc., Receives FDA Clearance for Ablation Confirmation SoftwareBusiness Wire (press release)

all 2 news articles »


Tableau Software posts $150M in Q2 revenue, shares slump as growth rate slows
Tableau Software today reported $149.9 million in revenue, a 65 percent increase over the same period last year as the company added 3,000 new customers. That beat analysts expectations of $141 million, but it was a slower growth rate than the first ...
Tableau Software (DATA) Tops Q2 EPS by 3c, Revenue
Why Shares of Tableau Software Got Crushed WednesdayMotley Fool
Tableau Software (DATA) Earnings Report: Q2 2015 Conference Call
Nasdaq -Benzinga -Dakota Financial News
all 41 news articles »

Popular Science

Smart Rifle's Software Can Be Hacked To Shoot Off-Target
Popular Science
TrackingPoint's rifles are clever pieces of technology, merging cameras, sensors, and Linux software with a sniper rifle to create a gun very good at hitting targets far away, even when fired by an untrained shooter. Primarily marketed to hunters, last ...
Hackers can crack the self-aiming rifle to change its targetEngadget

all 40 news articles »

RIAA and Friends Accuse CNET of Hosting 'Pirate' Software
The groups are not happy with CNET's as the software portal offers access to various YouTube downloaders and other stream ripping tools. In a letter to Les Moonves, CEO of CNET's parent company CBS, they accuse the download portal of ...

and more »
Google News

How a Bug Challenges to a Software Professional

It is really interesting that a bug can create problem... Read More

When is a Software Engineer Not a Software Engineer?

The title of "software engineer" has got to be among... Read More

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More


In order to implement VLANs in a network environment, you'll... Read More

Cisco CCNA Certification: Becoming A Truly Valuable CCNA.

I've been active in the Cisco Certification track for four... Read More

Introducing GRML

Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Microsoft CRM Modification ? Overview for IT Specialist

Microsoft CRM is now on the scene and it is... Read More

Anti-Virus Software

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

Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ? Future Directions

IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

Software Process Improvement -A Successful Journey

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

C++ Tutorial 2, Input and Variables

This is the tutorial where we really get into programming.... Read More

Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

Microsoft CRM is winning market share step-by-step from such the... Read More

OS 101: Suggestions for Choosing an Operating System

An operating system (abbreviated OS) is essentially the path through... Read More

Microsoft Great Plains POP: Purchase Order Processing ? Overview For Consultants

Great Plains Purchase Order Processing (POP) module makes up one-third... Read More

The Software 2005 Conference - A Review

The Software 2005 conference is now a wrap. This conference,... Read More

Hubris - Definition: Microsofts Passport

Before September of 1995, Microsoft ignored the Internet because their... Read More

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

Ok... Where to start?Well, I guess I will start at... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Notes StickyNote 9.0, you can create beautiful 3D notes... Read More

Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO

Microsoft Business Solutions Great Plains as new ERP for multinational... Read More

Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management

Let's first look at your ERP system selection (without Retail... Read More

Fast Car Knoppix

Small can be beautiful! Working with Knoppix for the past... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More