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:


Telegraph.co.uk

Vista Equity Partners to Pay $1.1 Billion for British Software Maker
New York Times
Advanced Computer Software provides patient management software to health care providers, back-office systems for businesses and outsourced information technology services. It posted revenue of £203.2 million in fiscal year 2014, which ended in ...
Vista Equity Partners snaps up Advanced Computer SoftwareFinancial Times
Advanced Computer Software agrees to £725m takeover by VistaTelegraph.co.uk
Vista Equity Partners' Air Bidco To Buy Advanced Computer Software For 140p/shrRTT News

all 16 news articles »

Veedersburg considers mapping software for town
Danville Commercial News
VEEDERSBURG, Ind. — Town council members received a brief presentation Tuesday from Ken Denlow, the local representative of Beehive Industries of Lincoln, Neb.. Beehive software is based on mapping a town infrastructure including water lines, sewer ...


How Do You Make Money From Free Software?
Gizmodo
Free software—truly free software—is undoubtedly a good thing. But given the rest of the world still uses that pesky stuff called money, how on Earth do you make a living from spending your time giving away software for nothing? In this video Matt ...


9NEWS.com

Software company execs charged with fraud, theft
9NEWS.com
Colorado Securities Commissioner Gerald Rome said Wednesday that Chisan Chong, of Aurora, and Steven Linnenkamp, of Castle Rock, promised that Direction Labs' "Second Sight" software takes "all the guesswork" out of making trades, was "bulletproof" ...
Men charged with securities fraud for marketing predictive softwareThe Denver Post

all 10 news articles »

Want to Create the Next Great Software Product? Don't Try to Innovate
Knowledge@Wharton
Ben Galbraith, vice president of global products for Walmart, is surprised at how many people still believe that the best way to come up with new software is to “get a bunch of nerds and put them in a room until they produce a product.” In reality, he ...


What does 'software defined' actually mean?
TechTarget
Lately, that overused (and often misused) term is “software defined,” which VMware first unveiled to describe its vision for a data center in which resources are pooled and managed by software. In just the past few weeks I've seen network switches ...


Software industry is the largest creator of jobs: Narayana Murthy
Economic Times
"The software industry in India employs about 3.2 million professionals and adds about 2,00,000 jobs every year. Therefore this industry has replaced the public sector as the largest creator of jobs," Murthy said at the Commonwealth Science Conference ...

and more »

FDA Approves Software for Noninvasive Cardio Studies
Medscape
The US Food and Drug Administration (FDA) today approved a software program that can noninvasively identify coronary artery blockages, avoiding the need to diagnose the problem via cardiac catheterization. The software is FFR-CT, from a company called ...

and more »

FedScoop

NSA releases first-ever open source software product
FedScoop
It may not be much of a surprise that the National Security Agency has expertise in data management. What's surprising is that the agency has released one of its data management tools to the public, with the software completely open source. The NSA ...
The NSA Goes Open Source With Its Data Software: Free Enhanced File TransfersDesign & Trend
NSA releases automated data flow software as open sourceSDTimes.com

all 4 news articles »

TechCrunch

Regin Spying Software Has Been Attacking Governments And Corporations ...
TechCrunch
Symantec has found an unusual new threat called Regin aka Backdoor.Regin. The software, which is essentially a very powerful Trojan Horse, appears to have been circulating in the wild since 2008 and has been hitting governmental, industrial, and ...
People Are Flipping Out Over This Spy Software Created By An Unknown ...Business Insider
Unidentified country likely behind sophisticated 'Regin' spying softwareCTV News
Regin: Newly uncovered malicious software snooping since 2008 'was ...The Independent

all 599 news articles »
Google News

The Truth about Colossus: Are You Just A Magnetic Image?

What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More

Is Software Tester a Most Infamous Person in a Software Project Team?

The fact that a software tester is a most infamous... Read More

Groupware: Answers the 5 Questions of Document Collaboration

Every organization which creates collaborative documents, whether they are budgets,... Read More

Microsoft Great Plains Customization and Development ? Overview for Programmer

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

Who Is Minding Your Sensitive Data?

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

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

MySQL for Beginners ? How to Create a MySQL Database

Whether you are an experienced web programmer or a complete... Read More

Spyware Definitions List

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

Microsoft Great Plains Nationwide Remote Support

ERP Consulting industry is on the way to serve clients... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... Read More

Microsoft Great Plains SOP: Sales Order Processing

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

Crystal Reports for Microsoft Great Plains ? Overview for Developer

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

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... Read More

Navision Attain C/ODBC Crystal Report ? Customization Example

Microsoft Business Solutions Navision is main ERP application for European,... Read More

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

Microsoft Great Plains fits to majority of industries, in the... Read More

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

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

C++ Tutorials: 3, Program Flow (If, Else, While, For)

Program Flow is what you think it is. How the... Read More

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

Crystal Reports is the most flexible tool on the market... Read More

Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

Many reasons made GBM a unanimous choice for experts, one... Read More

Are You Waiting for Microsoft Longhorn Operating System

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

Importance of Coding Standards

Programming Help for BeginnersWe write programs to instruct computers. When... Read More

Things You Can Do With Windows XP!

Did you ever give a thought to the number of... Read More

Increase Office Efficiency With One Simple Tool

When you need a phone number, you do a quick... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More