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.

In The News:


pen paper and inkwell


cat break through


Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics ? highlights

Microsoft bought Navision, Denmark based software development company, along with... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and... Read More

Cisco Certification: Introduction To ISDN, Part III

Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More

CRM and Customer Life Cycle

Customer Relationship Management or CRM is a combination of enterprise... Read More

International Support - Microsoft Great Plains VAR/Partner Selection ? Overview for V.P. IT

Looks like Microsoft Great Plains becomes more and more popular,... Read More

Know Linux

Linux essentials:It's free for download but you have to pay... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Microsoft Great Plains Chemicals & Paint Industry Implementation & Customization Notes

Microsoft Great Plains fits to majority of industries, in the... Read More

Spyware: What It Is and How to Combat It

Spyware is software or hardware installed on a computer without... Read More

Accounts Payable: A Powerful Document Management and Workflow Solution

Accounts payable is just one area of office management where... Read More

How to Make Attractive and Effective PowerPoint Presentations

Microsoft PowerPoint has dramatically changed the way in which academic... Read More

Rapid Application Development - Is it Really a Need of Today?

Rapid Application Development (RAD) is a software development methodology. In... Read More

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Adware and Spyware

What is 'adware'?Adware is basically software or scripts that are... Read More

About Microsoft Sysprep (System Preparation) Utility (Windows 2000)

The Microsoft system preparation utility for Windows 2000 is a... Read More

The Religion And Philosophy Of Small Internet Business

I have always had a tendency to focus on the... Read More

Where to Find Free Fleet Maintenance Software

Costs of fleet maintenance software can vary widely. It is... Read More

Best Practices In Choosing Network Monitoring Software

Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More

Call Alert Notifications - Free Answering Machine Software for PCs

If you're online using a dialup Internet connection, you'll probably... Read More

Understanding XML Server

XML Server can be a Web Server that stores the... Read More

Pros and Cons of Using FREE Software in Your Business

Itâ??s easy to understand why you might be drawn to... Read More

Groupware and Version History: Collaboration Series #1

This article is the first of a series of articles... Read More

Programming Language Migration Path

While I was preparing some personal background information for a... Read More

Adware, What Is It?

Adware is a type of Spyware program that displays some... Read More

Your Computer May Be Infected, Heres How To Check (NOT about virus)

NOTE: Please take time to read on - it may... Read More

Lotus Notes Domino and Web: Application Development ? Tips for Programmers

Beginning with Domino version R4 it has integration with the... Read More

What is Fleet Maintenance Management?

Fleet Maintenance Management is a critical position in any company... Read More

Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool

DBxtra is a powerful query and reporting tool that hides... Read More

Why do Manufacturers Invest in Business Management Software?

With many manufacturing shops heading over seas in favor of... Read More

Microsoft Great Plains Integration with Legacy Systems ? Overview For Developer

Looks like Microsoft Great Plains becomes more and more popular,... Read More