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:

The Register

Ford recalls 433000 cars: Software bug breaks engine off-switch
The Register
Ford is recalling 433,000 of its cars as they suffer from a software bug that could prevent drivers from turning off their engines. The affected models include some 2015 Focus, C-MAX, and Escape vehicles. If you're unlucky, turning the ignition key to ...
Ford Recalls 432K Cars Because of Software ProblemABC News
Ford Recalls 432000 Cars Over Software ProblemDailyFinance
433000 Ford cars to be recalled because of software bug – would you have ...We Live Security (blog)
all 208 news articles »


Google rushes to fix software that tagged photo with racial slur
Google is also working on longer-term improvements in the use of words to label photos and its image recognition software, which automatically generates the tags. "Lots of work being done, and lots still to be done. But we're very much on it," Zunger ...
Google Photos Tags Two African-Americans As Gorillas Through Facial ...Forbes
Google Photos' 'racist' error highlights facial recognition's limitsDigital Trends
Google Scrambles After Software IDs Photo of Two Black People as “Gorillas”Slate Magazine (blog)
all 328 news articles »


Cisco leaves its Unified CDM software open to hackers
The vulnerability was fixed in the Unified CDM software version 4.4.5, but hotfixes are also available for versions 4.4.3 and 4.4.4 for customers with support contracts. The issue was discovered by Cisco during internal security tests and the company ...

and more »


Microsoft's Worldwide Telescope astronomy software is now an open-source ...
Microsoft has boosted its open-source credentials by making the code for its Worldwide Telescope (WWT) software available on GitHub for anyone to use. Microsoft first revealed plans to make WWT freely available under the MIT license back in January ...

and more »


How Docker Escaped Near-Death To Become Software's Next Big Thing
He took all the Microsoft-based code for an e-commerce website, put it through Docker's software and had it running on rival Linux servers in seconds. The developers in the crowd cheered at a feat that until then would have taken days or weeks ...

and more »

BBC News

Samsung faces legal action over phone software
BBC News
Samsung is being taken to court in China over the software it loads on to its handsets. A Chinese consumer protection group launched the legal action over the default apps or "bloatware" found on Samsung phones. It said many people did not want the ...

and more »

International Business Times UK

Google throws open DeepDream software to create bizarre images
International Business Times UK
You can now make your own neural network-inspired images, as weird and creative as you like, using Google's DeepDream software available on its blogspot. Two weeks ago, the company had released the product of its experiment in bizarre ...
Google opens up Deep Dream software, terrifies worldIT PRO
Google unleashes machine dreaming software on the public, nightmarish
Google open-sources its software for making trippy images with deep learningVentureBeat

all 15 news articles »

City, county settle lawsuit with software company
Superior Telegram
MADISON — The city of Superior and Douglas County have agreed to pay a combined $260,000 to settle a lawsuit brought by a company whose software neither government could implement, local officials said this week. The city and county entered a ...

Tech Times

Software For Spotting Latest Fashion Trends Replaces Focus Groups
Tech Times
Fashion retailers are using new software to predict the latest fashion trends based on shopper's preferences and picks as communicated via online surveys. Formerly, the companies used focus groups to perform the same function. Picking the right styles ...

Intel: Departure of James a Good Thing After Software Botch, Says Citi
Barron's (blog)
Following Intel's (INTC) announcement earlier today of a raft of personnel changes, Christopher Danely with Citigroup reiterates a Neutral rating on the shares, and a $32 price target, writing that the departure of Renée James, who ran the software ...

and more »
Google News

Snort for Network IDS

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

ERP for Large Corporation ? New Selling Strategy

Our opinion is based on our Microsoft Business Solutions Great... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

In this small article we will be looking at the... Read More

Destination: Desktop for Google

First we had the original Google search that evolved into... Read More

Making The Decision To Automate Your Software Testing

Not every software testing project can or should be automated.... Read More

Change Your Word Docs in Record Time!

Anyone who has ever used Microsoft Word knows that it... Read More

Microsoft Great Plains Implementation for Large Corporation ? Overview for VP IT

Microsoft Business Solutions Great Plains was historically designed to serve... Read More

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles... Read More

Who Is Minding Your Sensitive Data?

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

Microsoft Great Plains Integration Manager ? Working With Text File

Microsoft Business Solutions main middle market ERP application - Microsoft... Read More

Four Desktop Tools To Drastically Increase Your Productivity

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

Is Software Tester a Most Infamous Person in a Software Project Team?

The fact that a software tester is a most infamous... Read More

Razzle Dazzle Them

Once upon a time not so long ago, there was... Read More

Dreamweaver vs FrontPage

There are two major WYSIWYG(What You See Is What You... Read More

Explore the Internet in a Whole New Way

For a long time now Microsoft's Internet Explorer has ruled... Read More

Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

Usually workflow & messaging is realized in CRM and then... Read More

Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

If you are software developer or database administrator - we... Read More

COSMIC: A Small Improvement on the Symons Method

The COSMIC FP (function point) software quality metric, is no... Read More

Lotus Notes Domino and Microsoft CRM Integration

Well, even if the combination might look very unusual, we... 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

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

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

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More