|
|
[description], Story, any other text you want to use.
Microsoft RMS Customization – PO Items Receiving in Great Plains
by: Luis Leung
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.
|
community 2 web tv net
There must be something of value for you here. community 2 web tv net is one of our big interests and we are developing this website into a mega portal. We'd love you to bookmark us and come back one day. Soon we might well be the leading community 2 web tv net website.
But not yet, of course, which is why we're linking to some other community 2 web tv net sites. Currently they're the best around, for both information and buying. So for all your community 2 web tv net needs we suggest you visit them right now. You won't be sorry you did. We've done a lot of research in this field and can assure you that they're the best on the web for just what you're looking for. you don't need to search any further. Remember to come back to our humble site one day though, because soon we're going to take the crown as the best site for community 2 web tv net.
Broadcast On the Net Index
|
Main Menu
Broadcast On the Net
Site Map
Affiliate Ads, Links, news, etc.
News for 21-Aug-26 Source: BBC News - Home Carrie Fisher: Star Wars actress suffers heart attack Source: BBC News - Home Libya Malta hijack: Hijackers arrested as drama ends peacefully Source: BBC News - Home How to stop social media videos autoplaying Source: BBC News - Home The longest kiss Source: BBC News - Home Trump official Paladino under fire over crude Obama remarks Source: BBC News - Home Kim Ghattas: Trump's Syria conundrum Source: BBC News - Home Preserving Mali's rural life Source: BBC News - Home British passenger missing from Queen Mary 2 liner Source: BBC News - Home Libyan hijacker arrested in Malta Source: BBC News - Home May Christmas message urges unity after Brexit vote
Links
Links
Links
|