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:

NBC Connecticut

Connecticut Attorney General Raises Concerns About Software on Lenovo ...
NBC Connecticut
"It's extremely concerning that, based on published reports, Lenovo installed this software – which appears to have no meaningful benefit to the consumer – on devices without the purchaser's knowledge," Jepsen said in a statement. "It is bad enough ...
CT Attorney General asks Lenovo about software that tracks web activityFOX CT
Lenovo Being Investigated For Use Of Superfish SoftwareHuffington Post
UPDATE 1-Connecticut launches probe into Lenovo use of Superfish softwareReuters

all 23 news articles »


New Glasses Make You Invisible to Facial Recognition Software
AVG is a name well-known in the Windows world for its decent and free anti-virus software, but the company is apparently looking to expand outside of just software and protect people's privacy in the real world now. At Mobile World Congress, AVG is ...
These Glasses Foil Facial Recognition SoftwareIGN
AVG's magic glasses make you invisible to facial recognition softwareGizmag
AVG Has Invented 'Invisibility Glasses' That Block Facial Recognition SoftwareUproxx
Biometric Update -Headlines & Global News
all 19 news articles »


BlackBerry commits to software on any device
Sunday's announcement at the Mobile World Congress represents a "major company-wide initiative in BlackBerry's commitment to build out its robust software portfolio," the company said in a statement. The software will be customized for each type of ...
BlackBerry's software strategy: Will the stars line up?ZDNet
BlackBerry Aims to Show Its Software Side in BarcelonaRe/code
BlackBerry plans full software assault on iOS and AndroidITProPortal

all 145 news articles »

Handy Tools Software Developers Love and Why They Love Them
Huffington Post
This explosion in software development has led to an influx of new developers and developer tools. In this sea of software development products, there are a few gems that might be overshadowed by some of the bigger names. Ask a developer, and they'll ...

Wall Street Journal

BlackBerry Launches Cloud Version of Mobile Security Software
Wall Street Journal
With the cloud version of BES12, BlackBerry aims to win new business from small and midsize companies that don't have the resources to install BES12 on site, by making the software available online. BlackBerry also expects the offering to appeal to ...
BlackBerry hopes cross-platform software offerings will attract usersThe Globe and Mail
BlackBerry to Offer Its Software for Android, iOS and Windows DeviceseWeek
BlackBerry going software only? Will make more apps for rival
all 111 news articles »


Anatomy of a certificate problem - Comodo's "PrivDog" software in the spotlight
Naked Security
As it happened, many of its customers might never have even noticed SuperFish, were it not for the negative publicity that followed the revelation that the software had got its cryptography wrong. SuperFish blessed itself with the right to give its own ...
Mozilla scrubs Superfish certificate from FirefoxComputerworld

all 7 news articles »


Creative AI: Software writing software and the broader challenges of ...
The next big thing for computational creativity may well be software that writes software. "We've all kind of avoided it," says Goldsmiths College and Falmouth University professor Simon Colton, whose artificial intelligence project – The Painting Fool ...

Time to support software industry priorities
The Hill (blog)
The global software industry – exemplified by the unparalleled success of American-born innovation – is changing the way we live. Software creates jobs. It sustains vibrant economies. And it enables us to do amazing things by connecting human ingenuity ...


Up close with Galaxy S6 and S6 Edge new software
Mobile World Congress 2015: Up close with Galaxy S6 and S6 Edge new software. 1:30 / March 1, 2015. Samsung says it's made its new metal-and-glass smartphones easier to use. We investigate the new interface features. Transcription not available for Up ...
Samsung Galaxy S6 offers more proof Microsoft is a software and services ...ZDNet
MWC: Samsung Galaxy S6 challenges Apple and HTC with hardware and
There's one new Galaxy S6 feature you don't really need, but you'll want it anywayBGR
TechRadar -Android Headlines - Android News
all 2,950 news articles »

Apple Insider

Apple Watch carried codename 'Gizmo,' former Adobe CTO Kevin Lynch ...
Apple Insider
Apple Watch carried codename 'Gizmo,' former Adobe CTO Kevin Lynch spearheaded software. By Neil Hughes Monday, March 02, 2015, 12:44 pm PT (03:44 pm ET). With the retail launch of the Apple Watch fast approaching, tidbits on the development of ...

and more »
Google News

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

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

Microsoft CRM for Large Corporation ? Security

Microsoft Business Solutions CRM proved to be reliable solution in... Read More

Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

In this small article we will show you the possible... Read More

Make or Break Factors - When Considering Estimating Software

Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

What to Do if All Screensavers Fun is Grayed Out?

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

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

Some introduction into Great Plains Software products, now Microsoft Business... Read More

SQL: Querying Microsoft Great Plains ? Overview for Database Administrator/Developer

Looks like Microsoft Great Plains becomes more... Read More

Microsoft Great Plains FA: Fixed Assets ? Overview For Consultant

Great Plains Fixed Assets Management module is a robust tool... Read More

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

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

Windows x: Basic Windows ?Security? Issues

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

Great Plains Dexterity Development: FAQ

Microsoft Business Solutions Great Plains is Dexterity-written application and currently... 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

Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL ? Development Options

Microsoft bought Navision, Denmark based software development company, along with... Read More

Microsoft Navision Customization and Reporting ? Tips For Programmer/IT Specialist

C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More

Groupware and Online Collaboration: Collaboration Series #4

This article is the fourth of a series of articles... Read More

Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

Microsoft Great Plains fits to majority of industries, in the... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More

Software Tools To Help Your Business Sell More

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

Microsoft CRM Customization: Integration with Third Party SQL Application/Database

Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

Microsoft CRM Lotus Notes Domino Connector FAQ

Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More

Healthcare Preventive Maintenance Software

Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More

Microsoft CRM ? Consulting in the Post-Recession Time

New post-recession era has new features, which didn't exist in... Read More

What You Should Know About Installing Screensavers

Do you remember that frustrating feeling when you find an... Read More

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More