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:

BBC News

London police trial gang violence 'predicting' software
BBC News
Police in London have tested software designed to identify which gang members are most likely to commit violent crimes. The 20-week pilot study is thought to have been the first of its kind in the UK, although similar experiments have been carried out ...
Met Police test software that predicts the chance of gangs committing a crimeDaily Mail
London police raise privacy hackles with gang violence softwareEngadget
Minority Report reality: London Police test Precrime softwareSlashGear
all 11 news articles »

Buy the Wrong Software? A Fix Can Cost $700000
"All software has defects," Theresa Lanowitz, lead analyst at Voke, told CMSWire. "The cost of defect remediation is dependent on when the defect is identified and remediated, how the defect must be remediated: is it the cost of development and test ...

Software maker 6Qube completes funding round
Austin Business Journal (blog)
The Austin-based startup, which is operated by Blue Jag Enterprises LLC, plans to use the capital to fuel its sales and marketing combined with upgrades to its software. Seattle-based Lighter Capital was the lone investor, according to a company news ...

New software designed to help better track Ebola outbreaks
Health departments have always put pins in maps during outbreaks of communicable disease, but Neil Abernethy, Ph.D. who works in both the U.W.'s School of Public Health and the School of Medicine, says that doesn't work as quickly as the software to ...

and more »

Wall Street Journal

Popular Software Gives Hackers Easy Targets, DOD Official Says
Wall Street Journal
Hackers find their way into machines—both classified networks and retailers—by searching for unnoticed flaws in the software these networks use. After an initial incident, it can take weeks or years for other companies to patch their systems to ...

and more »

IT News Africa

RAM Group cuts downtime with new software
IT News Africa
According to the the RAM Group, it has cut the time needed to back up the IT systems supporting its always-on business by 95%. RAM revealed that this was due to company using Veeam software. Group IT Manager, Lance Soller stated that: “Our IT platform ...

Turkish Company Develops Anti-Fog Software for Copters
PiriReis Informatics Technologies, based here, has said that it developed a software that enables helicopter pilots to detect geographical obstacles during flight on a 3D screen “even when visibility is close to zero.” Company officials said the ...

and more »

Stanford University News

Stanford system combines software with human intelligence to improve translation
Stanford University News
As Manning explained, software-based language translation was among the first applications tested on the computers developed during and after World War II. "During the Cold War there was a great desire to understand the other side and doing translation ...

New software hopes to alleviate intersection backups in Palm Beach County
The software also detect the number of cars waiting at railroad crossings. There are two railroad crossings on Okeechobee Boulevard between Tamarind Avenue and Flagler Drive, which have a tendency to back up traffic. The cameras have the ability to ...

and more »

Virgin Trains Deploys Darktrace, Software with UK Cyber Intelligence Pedigree
Wall Street Journal (blog)
The software then looks for variations in that behavior to identify unusual or potentially malicious activity inside a network. “It is not a rules-based approach. If an intruder is inside … it spots abnormality,” said Darktrace co-founder Steve Huxter ...

Google News

Dont Choose Adobe When Working With PDF

While Adobe is the most known maker of PDF tools,... Read More

Spyware Definitions List

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

Did You Ever Want to Completely Erase Everything on Your Computer?

Did you ever want to erase everything on your computer?... Read More

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software... Read More

Microsoft Great Plains Implementation ? Overview for IT Director/Controller

What is installation in the language of technology? Installation... Read More

Microsoft Great Plains SOP: Sales Order Processing

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

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

Navision Attain Database access via C/ODBC in ASP.NET Application

Navision Software was purchased by Microsoft and now it is... 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

Microsoft Great Plains Accounting/ERP Implementation ? Finance Industry Customization Example

Microsoft Business Solutions Great Plains is very generic accounting application... Read More

Causes of ERP Failures

ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

Spyware - The Internet Devil Of Our Times!

Spyware and Adware infest over 90 percent of computers in... Read More

Microsoft Great Plains Integration Manager ? Advanced Techniques

Great Plains Integration Manager scripting and translation - overview for... Read More

Software Development in 2005 - Back to the Future

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

Microsoft Great Plains eCommerce ? Stored Procedures Approach

Since Version 8.0 Microsoft Business Solutions Great Plains & Great... 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 Customization: Project Organization ? International Business Example

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

Lotus Domino: Application Integration ? A Programmer View

There are two approaches for application integration:? Programmer's approach ?... Read More

Microsoft CRM Modification ? Overview for IT Specialist

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

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

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

Keep Your Software Simple! A Review of EditPlus

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

ERP Remote Support: Microsoft Great Plains Analysis ? Pluses & Minuses

Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More

Great Plains Dexterity Programming ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More

OEComplete ? A Personal Information Manager

OEComplete is a utility for managing the personal information of... Read More