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:


A tour of the Jolla phone with software head Marc Dillon (video) - Engadget
Engadget
Say hello to the Jolla Phone. Preorders for the world's first Sailfish OS device launched today and we've called into Helsinki to get the whole story from Jolla's Head of Software, Marc Dillon. While we know there's a 4.5-inch "high definition" screen ...

and more »

Indian Express

Galaxy S III software leak reveals potential S4-class upgrades
The Verge
Samsung appears to be making good on its promise to port Galaxy S4 features to the Galaxy S III. A test Android 4.2.2 update, discovered by SamMobile, includes the lockscreen effects and widgets, enhanced screen modes, updated settings, and new S ...
Galaxy S4 “Nexus” could be a software-modified T-Mobile unit, report saysAndroid Authority
Samsung Galaxy SIII 4.2.2 Software leaked with S4 Features - Gadget HelplineGadget Helpline (blog)
Samsung launches $800000 app contest for Galaxy S4Australian Techworld

all 228 news articles »

The News International

NADRA directed to develop fingerprint verification software
The News International
ISLAMABAD: Secretary Election Commission Ishtiaq Ahmed said Monday the Election Commission of Pakistan (ECP) had ordered the National Database Management Authority (NADRA) to develop software for fingerprint verification as soon as possible.
ECP software for speedy results flopsAssociated Press of Pakistan

all 142 news articles »

After Court Ruling, US Still In Disarray On Software Patents
Intellectual Property Watch
What inventions are eligible for patent protection? That question has roiled the US legal system for the last decade. But the Federal Circuit Court of Appeals (often called the nation's patent court) was supposedly riding to the rescue. The court's ...
Patent Eligibility of Software Innovations After CLS BankThe National Law Review

all 2 news articles »

FG Endorses Brainfriend Software for Nigerian Schools
AllAfrica.com
The Federal Ministry of Education has endorsed the CINFORES BrainFriend e-learning and examination preparatory software as a tool for the enhancement of teaching and learning methods in Nigerian schools. The essence is to boost the efforts government ...

and more »

Railways get software to set timetable
Times of India
MUMBAI: The railways are finally moving with the times. Hoping to improve the punctuality of services, the authorities are abandoning the practice of manually preparing timetables and have commissioned a software to prepare a timetable based on traffic ...

and more »

MusicRadar.com

Free music software round-up: Week 125
MusicRadar.com
We are, in general, starting to see more cross-platform free music software, but we're exclusively in Windows territory this week. Mac owners, then, can look away now (or look on in envy); PC users should get their download fingers ready. If you've got ...


Economic Times

Ranadivé, who on Friday secured a deal to buy basketball team Sacramento ...
Economic Times
On late Friday, a team led by Ranadive, the founder and chief executive of Tibco Software, which is widely credited with digitising Wall Street, agreed to pick up a 65% stake in the Sacramento Kings for $535 million. The deal will ensure the National ...
Report: Deal reached to sell KingsFOXSports.com
Maloofs, Sacramento group agreeESPN
Software magnate Vivek Ranadive has big plans after buying NBA's Sacramento ...Vancouver Desi

all 404 news articles »

The Express Tribune

Pakistan a friendlier place for software makers
The Express Tribune
When it comes to software piracy, Pakistan is far behind many other countries – both in mature and emerging markets – in terms of commercial value of the unlicensed software, however, as a percentage of total pirated software used in the country, it ...


Tiny Books For The Macintosh Makes It To No. 1 Place In Recent Boffin ...
Newsday
The Boffin software review website announces that Tiny Books for the Macintosh is the top bookkeeping software, based on the set of features and tools it offers to homeowners and small-scale businesses. The Boffin reviewers carefully evaluated a wide ...
Reviews of The Best Bookkeeping Software Now Available At ...PR Web (press release)

all 4 news articles »
Google News

Can Group Collaboration Software Meet Business Needs?

According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More

Microsoft eCommerce Web-development: Great Plains eConnect .Net ? Highlights for Programmer

In our small article we'll consider Microsoft Business Solutions Great... Read More

Upgrading Great Plains Dexterity Customization ? switching to new technologies: SQL, Crystal, eConne

1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More

ERP for Large Corporation ? New Selling Strategy

Our opinion is based on our Microsoft Business Solutions Great... Read More

Microsoft Great Plains Data Conversion ? Overview For Developer

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

Software Tools To Help Your Business Sell More

Sales are all about leverage, because there is only so... Read More

Software Process Improvement -A Successful Journey

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

Lowering The Risks In Developing Do-It-Yourself Software Projects

Mike Dunville* had a decision to make. As the new... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Cisco Certification: Five Things To Do DURING Your CCNA Exam

There are plenty of articles out there about how to... Read More

Free Program Removes Spyware not Detected by Premium Security Scan

What is Spyware?Spyware monitors your surfing habits and sends the... 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

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

Easy Guide to RAID Recovery

What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

Microsoft Great Plains customization ? Freight Forwarding/Transportation industry example

Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

Microsoft Great Plains POP: Purchase Order Processing ? Overview For Consultants

Great Plains Purchase Order Processing (POP) module makes up one-third... Read More

DVD Burning Tips

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

Protect Your Computer...and Your Business!

We all take the computer for granted. I mean, all... Read More

RSS: Get Notified When Your Favorite Websites Are Updated

RSS (Really Simple Syndication) is a way for a site... Read More

The True Meaning of Freeware

The vast majority of us will have, at some point,... Read More

Who?s Watching What You Type?

If someone entered your home, uninvited and installed numerous cameras... Read More