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.
If you have Microsoft Great Plains and support it for... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Linux essentials:It's free for download but you have to pay... Read More
Need help making sense of algebra? Have algebra lectures in... Read More
Microsoft Great Plains fits to majority of industries, in the... Read More
Spyware is software or hardware installed on a computer without... Read More
Accounts payable is just one area of office management where... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
I have always had a tendency to focus on the... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
Shareware has been fighting the stigma of being misunderstood for... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
XML Server can be a Web Server that stores the... Read More
Itâ??s easy to understand why you might be drawn to... Read More
This article is the first of a series of articles... Read More
While I was preparing some personal background information for a... Read More
Adware is a type of Spyware program that displays some... Read More
NOTE: Please take time to read on - it may... Read More
Beginning with Domino version R4 it has integration with the... Read More
Fleet Maintenance Management is a critical position in any company... Read More
DBxtra is a powerful query and reporting tool that hides... Read More
With many manufacturing shops heading over seas in favor of... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
After seeing many people complain about their weak Internet security... Read More
Although statistics often is blamed for various deadly sins --... Read More
Spyware and Adware infest over 90 percent of computers in... Read More
When you think... Read More
When you need a phone number, you do a quick... Read More
As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More
If you feel intimidated when someone tries to teach you... Read More
It is now common thing when large corporation selects mid-market... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
What is Software?Software is a set of instruction written to... Read More
The Internet is reshaping every form of communications medium, and... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
The research in the field of Natural Language Processing usually... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
Whether you have used Microsoft Word for years, have just... Read More
Traditionally we were considering functionally rich systems, such as SAP,... Read More
Mike Dunville* had a decision to make. As the new... Read More
It is possible that if one avoided all sources of... Read More
Since technology changes so quickly, it is hard to begin... Read More
At the end of XX century, in the late 1990th... Read More
One of the things we can be as certain of... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
When you visit department stores and see that majority of... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
We live in a post-industrial age where information is the... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
So let's begin crunching down these 300 images using Adobe... Read More
1. With mapping software you can create a report that... Read More
I have always regretted how Microsoft price gouges and rips... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Software |