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 www.albaspectrum.com.
shuttle from O'Hare Brocton .. Lockport Chicago limo O’HareMicrosoft Business Solutions ? Great Plains is designed to meet... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
We live in a post-industrial age where information is the... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
Do you remember that frustrating feeling when you find an... Read More
I've been active in the Cisco Certification track for four... Read More
If you have been running Windows XP for a couple... Read More
While Ukraine is becoming a new popular IT outsourcing destination,... Read More
OEComplete is a utility for managing the personal information of... Read More
If you have Microsoft Great Plains and support it for... Read More
Microsoft Retail Management System serves retail single store as well... Read More
The first topic we are going to discuss... Read More
Intro This concise article will tell you in plain English... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
We would like to give you several situations, when you... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
Google Inc. has launched a new software package that allows... Read More
Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
For a windows user like me, just can watch with... Read More
Chicago charter limousine service Hickory Hills ..DBxtra goes ASPGetting to the information hidden within corporate databases... Read More
Some companies that are in need of fleet management may... Read More
Disclaimer: All the thoughts expressed are my views only! Your... Read More
Looks like Microsoft Great Plains becomes more... Read More
There are two major WYSIWYG(What You See Is What You... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Microsoft Business Solutions Great Plains has substantial market share among... Read More
It would be easy to think, like most people apparently... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Well, even if the combination might look very unusual, we... Read More
What is a Web Database?A web database is a database... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
The first topic we are going to discuss... Read More
One of the things we can be as certain of... Read More
Whether you are an experienced web programmer or a complete... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
The title of "software engineer" has got to be among... Read More
In this small article we will show you the possible... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Trying to figure out a stream in banning one email... Read More
If you copy something from a Web site or elsewhere...... Read More
New post-recession era has new features, which didn't exist in... Read More
Software |