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.
Bradley bmw rental chicago .. Lockport Chicago limo O’HareThere are two major WYSIWYG(What You See Is What You... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
This article is the third of a series of articles... Read More
Microsoft Great Plains is becoming more and more popular and... Read More
Background: For many organizations like ours, the interim target of... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
2005 ? Back to the Future.What does the future hold?... Read More
Some introduction into Great Plains Software products, now Microsoft Business... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
When you own a small business, time is money. And... Read More
Microsoft Business Solutions Great Plains is very popular ERP platform... Read More
The objective for Zandi Digital is to make available clever... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Learning how to program software seems like a daunting task... Read More
With the advent of 'Service Pack 2' for Windows XP... Read More
When Great Plains Software introduced the first graphical accounting application... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
If you are software developer or database administrator - we... Read More
The first thing that you will notice about Linux Red... Read More
Manufacturing in the USA is far away down from mid... Read More
Remember back in the days where screensavers were the coolest... Read More
Fortunately one of the most common reasons cited for the... Read More
prom limo McHenry ..Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More
Icons are used everywhere; right from software applications, to internet... Read More
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Microsoft Business Solutions Great Plains, Navision, Axapta, Solomon and CRM... Read More
Hi, Guys,I believe a lot of programmers are trying to... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Domino server is a buffer between the operation system and... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
The Internet is reshaping every form of communications medium, and... Read More
In the previous ISDN article, we looked at how and... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
MS CRM is very close to document workflow automation, including... Read More
Are you a whiz at calculating financial information? Not the... Read More
Having from five to ten and more favorite screensavers is... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
In linux, one of great commands for finding out information... Read More
After seeing many people complain about their weak Internet security... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
In a previous article, I wrote about OpenOffice... Read More
We don't think about mainframe software pricing anymore, we just... Read More
Many reasons made GBM a unanimous choice for experts, one... Read More
Small can be beautiful! Working with Knoppix for the past... Read More
Software |