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.
Culver prom limo ..The most important things you can do for your computer... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
Around the same time Microsoft made its move with .Net... Read More
Navision Software was purchased by Microsoft and now it is... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
There are several kinds of software piracy. The bottom line... Read More
Microsoft CRM is new player on the CRM software... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
I like my software simple. If it's too complex or... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
It is possible that if one avoided all sources of... Read More
If you are software developer or database administrator - we... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
Usually, the easiest way to tell you have spyware is... Read More
Should one use Windows Update?This topic has good and valid... Read More
Sometimes your PC will start acting strange for no apparent... Read More
In the early days of the personal computer, we're talking... Read More
All your software is stored on a hard-drive. But how... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
If you are in a business that passes documents around... Read More
Fortunately one of the most common reasons cited for the... Read More
Wood Dale limo ..It's no secret that software companies operate in a very... Read More
Microsoft Business Solutions Great Plains was historically designed to serve... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Ad-Aware and Spybot are probably the two most well known... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
When reading an article where some term is used often,... Read More
Fleet Maintenance Management is a critical position in any company... Read More
DBxtra goes ASPGetting to the information hidden within corporate databases... Read More
If you are in the market for new staffing software,... Read More
In today's business world it's all but impossible to escape... Read More
The title of "software engineer" has got to be among... Read More
OEComplete is a utility for managing the personal information of... Read More
Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More
What is Spyware?Spyware monitors your surfing habits and sends the... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
I like my software simple. If it's too complex or... Read More
Accounts payable is just one area of office management where... Read More
Almost all new and major brand of PCs come with... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
2005 ? Back to the Future.What does the future hold?... Read More
Software |