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, 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

In The News:


CNET

How to fill out a PDF form without software
CNET
Because it's an online tool, it saves you from having to install any local software -- a plus for corporate users who aren't allowed to do so, and a plus for everyone else because it eliminates the risk of spyware or junkware piggybacking inside PDF ...


Anne Arundel students get free Microsoft software
WBAL Baltimore
"We spend half a million dollars a year or so with Microsoft on software, and license and operating systems, and that kind of stuff and we signed an agreement with them to get Office 365, and OneDrive for employees and what comes with that is this for ...


AACPS students get free Microsoft software
WBAL Baltimore
CHRISTMAS HAS COME A FEW MONTHS EARLY FOR ABOUT 80,000 ANNE ARUNDEL COUNTY STUDENTS. IT IS COMING IN THE FORM OF TECHNOLOGY. THEY ARE GETTING FREE ACCESS TO POPULAR COMPUTER SOFTWARE. TIM TOOTEN ...

and more »

TRAFFIC UPDATE: Software glitch extends Benjamin Harrison Bridge closure
Richmond Times-Dispatch
According to highway officials, the Benjamin Harrison Bridge will remain closed until further notice because a software glitch has locked the brakes on the bridge. The vertical-lift bridge has been closed since Monday morning so crews could replace the ...


Forbes

Inside The Software That Shapes Your Music (And Movies): iZotope RX
Forbes
In the lead-up to this article, I gave you a brief history of digital audio restoration, as well as the reasons behind its widespread use: for music, such software has become increasingly necessary to counterbalance the noisy side effects of the home ...


Upstart

How a software purchase turned a startup into St. Louis' fastest-growing company
Upstart
Ferrell put that money into a software solution built by Creative Anvil — a St. Louis web design firm owned by Rothermich's brother-in-law — that essentially serves as a Travelocity for the distribution industry, matching vendors with customers to ...


TechCrunch (blog)

Progress Software to Acquire Telerik for $263 Million
Wall Street Journal
Last month Progress Software reported stronger-than-expected earnings excluding one-time items such as stock-based compensation impacts and restructuring expenses for the quarter ended Aug. 31. The growth was driven by an increase in revenue and ...
Progress Software Buys Telerik for $262.5M As Buying Spree ContinuesTechCrunch (blog)
As Mobile Software Starts Gaining Enterprise Traction, Progress Software ...Forbes
Progress Software agrees to buy Telerik for $262.5mBoston Globe
BostInno -Top Tech News
all 58 news articles »

Customs Today Newspaper

Audi Recalls 850000 Cars Over Airbag Software Flaw
New York Times
Audi is recalling about 850,000 cars worldwide over a software problem that could cause airbags to fail to deploy properly. The recall of A4s from 2013-15 model years includes about 102,000 cars in the United States. The software problem was caught ...
Audi Recalls 850000 A4 Models to Fix Air Bag SoftwareBloomberg
Audi will recall 102000 A4 cars in U.S. over airbag software glitchAutomotive News
Audi recalls 2740 A4 cars in Ireland for software updateCustoms Today Newspaper

all 60 news articles »

Forbes

Why Digital Audio Restoration Software Is So Important To Music, Film, And TV
Forbes
You might not know it, but within the pro-audio industry, there has been a explosion of software innovation—a torrential downpour of audio plugins has brought about a sea change in the way professionals handle raw, unproduced audio before it ever hits ...


Talkin' Cloud

Microsoft and IBM commit to providing their enterprise software on Azure, IBM ...
ZDNet
"Effective immediately, IBM has updated its policies to allow customers to bring their own license to Microsoft Azure by installing supported IBM software on a virtual machine in Azure. Windows Server and SQL Server are available for use on IBM Cloud ...
IBM, Microsoft Announce Cross-Cloud Enterprise Software PartnershipTalkin' Cloud
Microsoft and IBM partner to bring each other's enterprise software to their ...VentureBeat
IBM, Microsoft Collaborate on Hybrid Cloud OfferingsCIO Today
NDTV -Businessweek
all 144 news articles »
Google News

Things You Can Do With Windows XP!

Did you ever give a thought to the number of... Read More

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

Spyware Protection: A Must for Any Home Computer

Now that spyware is the single most dangerous threat to... Read More

Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

... Read More

Five Reasons for Using an O/R Mapping Tool

So, why should you use any O/R mapping tool? I... Read More

Recovering Microsoft Great Plains Customization ? Tips for IT Director

Remember nice and prosperous Clinton era? When you implemented innovative... Read More

Blind CC (Bcc): Master Its Use When E-Mailing

If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

Linux Secrets

The first thing that you will notice about Linux Red... Read More

Inherent Dangers Of File Sharing Via The Internet.

Cyberspace has opened up a new frontier with exciting possibilities... Read More

Marketing Your WinRunner Team

It won't matter how effective your WinRunner Team is if... 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

String in Java

Handling character strings in Java is supported through two final... Read More

Microsoft Great Plains Integration Manager ? Advanced Techniques

Great Plains Integration Manager scripting and translation - overview for... Read More

Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More

Photoshop Files and Formats

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

Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More

Falling in Love With More Than One Screensaver: The Fun Part

Having from five to ten and more favorite screensavers is... Read More

Microsoft CRM Integration & Customization: SharePoint Document Gateway

MS CRM is very close to document workflow automation, including... Read More

Microsoft Great Plains IV: Inventory Management

Great Plains Inventory Management (IV) module gives your business a... Read More

Groupware: Answers the 5 Questions of Document Collaboration

Every organization which creates collaborative documents, whether they are budgets,... Read More

Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

Lotus Notes Domino is very efficient in electronic document workflow... Read More

Microsoft CRM and No-Frills Cadillacs

In today's business world it's all but impossible to escape... Read More

Microsoft CRM Implementation & Remote Support

We would like to give you pluses and minuses of... Read More

Most Common Ways to Accumulate Spyware (where It is Downloaded to Your PC)

It is possible that if one avoided all sources of... Read More

Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

All of us know that Microsoft bought former Great Plains... Read More