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, [email protected]

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 HPE GreenLake Chief Keith White: HPE Is Becoming 'More Of A Software Company'  CRN: Technology news for channel partners and solution providers
Software Robots Get Smarter Thanks to AI  The Wall Street Journal
Surfshark VPN (for macOS)  PCMag Portugal
Top 10 Software Vendors in Retail  Retail Info Systems News

Exactly What Does FTP Stand for and What Can it do for Me?

FTP stands for "file transfer protocol". FTP is basically a... Read More

Corel WordPerfect 7 Macro Programming Example

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

Reduce Pop-ups and Annoying Ads

There is many things more frustrating than surfing a website... 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

Algebra Help Software

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

eConnect: eCommerce Development for Microsoft Great Plains

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

The Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

Linux for Home Users

Hey Guys! Don't raise your eyebrows or fear by hearing... Read More

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

Microsoft Great Plains is now targeting large and midsize businesses... Read More

Begun, The Browser Wars Have

As Mozilla Firefox nears 10% market share, with well over... Read More

Microsoft Office Selecting Secrets

Stop the Runaway MouseWhat's the "runaway mouse?" You've seen it...you... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

Defining OLAP Solutions and Data Warehouse design

This tutorial covers OLAP solutions used by Data warehouses and... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

DVD Burning Tips

CD and DVD replication is a process that works by... Read More

Microsoft CRM Modification ? Overview for IT Specialist

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

Accessing XML Using Java Technologies

The most important benefit of XML is its simplicity. Though... Read More

Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

Microsoft Business Solutions Great Plains has substantial market share among... Read More

10 Programming Tips

(1) Avoid using the same variable again and again for... Read More

Are You Waiting for Microsoft Longhorn Operating System

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

20 Extra Hours Per Week: What Would You Do?

While I was in college, if you would have asked... Read More

Microsoft Great Plains on Ctree or Pervasive SQL ? What to Do ? Tips for IT Manager

As you probably know, when Microsoft purchased Great Plains Software... Read More

Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

Microsoft Business Solutions is now in process of creating so... Read More

Spyware Statistics -- Whats New in May 2005?

Although statistics often is blamed for various deadly sins --... Read More