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:


Brevard Schools delay big payment to software company
Florida Today
Brevard Public Schools is delaying the final payment on a controversial software package, potentially adding fuel to the political fire over the purchase. The financial and human resources software is not ready for full implementation. So district ...

and more »

For Software Makers Powering Designs At Fashion Houses, China's The Next ...
Forbes
The fall collections at Marc Jabobs and Christian Louboutin don't seem to have much to do with software. But with thousands of different items on line, often different from one region to another, the big business of fashion needs to be more automated ...


Top Rated Electronic Health Record Software Is Free
Forbes
Of course free software licensing doesn't make the hardware, installation or maintenance free, but the lack of any software licensing fees at all does reduce the overall cost ‒ especially for large installations ‒ and that can typically save millions ...

and more »

Slate Magazine (blog)

Why This Startup Hires Employees With Autism
Slate Magazine (blog)
People with autism and Asperger's tend to engage in repetitive behaviors that others might consider boring, which allows them to maintain focus as they test whether a given piece of software works on different devices, operating systems, and web ...


CoinTerra Acquires Bitcoin Software Developer Bits of Proof
CoinDesk
Under the terms of the deal, Bits of Proof CEO Tamás Blummer will join CoinTerra, assuming the position of Vice President of Enterprise Software, while CoinTerra will gain access to BOP assets, including its 'enterprise-ready' implementation of the ...
CoinTerra acquires Bits of Proof and welcomes founder Tamas Blummer as Vice ...PR Newswire (press release)

all 5 news articles »

ZDNet

Software licensing: This man thinks it's time someone stood up for the end user
ZDNet
Software licensing can be fiendishly complicated even for the smartest CIO, and the consequences of getting it wrong can be very painful. "If you, as an end user, are faced with trying to manage complex licensing agreements that are not manageable, you ...

and more »

1985 Macintosh Office ad reminds us how much space software used to take up
tuaw.com
"Now there are more than 500 software programs for the Macintosh Office, so no matter what business you're in, you're in business." In just one sentence this 1985 Macintosh Office ad explained to viewers why it was going to change the way they worked ...


Antivirus Software Isn't Very Secure, Researchers Find
Tom's Guide
Antivirus software is often just as insecure as the software it's meant to protect — and running it might make you even more insecure, according to a researcher with Singapore-based security firm Coseinc. At the SyScan 360 security conference in ...

and more »

Software Hurdles May Follow KC-46A Wiring Woes
DoD Buzz
The refueling tanker, known as Pegasus, will require some 15.8 million lines of code, the vast majority of which — 83 percent — is slated to come from existing software, according to the report. While Boeing plans to recycle most of the software from ...


NDTV

Nokia X Software Platform 1.2 Update Now Rolling Out
NDTV
Some of the key features that the Nokia X Software Platform 1.2 update brings are the new app switcher, which allows closing apps with a single tap; pre-installed Outlook.com and OneNote apps; updated Nokia Store that comes with better integration with ...
Original Nokia X trio getting a software updateGSMArena.com
Nokia X lineup gets new software updateBetaNews
Nokia X Gets Software Update while Samsung Galaxy S5 Struggles for SalesStreetWise Tech
ITProPortal -TechOne3 -Geeky gadgets
all 22 news articles »
Google News

Save Your Resources - Combine Your IM Clients

There are so many different programs that clutter up your... Read More

MySQL for Beginners ? How to Create a MySQL Database

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

Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO

Microsoft Business Solutions Great Plains as new ERP for multinational... Read More

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

Groupware: Avoid the Ad Hoc Shuffle

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

Microsoft CRM Data Conversion FAQ

Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

What You Must Know About Spyware Right Now

Spyware is like the new technological nuclear weapon on the... Read More

Microsoft CRM and Great Plains Implementation: Freight Forwarding Business Automation Example

Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More

Is Your Small Business Ready For A CRM Software Solution?

I have yet to see a business that, sometimes in... Read More

Looking for an Alternative to Microsoft Office? You Should Be!

Now is the time to look at an alternative to... Read More

How to Get The Best Accounting Software For Your Small Business

Buying accounting software is a major investment. It's an important... Read More

Explore the Internet in a Whole New Way

For a long time now Microsoft's Internet Explorer has ruled... Read More

Linux Vs. Windows

This article will not attempt to advocate the use of... Read More

Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist

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

Microsoft Small Business Manager Customization Options - Overview

Microsoft Business Solutions Small Business Manager is Great Plains Dexterity... Read More

Microsoft Great Plains international implementation ? USA / Mexico ? overview for consultant

Microsoft Business Solutions Great Plains was purchased from Great Plains... Read More

Lotus Notes Domino and Microsoft CRM Integration

Well, even if the combination might look very unusual, we... Read More

What is Software Piracy?

There are several kinds of software piracy. The bottom line... Read More

How to Evaluate Staffing Software

If you are in the market for new staffing software,... Read More

Microsoft Great Plains, Navision, Axapta ? Selection Considerations

During the years of our consulting practice, which comes back... 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

SyncUp ? A File/Folder Synchronizer For Windows

SyncUp, a file synchronizer is designed to assist the home... Read More

Microsoft Great Plains IV: Inventory Management

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

Microsoft Great Plains version 8.5: Upgrade, Customization, VBA, Crystal Reports - Highlights

Microsoft Great Plains is one of the Microsoft Business Solutions... 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