Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft RMS Customization ? PO Items Receiving in Great Plains > NetSparsh - Viral Content you Love & Share

Microsoft RMS Customization ? PO Items Receiving in Great Plains

Microsoft Retail Management (RMS) and Microsoft Great Plains are retail and accounting/ERP solutions coming from the same Microsoft subdivision ? Microsoft Business Solutions. There is often common need to do integration between the two. Despite the fact that both systems come from the same software development company ? the integration is not as simple as it probably should be.

In each case you have to use set of new Microsoft technologies: web service, SQL stored procs, C#, VB.Net programming, etc. In this small article we give you customization overview when you receive Purchase Order Receivings in Great Plains and automatically transfer them to the RMS Store Operations via web services. Plus we can push serial number info from Great Plains to Store Operations (there is no way to store serial number in Headquarters)

Item Transfer Trigger in Great Plains

Microsoft Great Plains is written in Great Plains Dexterity ? proprietary programming language and development environment, which has strong ties with SQL stored procedures and queries

When Items are transferred in Great Plains via the Item Transfer Entry window, the interface must recognize this transaction. This can be accomplished via two mechanisms:

1. Dexterity Trigger, which would identify that the transfer occurred and it would populate an interface table

2. SQL Trigger on IV00200, which would populate an interface table. The assumption is that all transferred items will be serialized

Handling Headquarters Initiated Inventory Transfer Requests

Once the interface table is populated, there might be either a timed procedure or a trigger that will push the transfer from Great Plains into RMS Headquarters and it will create automatically a Style 307 Worksheet in Headquarters.

The next time that the store "receiving" the inventory communicates with Headquarters, it will receive the Inventory Quantity Adjustment notification, which will increase the item's quantity on hand.

In each store, a web service should be installed to handle transfer of Serial Number information. Therefore, when communication is established between Store Operations and Headquarters, an application that continuously monitors Stores (in the computer hosting Headquarters) will communicate with the web service at the Store level to transfer the Serial Number information and to update the serial number tables in Store Operations.

About The Author

Luis Leung is Lead Software Developer in Alba Spectrum Technologies ? USA nationwide Microsoft RMS, CRM, Microsoft Great Plains customization company, with offices in Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Dallas, Atlanta, Miami, Montreal, Toronto, Vancouver, Madrid, Moscow, Europe, Brazil, Mexico (, he is Microsoft CRM SDK, C#, VB.Net, SQL, GP Dexterity developer. Luis can be reached: 1-866-528-0577 or

In The News:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at


This Call May Be Monitored for Tone and Emotion
We all know how it feels to be low on energy at the end of a long work day. Some call-center agents at insurer MetLife are watched over by software that knows how it sounds. A program called Cogito presents a cheery notification when the toll of hours ...


How Software Maker Tableau Helps Doctors Tame Data
Aaron Black calls it “hand-to-hand combat”: the time-consuming, painful battle to convert a Tower of Babel of information into life-saving guidance for doctors and researchers. Black is chief data officer at the Inova Translational Medical Institute, a ...


BlackBerry gains after announcing software expansion, Microsoft partnership
BlackBerry Ltd. BB, -1.78% shares gained in late trading Monday after the company announced an expansion of its security-software gambit that includes a new partnership with Microsoft Corp. MSFT, -1.81% BlackBerry detailed plans for BlackBerry Secure ...
BlackBerry says new software bridge to Microsoft products will increase securityNews1130

all 15 news articles »

Oracle stock falls as earnings, outlook fuel doubts about cloud software growth
Oracle Corp. shares declined in the extended session Monday after the enterprise software company's quarterly earnings report and forecast did not show the cloud-software growth Wall Street expected. Oracle ORCL, -0.61% shares fell 3.7% in immediate ...

and more »


AI is becoming ubiquitous across enterprise software
This week at IBM Think, it will be difficult if not impossible to avoid the glare of artificial intelligence. With Watson, IBM has bet its reboot on AI. And with attention has come market pressure to make AI more accessible. We posted several months ...

Drone DJ

Software update for the Skydio R1 drone
Drone DJ
Skydio just came out with their fully autonomous R1 drone a few weeks ago and here is the first software update. Some of the improvements include short processing time of the video footage after flights, automatically attempt to reconnect in case of a ...


UK software firm Micro Focus suffers share price collapse
The company added it was grappling with the impact of its recent $8.8 billion (7.2 billion euro) purchase of software assets of Hewlett Packard Enterprise (HPE). The deal was completed last September. Micro Focus added that boss Chris Hsu, a former HPE ...
A firm bought assets from Hewlett Packard Enterprise. Its CEO has now quit and shares are tankingCNBC
Micro Focus value halves after warning on revenueThe Times
Shares of software giant Micro Focus plummet 46 percent as CEO Chris Hsu quitsSiliconANGLE News (blog)
The Guardian
all 83 news articles »

Pirelli using new software to spice up F1 strategies in 2018
Pirelli has developed new software to help it choose race-by-race Formula 1 tyre compounds in order to encourage two pit stops per event, and give teams more strategy options. The Italian company is using simulations to find the best combination of ...
Pirelli using new software to spice up F1, Edition: Global

all 2 news articles »


Xilinx debuts software programmable chip design in data center push
This enables a fundamentally different software centric design flow since all of the connectivity infrastructure is natively software programmable." Xilinx CEO Victor Peng explained that the company's past products have all had some level of ...
FPGA maker Xilinx aims range of software-programmable chips at data centersNetwork World

all 19 news articles »

Baltimore Business Journal

Baltimore software firm Sema Labs raises $500000
Baltimore Business Journal
CEO Matt Van Itallie described Sema Labs as a "software company that writes software to fix other software." He started the company in July last year, after doing extensive research on software maintenance. He previously had jobs in the public and ...

Google News

Reloading Windows XP

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

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

Spyware: What It Is and How to Combat It

Spyware is software or hardware installed on a computer without... Read More

SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

Ok... Where to start?Well, I guess I will start at... Read More

Cross-Platform Custom Software Development & Integration ? IT Strategy for Large Corporation

Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More

A Case Study on Selecting Contract Management Software

Professional services firm cuts costs and improves productivity with integrated... Read More

How To Create A Data Capture Procedure Checklist For Your Small Business CRM Software

Fortunately one of the most common reasons cited for the... Read More

Tripwire for Linux File Integrity

What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More

Running a Program on a Remote Server Using SSH

How do you run a program on a remote server... Read More

Backing Up And Restoring Your MySQL Database

If you've been using MySQL database to store your important... Read More

New SQL Delta Version 3.1

COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

Great Plains DOS Support ? Notes for Consultant

Great Plains Accounting, accounting package for mid-size and small companies... 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

Great Plains Dexterity Programming ? Overview For Developer

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

Put Some Pizazz in Your Software Arsenal

The software giants don't do everything and don't always produce... Read More

Interactive Mapping Brings Information to Life

What is Interactive Mapping?Interactive mapping is a visual display medium... Read More

Microsoft Great Plains Furniture & Fixtures ? Implementation & Customization Highlights

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

OLAP, An Alternative Technology Over Spreadsheets

Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

Should I Use Windows Update?

Should one use Windows Update?This topic has good and valid... Read More

Outlook... Not Just for Email! Using Your Outlook Calendar

Microsoft Outlook is one of the most widely used software... Read More

A Simple Computer Software Definition

What is Software?Software is a set of instruction written to... 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

Microsoft Great Plains - Microsoft RMS Integration ? overview

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

Linux Vs. Windows

This article will not attempt to advocate the use of... Read More

Easy Guide to RAID Recovery

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