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 (www.albaspectrum.com), he is Microsoft CRM SDK, C#, VB.Net, SQL, GP Dexterity developer. Luis can be reached: 1-866-528-0577 or help@albaspectrum.com.
![]() |
|
![]() |
|
![]() |
|
![]() |
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
Microsoft Great Plains and Microsoft CRM become more and more... Read More
Many reasons made GBM a unanimous choice for experts, one... Read More
OEComplete is a utility for managing the personal information of... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
If you are software developer or database administrator - we... Read More
With any good luck and a good amount of hard... Read More
Manufacturing in the USA is far away down from mid... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Microsoft Great Plains, designed back in 1990th as database transferable... Read More
If you have Microsoft Great Plains and support it... Read More
In the Clinton era the status quo was simple: you... Read More
You probably didn't casually invite, or extend a formal attendance... Read More
2005 ? Back to the Future.What does the future hold?... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
The most important benefit of XML is its simplicity. Though... Read More
Once upon a time not so long ago, there was... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
.Net Framework is a platform or development environment to seamlessly... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
The first thing that you will notice about Linux Red... Read More
Microsoft Business Solutions Great Plains is very popular ERP platform... Read More
Writing software manuals is boring, isn't it? We often think:... Read More
When Great Plains Software was designing and developing Great Plains... Read More
I have recently created my first Php program. I wanted... Read More
Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Let us give you - developer some hints in the... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
I love new technology. I am still ready to wait... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
The java programming language is becoming more and more popular... Read More
If you have been running Windows XP for a couple... Read More
Spyware is software or hardware installed on a computer without... Read More
We live in a post-industrial age where information is the... Read More
Our hosted solution allow you to run your own search... Read More
Most people understand that the "hardware" part of their computer... Read More
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
I have yet to see a business that, sometimes in... Read More
Introduction to C++Why Learn C++?C++ may at first seem like... Read More
Scrapbooks are very popular these days. I think that almost... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
This article is the fourth of a series of articles... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
When Great Plains Software introduced the first graphical accounting application... Read More
We would like to give you several situations, when you... Read More
DBxtra is a powerful query and reporting tool that hides... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
There are several kinds of software piracy. The bottom line... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
If you company is small or mid-size special products or... Read More
We don't think about mainframe software pricing anymore, we just... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
There are plenty of articles out there about how to... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
Software |