The Best Listen On The Net Web site

  Listen On The Net
The time for standing in place is gone and anyone who wants the best in Listen On The Net should understand that. There are many people who want to know more about Listen On The Net and since you are here you must be one of them. Anyway we are happy to have you as a visitor and want to make your visit worthwhile.

There are a number of Listen On The Net websites on the Internet as you surely know. Some are worthwhile and others are completely worthless. We pride ourselves on providing only the most valuable information on Listen On The Net available. 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 (, he is Microsoft CRM SDK, C#, VB.Net, SQL, GP Dexterity developer. Luis can be reached: 1-866-528-0577 or

WDBZ's Mr. Listen On The Net WDBZ's Mr. Listen On The Net WDBZ's Mr. Listen On The Net WDBZ's Mr. Listen On The Net WDBZ's Mr. Listen On The Net WDBZ's Mr. Listen On The Net

Home | Site Map

Sign up for PayPal and start accepting credit card payments instantly.

News for 12-Mar-18

Source: BBC News - Home
Ken Matheson: Former British Cycling coach says 'culture of fear' exists

Source: BBC News - Home
Carrie Fisher: Star Wars actress suffers heart attack

Source: BBC News - Home
Kim Ghattas: Trump's Syria conundrum

Source: BBC News - Home
Drip dry

Source: BBC News - Home
Wedding gift alpaca has 'surprise' baby

Source: BBC News - Home
Africa's top shots: 16-22 December 2016

Source: BBC News - Home
Yemen's displaced

Source: BBC News - Home
Trump official Paladino under fire over crude Obama remarks

Source: BBC News - Home
The technology of touch

Source: BBC News - Home
Israel settlements: Netanyahu snubs 'shameful' UN vote

Main Menu
Listen On The Net
Site Resources

Free Tell A Friend from

Last Updated: Monday, 12-Mar-2018 00:01:01 MDT
Copyright © 2004 :: Listen On The Net
Medical Meetings :: Go Meetings :: Medical Meetings :: Fantasy Football Information

Listen On The Net

fantasy-sports-directory   MD Meet   Net Meetings