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:

Wall Street Journal

Tesla's Risky Over-The-Air Software Program
24/7 Wall St.
Today, we're announcing details about new software being delivered to Model S customers through an over-the-air update. The new features further personalize the Model S ownership experience and help make the car smarter about owners' individual ...
Tesla Motors Releases New Software Suite for Model SWall Street Journal
Tesla software update zaps new features into carsUSA TODAY
Other automakers to challenge Tesla in over-the-air software upgradesReuters
Tom's Hardware -The Westside Story
all 125 news articles »

Iowa's Top Workplaces: Innovative Software Engineering
At Innovative Software Engineering in Coralville, it's not unusual to see employees roaming the hallways with Nerf guns on a Friday afternoon or playing bags in the parking lot. "We have a tremendous work culture. It's a culture of excellence and ...

Paedophiles using £25 stalking software to hack victims
The sinister software is part of an unprecedented array of technology now enabling criminals to spy on people and steal sensitive data. Despite the fact that many calls to police concern social media issues, many officers are still unaware of just how ...

and more »

Visa software tackles fraud at the gas pump
Buffalo News
The payment card giant is rolling out new software aimed at predicting whether it's you or a thief trying to fill up at the pump. The program uses some 500 pieces of data – including a cardholder's transaction history and real-time reports on hot spots ...


Apple's new software iOS 8: Why it is worth installing
Economic Times
The scores of new features in Apple's software update for mobile devices can be boiled down to one word: unity. Many iPhone owners also have iPads and Mac computers, and family members are likely to have Apple devices, too. With the new iOS 8 software ...
iOS 8 update needs 5GB of space so here's how to make roomDaily Mail
Apple Delays HealthKit Software After Discovering Early FlawBloomberg
Apple iOS 8 software bug delays health appsCBS News
Tech Times -The Guardian
all 2,768 news articles »

New police software predicts crime
THV 11
"You know you can't be everywhere all the time, but with this Predictive Policing Software, it gives the officer a heads up as to what may occur," said Sgt. Cassandra Davis, LRPD Public Information Officer. "It lets that officer know, hey this ...

Terrance Paul, Developer of Teaching Software, Dies at 67
New York Times
Mr. Paul, a lawyer and businessman, and Mrs. Paul, a homemaker with a degree in elementary education, though she never taught school, began their software business, Advantage Learning Systems, in 1986 from the basement of their home in Port Edwards ...

and more »


SAP buys expenses software maker Concur for $7.3 billion
FRANKFURT (Reuters) - Germany's SAP (SAPG.DE) has agreed to buy U.S. expenses software maker Concur (CNQR.O) for $7.3 billion in cash, strengthening its position in cloud computing but sending its shares down almost 3 percent on concern over the ...
SAP buys software group Concur for $8.3bnFinancial Times
Software giant SAP buys expenses rival Concur for $7.3bnIrish Independent
SAP To Acquire Expense Software-Maker Concur For $129 Per ShareTechCrunch (blog)
Re/code (blog) -Xconomy
all 336 news articles »

Task of fixing troubled software project falls to new Anchorage CFO
Alaska Dispatch
One week into the job, Anchorage's new chief fiscal officer is rolling out an aggressive push to bring a troubled city software project into line. At an Assembly work session Friday afternoon, Kate Giard, who previously served as chief fiscal officer ...

Software patents are crumbling, thanks to the Supreme Court
The Supreme Court's June ruling on the patentability of software — its first in 33 years — raised as many questions as it answered. One specific software patent went down in flames in the case of Alice v. CLS Bank, but the abstract reasoning of the ...

and more »
Google News

Microsoft Business Solutions Customization Options - Overview for Programmer

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

The Importance of Timely Timesheets

Whether you are a small consultancy firm, a medium sized... Read More

Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Photoshop Files and Formats

People often ask me: What image file formats will Photoshop... Read More

Software For Your Hard-Drive

All your software is stored on a hard-drive. But how... Read More

Microsoft Update - 5 Reasons to Update Service Pack 2

Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More

Windows Screensavers Explained

In this article you will find some background information about... Read More

Groove Network. Are you in it?

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

Passwords Used In Microsoft Word Documents

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

Where to Find Free Fleet Maintenance Software

Costs of fleet maintenance software can vary widely. It is... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

If there still are few unprotected computers left, I haven't... Read More

What is Software Piracy?

There are several kinds of software piracy. The bottom line... Read More

Antivirus Software ? Get The Bugs Before They Get You!

You turn on your computer, and it doesn't look quite... Read More

Dont Choose Adobe When Working With PDF

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

Microsoft Great Plains eCommerce: overview for developer

Microsoft Business Solutions Great Plains was designed back in the... 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 Integrations - Tips for Developer

In this short FAQ style article we would like to... Read More

Corporate Accounting System: Microsoft Great Plains ? Overview

Corporate ERP/MRP selection might be tough one, especially considering very... Read More

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... 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

SQL Administrator Skills Required to Support Microsoft Great Plains

Microsoft Great Plains is becoming more and more popular and... Read More

The Software 2005 Conference - A Review

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

History of Java

The java programming language is becoming more and more popular... Read More

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

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