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:


Forbes

Commercial Real Estate, There's Now Software For You, Too
Forbes
It's time for commercial real estate to get the tech startup treatment, ready or not. New York startup Hightower is raising cash fast to roll out its software that the company claims can finally improve the workflow of the insulated and arcane world of ...
Hightower, a software tool for commercial real estate, raises more cashNew York Business Journal (blog)

all 11 news articles »

Stacking up Open Clouds
ZDNet
The logic is understandable - how can a software with source code that can easily be viewed, accessed and changed have even a modicum of security? opensource-security-question Open source software is safer than many believe. But with organizations ...


Upgraded software coming to WV library consortium
Bellingham Herald
Library Commission technical staff recently installed the Northern Library Network's server in the Clarksburg-Harrison Public Library in preparation for the software upgrade. In June, they set up the Mountain Library Network's server in the Raleigh ...

and more »

Economic Times

Microsoft to unveil new Windows software: Report
Economic Times
The US software titan could hold an event as early as the end of September to provide a look at a version of what is expected to be called "Windows 9," according to technology news website The Verge. The introduction will be aimed at developers behind ...

and more »

TechCrunch

Tesla Model S Software Update Brings iPhone Unlocking And Ignition Start
TechCrunch
Tesla owners have been looking forward to OS 6.0, a software update for their vehicles, for a while now, but it's finally rolling out to vehicle owners, reports Electrek. The system adds a bunch of new features for Model S vehicles, including a new ...
New Tesla Model S Software Upgrade Turns Your Phone into the Keyautoevolution
Tesla Motors Inc (TSLA) updates software to support iPhone unlocking and ...Pulse 2.0

all 108 news articles »

XRay software reveals how Gmail, Amazon and YouTube leverage your ...
Gizmag
A new software tool developed at Columbia University is providing valuable insights into how some very popular websites make use of the sensitive data they collect from their users. The software could help sniff out potential abuses from advertisers ...

and more »

Wired

Software — and a Woman — at the Heart of Lunar Triumph
Wired
In fact, the lunar landing was one of the first times that software was ever entrusted with such a mission-critical, real-time task. And the application development work for that feat was placed in the hands of Margaret Hamilton — who had taught ...


V3.co.uk

Salesforce lifts forecast on strong demand for cloud software
Reuters
Spending on enterprise resource management and customer relationship management has been particularly strong. Research firm IDC expects ERM and CRM software sales to grow 20 percent at a compounded annual rate every year from 2013 to 2018.
Salesforce.com, inc. (NYSE:CRM): 10th Fastest Growing Software Company ...BasicsMedia
Salesforce posts $1.32bn revenue driven by software servicesV3.co.uk

all 94 news articles »

BetaNews

Citrix software aims to solve storage/virtual desktop performance problem
Network World
Citrix has updated its virtual desktop and appliance software with a goal of alleviating one of the biggest problems that come with a VDI deployment: Storage. It's common for centralized storage pools to hinder the performance of virtual desktops and apps.
Run Windows software on Google's Chromebooks with Citrix Receiver for ChromeBetaNews

all 25 news articles »

Technical.ly Philly

How FastFWD company Algorhythm is fighting recidivism with software
Technical.ly Philly
In a pilot funded by both state and federal funds, the Kensington-based company is analyzing two years' worth of data — 140,000 cases — to develop software that can help the state figure out who is most at risk for getting arrested again — and what ...

and more »
Google News

Implementing Microsoft CRM: setup and configuration ? notes for IT specialist

Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More

Marketing Your WinRunner Team

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

Basic Tips and tricks for Windows XP

Running Applications in Compatibility Mode With Windows XP, you can... Read More

Microsoft Great Plains: Service Business Customization & Integration Example

Microsoft Business Solutions Great Plains might be considered as ERP... 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

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Great Plains Dexterity Programming ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Adware and Spyware Blockers

The most important things you can do for your computer... Read More

Free Software for Newbies and Web Developers

Here is some free software tools to help you build... Read More

International Support - Microsoft Great Plains VAR/Partner Selection ? Overview for V.P. IT

Looks like Microsoft Great Plains becomes more and more popular,... Read More

eConnect: eCommerce Development for Microsoft Great Plains

Microsoft Business Solutions Great Plains has several options to enable... Read More

Microsoft Great Plains Customization and Development ? Overview for Programmer

When Great Plains Software was designing and developing Great Plains... Read More

Microsoft CRM USA Nationwide Remote Support

Remember old good days when your company probably had Great... Read More

Great Plains Dexterity Customization Options ? Overview For Developers

Looks like Microsoft Great Plains becomes more and more popular,... Read More

QuarkXpress Tips: How to Move Content Between Print and Web Layouts

Since its release in 1987, QuarkXpress had made an immediate... Read More

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

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

Five Tips For A Great Software Demo

Whether you need to close a sale, gather end-user feedback,... Read More

Helping Newbies Understand Professional Software

The Windows registry is a huge database that ensures normal... Read More

Google Brings the Earth to Your Desktop

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

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

Microsoft CRM Implementation ? Fundamental CRM Principles Revision

Microsoft CRM is relatively new player on the now becoming... Read More

Who Is Minding Your Sensitive Data?

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

Spyware Statistics -- Whats New in May 2005?

Although statistics often is blamed for various deadly sins --... Read More

Quick Summary of Basic and Common Linux Commands

There are many commands that are used in linux on... Read More

Microsoft Great Plains IV: Inventory Management

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