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:

China draws inspiration from India, mulls software city based on Bengaluru model
Economic Times
XI'AN: The historic city of Xi'an in northwest China is busy developing a new software city inspired by the Bengaluru model. Local authorities are looking up to Prime Minister Narendra Modi for assistance in this regard and want him to sign a contract ...

and more »

Greentech Media

Folsom Labs, Solar Design Software Startup, Lands $1M in Angel Funding
Greentech Media
But startups need to grow fast, so the funding is aimed at extending the software to span far more of the process flow in a solar project -- from "initial customer lead to final close." The aim is to lower "industry soft costs with work flow ...

and more »

Ex-worker sues software firm Jenzabar Inc. on bias charge
Boston Globe (subscription)
The Boston software management company that hosted a fund-raiser for Republican presidential candidate Marco Rubio on Thursday faces trial on charges of religious discrimination and retaliation after a federal judge declined to dismiss claims brought ...

Voice of America

Investigators: Hackers Hit Diplomatic Targets Via Software Flaws
Voice of America
SAN FRANCISCO—. A widely reported Russian cyber-spying campaign against diplomatic targets in the United States and elsewhere has been using two previously unknown flaws in software to penetrate target machines, a security company investigating ...

and more »

The Inquisitr

'Borderlands' Creator Matthew Armstrong Leaves Gearbox Software
The Inquisitr
It is not known exactly what his title was for the latter games as Gearbox opted for a more generic credit scroll simply entitled, “Gearbox Software is.” GameInformer reached out for comment from Armstrong following his tweets that things have changed.
'Borderlands' Creator Leaves Developer Gearbox SoftwareGame Rant
Borderlands creator leaving Gearbox SoftwareGamer Headlines
Borderlands Creator Leaves GearboxGameSpot
Game Informer
all 14 news articles »

Marshall goes digital with its first official software amplifier
Ars Technica
One of the solutions to this problem has been digital modeling, i.e. the recreation of classic analogue amplifiers and effects with software or a standalone device. Modeling has come a long way the past few years, with the likes of Native Instrument's ...

and more »

Got 'enough' security software? Smart behavior still matters
The Seattle Times
Q: I'm a senior PC user, with limited understanding of the innards of computers, but know security software is a must. I've used Internet security software that has a yearly fee. Because it increases every year, I'm seriously considering a free ...


Los Angeles school district drops Pearson software on iPads, seeks refund from ...
Washington Post (blog)
(Update: Adding statement from Pearson). The Los Angeles Unified School District sent a letter to Apple Inc., this week saying that it will no longer pay for Pearson-created software installed on iPads purchased from Apple because it does not work.
LA school district seeks millions from Apple over iPad software woesPCWorld
Just in: LAUSD seeking refund for iPads with Pearson softwareLA School Report
LAUSD Asks Apple For Reimbursement Of English, Math Software For Student ...CBS Local
all 260 news articles »

Daily Journal Online

New accounting software for the county
Daily Journal Online
St. Francois County Presiding Commissioner Harold Gallaher looks over the accounting software comparison between providers New World and Tyler Technologies. The commission later voted to go with the program from Tyler Technologies.

NAR'S digital signature software benefit goes global
Digital signature software is a critical asset to today's highly mobile paperless agent. The National Association of Realtors has been a long-term strategic partner with DocuSign for years and offers Realtors substantial discounts on their line of real ...

and more »
Google News

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Groupware as a Document Manager: Collaboration Series #3

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

Software Process Improvement -A Successful Journey

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

S is for Spying, Surveillance -- and for Software as Well

Words we choose to describe things and phenomena often show... Read More

Corel WordPerfect 7 Macro Programming Example

Case study: A secretary using Corel WordPerfect 7 is often... Read More

Microsoft Great Plains: Large Scale Implementation

Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More

Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

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

Interactive Mapping Brings Information to Life

What is Interactive Mapping?Interactive mapping is a visual display medium... Read More

Microsoft Great Plains customization ? Freight Forwarding/Transportation industry example

Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More

Rapid Application Development - Is it Really a Need of Today?

Rapid Application Development (RAD) is a software development methodology. In... Read More

Chinese Input - Step by Step Instruction on How to Input Chinese Characters in English Windows XP

Enabling Chinese input is quick and easy, there are only... Read More

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

Microsoft bought Navision, Denmark based software development company, along with... Read More

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

Demand More From Your Lead Tracking Software

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

Groupware: Avoid the Ad Hoc Shuffle

GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

ERP Remote Support: Microsoft Great Plains Analysis ? Pluses & Minuses

Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More

Business Planning Software

Once a business idea is selected, it is highly recommended... Read More

Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

The Death of Windows

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

Behave, Word, Behave!

If you copy something from a Web site or elsewhere...... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

Crystal Reports - Microsoft SQL Server

Microsoft SQL Server is the leader for inexpensive and middle... Read More

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... 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

Spyware Definitions List

The adware and spyware definitions list is very long. But... Read More