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:

ActiveDEMAND Named Third Best Call Tracking Software Company by ...
NAPLES, FL, Aug 29, 2015 (Marketwired via COMTEX) -- has made public the rankings of the 10 best call tracking software solutions for August 2015. ActiveDEMAND has been named the third best service due to their effective performance ...

and more »


New Apps, Management Software Seeping In as Old Industries Digitize
John Van Siclen recalls driving around last year in the middle of nowhere, Wisconsin, to visit a large retailer. The meeting was off the beaten path for the Dynatrace CEO, but not just in the physical sense. His Waltham, MA-based company makes software ...

Popular Science

In BMW Electric Car, Software 'Coding' Unlocks Hidden Features Owners Want
Popular Science
At least some are choosing to follow instructions posted online and in BMW forums to "code" their cars--which is to say, modify the car's software to provide these functions. That, not surprisingly, is highly frowned upon by BMW, for a very rational ...

and more »

Popular Science

Software Automatically Takes Out Distracting Items From Your Photos
Popular Science
Now a team of computer scientists from Princeton University and software company Adobe have created a program to make those photos just a little better, by identifying and eliminating distracting elements, according to a paper presented recently at ...

and more »


How to Deal With Increasingly Picky Business-Software Buyers
What is it about software built for businesses, that we expect it to be pretty much unusable? I'm not going to name names, but you know who they are. They're “powering” the HR, finance, sales and reporting functions of the world's enterprises and SMBs ...

and more »

Recruitment Software Developer Greenhouse Grabs $35M
[Updated, 12:30 pm with comments from CEO Daniel Chait.] New York-based Greenhouse Software announced Friday it raised $35 million in a Series C round led by Thrive Capital, with returning investors Benchmark, Groupe Arnault, and The Social+Capital ...

Pittsburgh Post-Gazette

Software developed by CMU student helps find online sex traffickers
Pittsburgh Post-Gazette
A fledgling Pittsburgh startup, Marinus Analytics, has a software product, Traffic Jam, that mines the so-called “deep web” for information and clues about trafficking operations and which is being used by law enforcement agencies including the FBI to ...

India turns the business software industry on its heels with TrueCFO
Among them was the software-as-a-service trend, which carried tremendous momentum. At the same time, I started hearing certain rumblings – “SaaS is dead,” they said. “It's time for SES.” Inch by inch, certain parts of the market were moving away from ...

UK software firm Innovation in talks with Carlyle over £500m takeover deal
International Business Times UK
US private equity firm Carlyle Group (Nasdaq:CG) is in advanced talks to buy UK software firm Innovation Group. Innovation confirmed the development in a stock exchange filing. Sky News earlier reported that the companies have been in discussions about ...
Software firm Innovation bought by Carlyle for £

all 55 news articles »


How to select enterprise software that maximizes ROI
Selecting best-fit enterprise software is a difficult task, and you can't please all the people all the time. This article outlines a data driven and auditable process to pick the software that maximizes ROI and minimizes buyer's remorse.

Google News

Microsoft Great Plains, Navision, Axapta ? Selection Considerations

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

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More

Getting Technical Support Help Online

Sometimes your PC will start acting strange for no apparent... Read More

Story Development Software: Good or Evil?

In the early days of the personal computer, we're talking... Read More

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

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

Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

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

Think Of This

Think of this, first we had the HAM Radio, then... Read More

Software Process Improvement -A Successful Journey

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

Computer Phones ? Facts and Fallacies

The stakes are high when considering security, privacy, and savings,... Read More

netstat - Linux Command to Display Networking Information

In linux, one of great commands for finding out information... Read More

Microsoft Great Plains IV: Inventory Management

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

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

Helping Newbies Understand Professional Software

The Windows registry is a huge database that ensures normal... Read More

Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

Microsoft Business Solutions Great Plains is written in Great Plains... Read More

Microsoft Great Plains Customization: Project Organization ? International Business Example

Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

MicroWorld Releases New Version of MailScan Ver. 4.5 - Antivirus and Content Security Software

MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More

What to Do if All Screensavers Fun is Grayed Out?

Finally, you have some time to personalize your desktop with... Read More

A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

Icons are used everywhere; right from software applications, to internet... Read More

Linux vs Windows Operating Systems

With so many Microsoft Windows related viruses, errors, and other... Read More

Software Development in 2005 - Back to the Future

2005 ? Back to the Future.What does the future hold?... Read More

Spyware, Adware, etc. -- Terms and Common Sense

When reading an article where some term is used often,... Read More

Explore the Internet in a Whole New Way

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

Navision Attain C/ODBC Crystal Report ? Customization Example

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

Reloading Windows XP

If you have been running Windows XP for a couple... Read More