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:


KSAT San Antonio

Sketch software helping law enforcement catch suspects
KSAT San Antonio
New technology is lending a hand when it comes to solving crimes and it's done through new software that's essentially the eyes of the victim. For 32 years, sketch artist Lois Gibson has been scratching out composite drawings of the faces behind crimes.


Reconnaissance code on industrial software site points to watering hole attack
InfoWorld
Attackers have rigged the website of an industrial software firm with a sophisticated reconnaissance tool, possibly in preparation for attacks against companies from several industries. The incident was detected last week by researchers from security ...
Industrial software website used in watering hole attackCSO Online

all 14 news articles »

ASG Software Solutions Seeks Buyer
Wall Street Journal
Software firm ASG Software Solutions, which has had trouble repaying its debt, is looking for a buyer, according to people familiar with the matter. The privately held software company, once known as Allen Systems Group, has hired an investment bank to ...


Software Licensing: Move From Defense To Offense
InformationWeek
Look at the software in your organization in three ways: software you've purchased, software you've installed, and software that employees actually use. These are three distinct lists that can get surprisingly out of sync, and it's never good when that ...

and more »

This Software Lets You Spy on Other People's Snapchats
Betabeat
Surveillance software company mSpy has added a Snapchat feature for all of your stalking needs. Previously, mSpy allowed parents, employers or jealous partners to load the software on their targets' phones, then watch all of their phone activity from ...


5 tips on migrating to open-source software
TechRepublic
Yes, you'll certainly find a much larger selection of open-source software for the Linux platform, but both Windows and Apple also enjoy a good number of titles. Regardless of what Free Open Source Software (FOSS) you need to use, you might not always ...


CoreOS's Rudder steers software-defined networking for Docker
InfoWorld
The amount of software built from and on top of Docker keeps growing. The folks behind CoreOS, the Linux distribution that uses Docker containers as a fundamental building block, have released Rudder, a way to manage networking between and across ...


Wired

Sonos adds full Wi-Fi compatibility with latest software update
CNET
A software update (version 5.1) made available today for the multiroom streaming speaker system will allow customers to connect directly to a Wi-Fi network. That will all but eliminate the major caveat that has dogged Sonos since its debut: the fact ...
Sonos (Accidentally?) Teases 'Even Simpler' Software, no Bridge RequiredCEPro

all 16 news articles »

Apple's Archaic Software and Services Could Be Its Achilles' Heel
TheStreet.com
That's why -- outside of the best operating system on the market (iOS) -- I have never bought into the myth that Apple's a software company. Doesn't matter to me how many times Tim Cook says it or David Einhorn regurgitates it. Apple, which generates a ...

and more »

Wall Street Journal

VMware Moves to Defuse Software Threats, Plans Hardware
Wall Street Journal
The company used its annual conference in San Francisco to announce plans to distribute a version of OpenStack—a tool for managing data centers—and software offering features of a technology called containers that some companies use to develop and ...
HP and VMware Collaborate to Simplify Software-Defined Data Center and ...MarketWatch
VMware EVO speeds up software-defined datacentre deliveryZDNet
VMworld 2014: In Pursuit of Software Defined EverythingEnterpriseNetworkingPlanet

all 281 news articles »
Google News

Resume Software ? Advantages Revealed

The various resume software offered, particularly on the internet, can... Read More

ERP for Large Corporation ? New Selling Strategy

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

The Dreaded Paper Label - Should it be Used?

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

Open Source Concepts: Dual Licensing Explained

We were recently faced with a decision: either to let... Read More

Groupware and Online Collaboration: Collaboration Series #4

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

Review of TikiWiki Content Management System

TikiWiki is open source software - it is written in... Read More

Professional XP Style Icons in Software and Website Development

Using professional icons in your application or website can bring... Read More

Microsoft CRM: Implementation, Customization, Support ? Consultant Overview

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

Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

When Great Plains Software introduced the first graphical accounting application... Read More

Microsoft RMS Customization ? PO Items Receiving in Great Plains

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

Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

Microsoft CRM is winning market share step-by-step from such the... Read More

Groove Network. Are you in it?

If you are in a business that passes documents around... Read More

COSMIC: A Small Improvement on the Symons Method

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

Microsoft Great Plains as ERP and Microsoft CRM as CRM

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

Create ASP in Minutes

DBxtra goes ASPGetting to the information hidden within corporate databases... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

7 Things to Consider Before Buying Small Business Accounting Software

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

ERP Software Financing: the Future? ? Overview for Company Owner

In our case ? we serve Microsoft Business Solutions ERP... Read More

Kick-Ass Performance For Your PC? Its Easy

Is your PC is slow and wimpy? Then you need... Read More

Great Plains Customization Upgrade? Overview For CIO/IT Director

Around the same time Microsoft made its move with .Net... Read More

Preventive Maintenance Software Companies

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

The Death of Windows

I have always regretted how Microsoft price gouges and rips... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... 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

Microsoft Great Plains: Dexterity vs. eConnect ? FAQ

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