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:


Forensic software gets around Apple's iCloud security features
PCWorld
A Russian software company has updated its forensic software to work-around the security features Apple recently added to iCloud and increased what information can be extracted from the cloud storage service. Elcomsoft's Phone Breaker software now ...

and more »

Top-Ranked Personal Finance Software
Investopedia
First, we'll take a look at the four top downloadable software packages. Then, we'll explore a free online-only package available that does some data mining of your information in return for free access to its financial tools Finally, we introduce you ...


Wall Street Journal

The Joys and Hype of Software Called Hadoop
Wall Street Journal
Underpinning the big-data craze is Hadoop, a software suite named for a toy elephant belonging to the son of a Yahoo programmer who helped develop the software in the mid-2000s. While traditional databases like those offered by Oracle Corp. store ...

and more »

SmartUQ Raises $1.8M For Simulation Analytics Software
Xconomy
The company's software performs what Qian calls “simulation analytics.” Essentially, it can rapidly run complex tests with multiple variables for customers that want help designing products or making business decisions. The software could allow an ...

and more »

Phys.Org

New Minecraft modding software revolutionizes the way we teach kids coding
Phys.Org
A new e-learning software, developed by San Diego education start-up ThoughtSTEM, teaches K-12 students how to code by allowing them to write mods ("modifications") to the popular video game, Minecraft. The software, called LearnToMod, was recently ...


Philly.com

Chittaranjan S. Shah, 66, software engineer
Philly.com
Chittaranjan "Chitu" Shantilal Shah, 66, of Norristown, an engineer and respected member of the Indian community in the Pennsylvania suburbs, died Monday, Dec. 15, of unknown causes after collapsing at his home. Born in Mumbai, India, Mr. Shah earned ...


Forbes

New Software Allows Fleets Of Drones To Be Controlled By The Cloud
Forbes
The future of the drone industry will be typified by a mixture of hardware and software innovation. Entrepreneurs working on the hardware side of drones have proven they can rapidly innovate and push their products to market. The products are easy to ...


Spectrum Equity to buy real estate software company ExactBid-sources
Reuters
Dec 17 (Reuters) - Tech-focused private equity firm Spectrum Equity is acquiring control of ExactBid, a private company that makes software for the commercial real estate sector, according to sources close to the matter. More than 30 percent of U.S ...

and more »

CBC.ca

OPSEU seeks injunction on social assistance software problems
CBC.ca
The Ontario Public Service Employees Union will ask the courts to intervene to stop the province from using flawed new social assistance software to process Ontario Works and Ontario Disability Support payments. The union announced Wednesday that it is ...
City wants province to pull plug on troubled Ontario Works softwareHamilton Spectator

all 25 news articles »

Sheriff's Office to upgrade software
Graham Leader
The deal amounts to $14,390, a bill due by April 1, 2015, and breaks down to 11 full-time COPsync software licenses at $99.95 apiece for a total of $1,099.45 a month, and five COPsync software reserve officer licenses at $19.95, or $99.75 a month.

Google News

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

Microsoft Great Plains BR: Bank Reconciliation

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Software Process Improvement -A Successful Journey

Background: For many organizations like ours, the interim target of... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

Internet Relay Chat - A Basic Introduction

What is IRC?IRC is Internet Relay Chat. It is a... Read More

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

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

Ukraine: a Prospective Player on the World Software Outsourcing Market

The destruction of the Soviet Union about 15 years ago,... Read More

The Dreaded Paper Label - Should it be Used?

While paper labeling CDs and DVDs may appear to be... Read More

Preventive Maintenance Software Companies

Several software companies design programs for preventive maintenance. Most of... Read More

10 Steps To Secure And Manage Your Passwords

Passwords protect your most sensitive personal, financial and business information.... Read More

Builders Beware

Which Type of Shop Can Rely On A Home Built... Read More

IT Strategy for Midsize Business: Microsoft vs. Java, Great Plains & CRM

Midsize business or non-profit organization should decide if one-vendor solution... Read More

7 Things to Consider Before Buying Small Business Accounting Software

The world of small business accounting software can be a... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Should I Use Windows Update?

Should one use Windows Update?This topic has good and valid... Read More

Microsoft Great Plains Distribution, Barcoding, Consignment ? overview for consultant

Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More

Not All Project Management Software is Created Equal

The purpose of Project Management Software is to provide an... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More

Separate Anti-Keylogging Protection: Who Needs it Most?

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

Microsoft Great Plains Integrations - Tips for Developer

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

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Are You Waiting for Microsoft Longhorn Operating System

I love new technology. I am still ready to wait... Read More

Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document... Read More

Troubleshoot Windows with Task Manager

Task Manager is a Windows system utility that displays thetasks... Read More