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:

Jama Software secures $20 million venture round, begins hiring surge
Portland-based Jama Software announced a $20 million venture round Monday, the latest in a string of large investments in Oregon tech businesses. The money will fund new features for Jama's product-planning software and finance an ambitious hiring plan ...
Jama Software Scoops Up $20M To Fund To Modernize Software DevelopmentForbes
Portland's Jama Software raises $20M to help companies with product ...GeekWire
Jama Software lands $20MPortland Business Journal (blog)
Xconomy -Marketwired (press release)
all 11 news articles »


Geek deals: 50% off tax preparation software from H&R Block
If tax season makes you anxious, here's the solution. H&R Block has easy-to-use tax preparation software on sale, and with it comes unlimited access to expert tax advice. Even better, we have an exclusive coupon code that lets you buy H&R Block's ...
ET deals: 50% off H&R Block tax softwareExtremeTech

all 3 news articles »

Wall Street Journal (blog)

Citi Bike Gets a Software Update Ahead of Planned Expansion
Wall Street Journal (blog)
Citi Bike got a software upgrade last weekend, the latest step in an overhaul promised by the new operator of New York City's bicycle-sharing system. The back-end software's replacement prompted the company that runs Citi Bike to take the system ...
Citi Bike Installs New Software, Laying the Foundation for Better ServiceStreetsblog New York (blog)

all 14 news articles »

Portland Business Journal

Act-On Software hires CFO from Jive, names two other execs
Beaverton marketing technology startup Act-On Software announced three new top executives Monday - including a new chief financial officer who previously had a top job at Jive Software. Act-On is among the best funded young companies in Oregon history ...
Act-On Appoints Chief Financial Officer and Expands Management TeamMarketwired (press release)

all 5 news articles » (blog)

India backs open source software for e-governance projects
Federal and state agencies must make it mandatory for suppliers to give OSS a preference over proprietary or closed source software while responding to requests for proposals. ”Suppliers shall provide justification for exclusion of OSS in their ...
Govt announces open source software policyEconomic Times
Use Of Open Source Software Now Mandatory In Govt Offices As Per New Policy! (blog)
India wants to use more open-source software to build e-governance appsThe Next Web

all 23 news articles »

iT News

BlackBerry Drops 8%: RBC's Upbeat, But Street Mostly Still Skeptical on Software
Barron's (blog)
During an appearance on CNBC on Friday, CEO John Chen defended the company's progress with its “BES 12” software for enterprises, part of what Chen expects will be $600 million in software revenue. “BES 12 is one of the highlights, it is the only ...
BlackBerry To Double Software Revenue In FY 2016 (BBRY)Seeking Alpha (registration)
BlackBerry reports surprise profitiT News
Key Takeaways From BlackBerry's Q4 Earnings And What Lies AheadTrefis (registration)
all 78 news articles »

Columbus Dispatch

Software moves traffic court online
Columbus Dispatch
Michigan startup Court Innovations has developed a software solution that allows drivers to settle traffic violations by negotiating in a virtual environment instead of going to court to fight tickets. The model, which can also extend to other minor ...

and more »

Droid Life (press release) (blog)

T-Mobile's Galaxy S6 and S6 Edge Receive First Software Update
Droid Life (press release) (blog)
Receive your Samsung Galaxy S6 or S6 Edge from T-Mobile already? Expect a software update almost immediately. According to T-Mobile support, a day 1 update is supposed to be ready for each, an update that wipes out some bugs and brings some ...
T-Mobile Galaxy S6 and S6 Edge get first OTA software updateTmoNews
Galaxy S6 and S6 Edge handsets on T-Mobile get their first software updatesTechnoBuffalo
Samsung Galaxy S6 software is as bloated as ever, and storage is a big problemTechnologyTell
Android Headlines - Android News -Newstactics
all 531 news articles »

GW Hatchet (subscription)

In quest for donors, business school adds data mining software
GW Hatchet (subscription)
The GW School of Business will start to use data mining software in a push to better connect with prospective students and build a base of potential donors. California-based Marketo announced last week that it will help officials at the business school ...

Major software companies bamboozle local authorities with audits
Robin Fry, co-founder of Cerno and author of the report, said: "A large proportion of IT budgets is spent on software from major suppliers. Local government organisations use massive databases. They try to negotiate on pricing, but the fundamental ...

Google News

Can You Calculate Complex Financial Calculations?

Are you a whiz at calculating financial information? Not the... Read More

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

What is installation in the language of technology? Installation... Read More

Microsoft Great Plains 8.0 Brazilian Version ? Overview For International Consultant

Microsoft Great Plains has substantial mid-market share in the USA... Read More

Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

Microsoft Business Solutions Great Plains has I'd say end user... Read More

Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

Microsoft Great Plains and Microsoft CRM become more and more... Read More

Inherent Dangers Of File Sharing Via The Internet.

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

Editing Your Photos Using Microsoft Picture It Publishing Platinum 2002 - A Great Dinosaur

I started using PIP (Picture It Publishing) Platinum 2002 right... Read More

Microsoft Great Plains Food Processing ? Implementation & Customization Highlights

Microsoft Great Plains might be considered as ERP platform to... Read More

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More

Demand More From Your Lead Tracking Software

An integral part of any quality CRM system is lead... Read More

Reduce Pop-ups and Annoying Ads

There is many things more frustrating than surfing a website... Read More

Basic Steps To Optimize Your Internet Security

After seeing many people complain about their weak Internet security... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as... Read More

Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

Microsoft Great Plains serves majority of US based horizontal and... Read More

Microsoft Great Plains Jewelry ? Implementation & Customization Overview

Each Industry and market niche has business specific and unique... Read More

Databases ? How We Love to Hate Them!

You've finally created databases that you can actually use to... Read More

Google Brings the Earth to Your Desktop

Google Inc. has launched a new software package that allows... Read More

Free PDF Publishing Software

In a previous article, I wrote about OpenOffice... Read More

7 Things to Consider Before Buying Small Business Accounting Software

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

OS 101: Suggestions for Choosing an Operating System

An operating system (abbreviated OS) is essentially the path through... Read More

Configure Windows Indexing Service for Performance

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

Crystal Reports for Microsoft Great Plains ? Overview for Developer

Microsoft Great Plains is main accounting / ERP application... Read More

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

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

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More