Software Information

Microsoft RMS Customization - PO Items Receiving in Great Plains


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.


MORE RESOURCES:

Uganda Telecom Launches User Friendly Voice SMS Service on Kirusa ...
MarketWatch - 11 hours ago
... offers video telephony, high speed internet, video and audio streaming, live television and MMS. uganda telecom also provides BlackBerry(R) services. ...


Twice

New Bluetooth Kits Debut With Speech Capability
Twice, NY - 20 hours ago
The Ego Flash Bluetooth kit has a 1.6-inch display and adds audio streaming from an iPod or MP3 device at $243. The Ego Look has similar features with a ...


Uganda Telecom Launches User Friendly Voice SMS Service on Kirusa ...
International Business Times, NY - 11 hours ago
... and offers videotelephony, high speed internet, video and audio streaming, live televisionand MMS. uganda telecom also provides BlackBerry® services. ...


WKSR Programming Is Back Online
Giles News, TN - Nov 25, 2008
Station Manager Ronnie Rose announced that the audio streaming of programming content for WKSR 98.3 FM and Rocky AM 1420 is again available online to ...


Digital Rapids' TouchStream Named 'Most Innovative Product' At ...
4RFV, UK - 18 hours ago
... video and audio streaming appliance was honoured with the Most Innovative Product award at the Broadcast India exhibition in Mumbai last month. ...


MobileTechRoundup 155: Storms, Legends and Teleportation
jkOnTheRun, Texas - Nov 30, 2008
Kevin is testing out the Sonos audio-streaming solution and the iPhone remote application for it highlights why smartphones without WiFi bring obstacles. ...


Phonak and NXP Develop New Ultra Low Power Wireless Communication ...
MarketWatch - Nov 26, 2008
"Our chip does support a high data rate of up to 298 kbps and bi-directional communication, enabling novel applications such as stereo audio streaming and ...


Junior Blues this weekend
The State Journal-Register, IL - Nov 28, 2008
There is no audio streaming or radio. FOR THE RECORD: The Blues (7-12-4) are in third place in the South Division of the North American Hockey League. ...


Underdog Walsh plans to have fun, learn at volleyball nationals
Canton Repository (subscription), OH - Nov 27, 2008
JumpTV Inc. is the exclusive provider of live video and audio-streaming at the NAIA Volleyball Championships. JumpTV will stream the quarterfinals, ...


Appscout

Courtney Holt Named President of MySpace Music
Appscout, NY - Nov 26, 2008
MySpace Music, which combines audio streaming with download functionality powered by Amazon, made its debut in September. It currently features songs from ...

Audio-Streaming - Google News

Generic Club Football UK E-shop  Top of Page home | site map  home Bookmark Us Now ctrl+d 1st 4 Games, shopping via this site cost no more than going direct and can often save you money with special offers. with questions or comments about this website, contact: Doug Carpenterposter shopping directory, shopping mall, poster online stores, directory, shopping mall directory, online shop, gifts, posters, art, prints, artist, order, malls, internet mall, shops 1st4games offer Video Games PC and Video Games, PlayStation 2, PC Games, Xbox, GameCube, Game Boy Advance and PSone