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:


New York Times (blog)

Malicious Software Said to Spread on Android Phones
New York Times (blog)
For years security researchers have warned that it was only a matter of time before nasty digital scourges like malicious software and spam would hit smartphones. Now they say it is has finally happened. A particularly nasty mobile malware campaign ...

and more »

Strong Database And Application Software Sales Could Lift Oracle Higher
Forbes
Database leader Oracle Corp. is the world's second largest software company in the multi-billion dollar software development market with revenues in excess of $38 billion and a market capitalization over $180 billion. The company competes with other ...

and more »

Wired

What's Missing from the Industrial Internet of Things Conversation? Software
Wired
Large hardware vendors recognized long ago that it is the software that makes the hardware more valuable. Software supports the human interaction side of the equation by helping to turn data into information. But not just basic information, I am ...

and more »

Researchers Announce Advance in Image-Recognition Software
New York Times
Two groups of scientists, working independently, have created artificial intelligence software capable of recognizing and describing the content of photographs and videos with far greater accuracy than ever before, sometimes even mimicking human levels ...
Google's Brain-Inspired Software Captions Complex ImagesMIT Technology Review
​How new software can describe photos with almost human accuracyCBS News
Google's Image Recognition Software Can Now Describe Entire ScenesGizmodo
Biometric Update -NBCNews.com -HEXUS
all 61 news articles »

Google's Brain-Inspired Software Describes What It Sees in Complex Images
MIT Technology Review
Researchers at Google have created software that can use complete sentences to accurately describe scenes shown in photos—a significant advance in the field of computer vision. When shown a photo of a game of ultimate Frisbee, for example, the ...


KSDK

Software developer believes app can bring people together
KSDK
LOUIS - Local software developer Daniel McFarland says the idea for his app to create interesting conversations came during a conversation with his wife about the impact of Ferguson. "I think animosity develops just out of unfamiliarity," said ...


Software maker Splunk's revenue beats estimates
CNBC
Nov 20 (Reuters) - Data analytics software maker Splunk Inc reported a better-than-expected 48 percent jump in quarterly revenue as it added more customers. Shares of the company, which raised its full-year revenue forecast, rose 5 percent in after ...

and more »

Software-Defined Whatnow? Data Management Without Lockin
CIO
The answer isn't a specific product, but an IT strategy that supports your growing business. It's a software-defined approach, where the software decision you make is way more important than the hardware you choose to run it on. Take Whatsapp, for example.

and more »

ITWorld Canada

Why employees shun company-bought software
ITWorld Canada
Ten per cent of the people surveyed said that the software they used at work slowed down or crashed their computers, while almost as many said that it wasn't reliable or didn't work properly. And five of respondents said that the software simply wouldn ...


Estimote unveils new software as it looks to pull ahead of beacon competitors
Washington Post (blog)
Its new software-development kit and API bring improvements in managing beacons, securing them and analyzing the data that beacons generate. Beacons are Bluetooth-powered sensors that have been placed in stores, sports stadiums and museums as ...

and more »
Google News

Microsoft Great Plains IV: Inventory Management

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

ERP System of the Future: Database, Business Logic and Interface

We will base our prognosis on our Microsoft Business Solutions... Read More

Microsoft CRM Integration with IBM Lotus Notes Domino ? Machinery Dealership Example

IBM Lotus Notes with Domino email server is traditional document... Read More

Microsoft Great Plains ? Licensing & Product Versions

Current Microsoft Business Solutions Great Plains has more that 10... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More

Corel WordPerfect 7 Macro Programming Example

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

Microsoft Great Plains Multicurrency ? Overview For Implementation Consultant

When you first think about multicurrency ? you probably have... Read More

Great Plains Dexterity: Customizations & Source Code Programming

Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

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

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

Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

All of us know that Microsoft bought former Great Plains... Read More

Software Process Improvement -A Successful Journey

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

Microsoft Great Plains BR: Bank Reconciliation

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

Accounts Payable: A Powerful Document Management and Workflow Solution

Accounts payable is just one area of office management where... Read More

How To Choose A Fire Wall Software Program

In the real world a "fire wall" is a fireproof... Read More

Four Easy Ways To Prevent Spyware

How would you like to prevent spyware and adware from... Read More

eConnect: eCommerce Development for Microsoft Great Plains

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

Call Alert Notifications - Free Answering Machine Software for PCs

If you're online using a dialup Internet connection, you'll probably... Read More

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

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

Keep Your Software Simple! A Review of EditPlus

I like my software simple. If it's too complex or... Read More

Review on QuarkXpress 6.0

After almost two decades of existence, Quark has become the... Read More

Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

In this small article we will show you the possible... Read More

How the Firefox: How to... Manual Helped Me

A few months back I really got sick of my... Read More

Photoshop Files and Formats

People often ask me: What image file formats will Photoshop... Read More

Microsoft CRM Modification ? Overview for IT Specialist

Microsoft CRM is now on the scene and it is... Read More