|
Article:
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 IV'00200
|
