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:


Tech giants give millions to support free software in wake of Heartbleed
SAN FRANCISCO - A group of companies that reads like a who's who of technology are contributing $300,000 each to underwriting improvements to critical open source programs used by millions. It will be called The Core Infrastructure Initiative. The list ...
Cisco, Microsoft, VMware, and other tech giants unite behind critical open ...ZDNet
Heartbleed causes tech giants to unite over open-source software
Heartbleed response: Tech giants to fund OpenSSL, other projectsTechTarget
Telemanagement -Washington Post
all 145 news articles »

ShopKeep's Point Of Sale Software Rings Up $25 Million
With its latest $25 million financing, ShopKeep POS has come a long way from being the cobbled together point of sale software service for a single wine shop in Brooklyn's leafy Ft. Greene neighborhood. The company's history began six years ago with ...
ShopKeep's Point of Sale Software Raises $

all 18 news articles »

Washington Post (blog)

64000 software engineers have settled with tech companies over wage collusion
Washington Post (blog)
Tens of thousands of software engineers have reached a settlement with major tech companies including Apple, Google, Intel and Adobe in a high-profile class-action lawsuit over poaching and lost wages. The terms of the deal will remain confidential ...

and more »

Microsoft profit slips; software, Surface help sales
Microsoft Corp. said its fiscal third-quarter profit declined 6.5%, dragged down by slumping personal-computer sales and a sales-boosting adjustment a year earlier for software upgrades. The earnings scorecard is the first under Satya Nadella, the ...
Microsoft Earnings Preview: Software Giant Transitions From Value To GrowthSeeking Alpha
Microsoft profit drops but devices, consumer products help resultsIDG News Service

all 326 news articles »

Warburg Pincus Buys Compensation Software Service PayScale For Up To ...
Making its fourth acquisition of a technology company in fewer than three weeks, private equity investment firm Warburg Pincus is announcing that it has bought compensation software services vendor PayScale in a deal worth up to $100 million. In the 14 ...

and more »

HTC One (M8) gets treated to a minor software update
... based Android 4.4.2 with the home backed Sense 6.0 UI on top. The new firmware size is about 150 MB and is already rolling out. If you haven't received any notification, then you can check for the update manually by visiting Settings > About ...

and more »

Man allegedly pirated Kodak Prinergy Evo software
Rochester Democrat and Chronicle
An Iranian man has been charged with fraud after allegedly selling unauthorized, pirated copies of Kodak software. According to a criminal complaint, Navid Salehvaziri, 32, of Tehran, Iran, was arrested in Virginia, and appeared Thursday before a U.S. ...
Feds charge Iranian with pirating Kodak softwareWHAM
Police: Iranian man develops knock off website to sell pirated copies of Kodak ...News 10NBC

all 3 news articles »

Building A Software Toolkit For Financial Services Nets Tradier $3.1 Million
Tradier's chief executive Dan Raju has spent the past few years pursuing a singular vision — giving developers a toolkit to build trading platforms and financial services apps that easily integrate with brokerages and stock markets. Now, with $3.1 ...

and more »

Internap Rolls Out Network Optimization Software - Delivering All The Shortcuts
Infrastructure vendor Internap has gotten itself a patent for MIRO, routing software that optimizes network traffic such that bits take the shortest, quickest and most effective route between point A and point B. On top of the routing software ...
Internap Rebuilds Patented Routing Software and Content Delivery Network to ...Broadway World
Leading eCommerce Travel Software Provider, Datalex, selects Hybrid IT ...Wall Street Journal
Internap rebuilds patented routing software and content delivery networkCIOL

all 17 news articles »

Doran Jones could bring 150 new software, engineering jobs to the Bronx
News 12 Bronx (registration)
There could be 150 new software testing jobs by this fall. (4/24/14). THE BRONX - Software consulting company Doran Jones is building an office in an East 138th Street facility. The new office could bring up to 150 new software and engineering jobs to ...

Google News

Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

Microsoft Business Solutions Great Plains is written in Great Plains... Read More

Partitioning, Formatting and Reinstalling in Windows 98

Formatting and reinstalling windows 98 is very easy if you... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

How to Get The Best Accounting Software For Your Small Business

Buying accounting software is a major investment. It's an important... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

An Introduction to .NET Framework

.Net Framework is a platform or development environment to seamlessly... Read More

Microsoft RMS Customization ? PO Items Receiving in Great Plains

Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More

What is Software Piracy?

There are several kinds of software piracy. The bottom line... 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

Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

As we could imagine, if you are reading this article... Read More

Snort for Network IDS

What is Snort?Snort is an open source network intrusion detection... Read More

Data Quality Best Practices for

Executive SummaryAn effective plan for entering, cleaning and updating the... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

Twelve Things You Should Know to Save on Computer Software

Do you want to get quality software at a reasonable... Read More

Microsoft and Webmasters

Does Microsoft care for WebmastersIt's always been a problem with... Read More

Microsoft CRM in Latin America: Implementation, Customization, Support ? Overview for Consultant

Microsoft Business Solutions CRM is present several years on the... Read More

10 Things You Could be Using Photoshop For, But Probably Arent

Most people don't use Photoshop to its fullest capabilities. Here... Read More

Linux Dual Boot-How To Format

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

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Configure Windows Indexing Service for Performance

The Windows Indexing Service provides you with the ability to... Read More

Marketing Your WinRunner Team

It won't matter how effective your WinRunner Team is if... Read More

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

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