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.
![]() |
|
![]() |
|
![]() |
|
![]() |
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
You've finally created databases that you can actually use to... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
In the early days of the personal computer, we're talking... Read More
So, why should you use any O/R mapping tool? I... Read More
I love new technology. I am still ready to wait... Read More
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
In today's business world it's all but impossible to escape... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
It's all about turn times in the eMedia industry! The... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Most people understand that the "hardware" part of their computer... Read More
Did you ever want to erase everything on your computer?... Read More
While paper labeling CDs and DVDs may appear to be... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
The vast majority of us will have, at some point,... Read More
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More
Crystal Reports is the most flexible tool on the market... Read More
When you buy a computer, it most likely comes with... Read More
Internet worms. Is your PC infected?If your computer has become... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
There are so many different programs that clutter up your... Read More
Now that spyware is the single most dangerous threat to... Read More
Not every software testing project can or should be automated.... Read More
We live in a post-industrial age where information is the... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
How do you run a program on a remote server... Read More
The fact that a software tester is a most infamous... Read More
Microsoft Business Solutions ? Great Plains has captured the US... Read More
In today's business world it's all but impossible to escape... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
After almost two decades of existence, Quark has become the... Read More
If you feel intimidated when someone tries to teach you... Read More
Did you ever want to erase everything on your computer?... Read More
If you have been using the Internet for any amount... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
The term "document management" and "paperless office" is the subject... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
Executive SummaryAn effective plan for entering, cleaning and updating the... Read More
Once upon a time not so long ago, there was... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
In linux, one of great commands for finding out information... Read More
If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More
We all take the computer for granted. I mean, all... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
Beginning with Domino version R4 it has integration with the... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
The intentions of this short tutorial are not to teach... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
While I was in college, if you would have asked... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
Software |