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:


Software Is Dominating Venture Capital Investments In 2014
Software deals netted out 42% of all dollars invested in the first quarter, with biotechnology receiving 11%. VCs invested $816M in IT Services or 9% of all dollars, making this the third largest investment category. Interest in IT Services continues ...

and more »

Economic Times

Tata Consultancy Services, Mitsubishi Corp to form software services co
Economic Times
NEW DELHI: India's largest software services firm Tata Consultancy Services (TCS) has signed an agreement with Japanese major Mitsubishi Corporation to form a single IT services unit, the company said today. The merger, in which TCS will hold 51 per ...
TCS, Mitsubishi to form software services companyIndian Express
Software leaders shineBusiness Standard

all 37 news articles »

Nashville Software School hopes to crack the code
The Tennessean
Since opening in fall 2012, the pool of applicants has remained strong as career changers and those early in their professional lives seek skills in the rapidly growing software programming field. Even with an influx of programs popping up nationally ...

Intel Patents: A Diverse Story of Software Innovation
This system relies on a software construct, referred to as a “circle of kinship,” which is capable of maintaining active records for who may access a vehicle, as well as any restrictions. For example, the system could enable the monitoring of teen and ...

Clarksville Software User's Group to meet Wednesday, April 23rd
Clarksville Online
Clarksville Software Users Group Clarksville, TN – The first meeting of the Clarksville's Software User Group will be Wednesday, April 23rd, 2014 at GetSomeCoffee off exit #1. The user group is a collection of professionals and hobbyists, usually ...


Report: Nike Abandoning FuelBand Hardware Development for Software
PC Magazine
That said, Nike's focus on the software side of fitness tracking — especially given the imminent release of the API for its Nike+ software platform — combined with the fact that Apple's looking to play in the space with its oft-rumored iWatch device ...
Nike Ditching FuelBand Hardware To Focus Solely On SoftwareTechnoBuffalo
Nike reportedly retiring FuelBand, training eyes on fitness softwareTechRadar UK
Nike reportedly killing the Fuelband to focus on fitness softwareEngadget
BostInno -Gamenguide -Mobile & Apps
all 127 news articles »

The North Bay Nugget

Debugging software like tapping trees
The North Bay Nugget
Nick Matthews says trying to find bugs in computer code is a lot like taking a snowmobile ride in the bush to check his family's maple sap lines. “It's all about problem solving,” said Matthews, a software engineer for Google Canada, Saturday. His ...

and more »

The Guardian

Heartbleed Software Snafu: The Good, the Bad and the Ugly
Scientific American
Nine days after the announcement of the Heartbleed vulnerability in OpenSSL, software widely used to secure Internet traffic, we have a much better understanding of the extent of the damage. (Thanks to the invaluable xkcd Web comic, we also have a ...
Android phones have “Heartbleed” software bugColumbus Dispatch
Local expert: After Heartbleed, rethink passwords, softwareDayton Business Journal
Heartbleed Exposes a Problem With Open Source, But It's Not What You ThinkMashable
InfoWorld (blog) -The Guardian
all 1,868 news articles »

Vetter Software Announces Record First Quarter Results
PR Web (press release)
Vetter Software, the leading provider of cloud practice management software for veterinarians, today announced record results for the first quarter of 2014, highlighted by an increase in clinic count of more than 100% and revenue growth of more than ...

and more »

Geeky gadgets

OnePlus One Software UI Shown Off
Geeky gadgets
The handset will be powered by Cyanogenmod 11S, based on Android 4.4 KitKat. For those of you who want to see how the UI looks like, the folks at OnePlus have shared some screenshots of the software running on the highly anticipated OnePlus One.

and more »
Google News

Need of Document Management System (DMS)

Document Management or Enterprise Information Management is perhaps one of... Read More

Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More

Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

Resume Software ? Advantages Revealed

The various resume software offered, particularly on the internet, can... Read More

Review on QuarkXpress 6.0

After almost two decades of existence, Quark has become the... Read More

Microsoft Great Plains Remote Support - Overview

Microsoft Great Plains is now standard mid-market ERP application, serving... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Introduction To ISDN, Part III: PAP

Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we... Read More

Dont Choose Adobe When Working With PDF

While Adobe is the most known maker of PDF tools,... Read More

Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

It would be easy to think, like most people apparently... Read More

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist

Let us give you - developer some hints in the... Read More

Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More

Microsoft Navision Database Selection: C/SIDE or MS SQL Server - Overview For IT Specialist

There are certain pluses and minuses in both cases and... Read More

Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

... Read More

Freight Forwarding ERP: Microsoft Business Solutions Great Plains customization & setup ? overview

Microsoft Great Plains may be recommended for international freight forwarding... Read More

Passwords Used In Microsoft Word Documents

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

SyncUp ? A File/Folder Synchronizer For Windows

SyncUp, a file synchronizer is designed to assist the home... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Microsoft Great Plains eCommerce ? Stored Procedures Approach

Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More

Microsoft Great Plains ? Licensing & Product Versions

Current Microsoft Business Solutions Great Plains has more that 10... Read More

CROOK: A Methodology for the Refinement of Forward-Error Correction

Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More

Groove Network. Are you in it?

If you are in a business that passes documents around... Read More

Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting

Manufacturing in the USA is far away down from mid... Read More

Microsoft Great Plains Data Conversion ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More