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 www.albaspectrum.com.

shuttle from O'Hare Brocton .. Lockport Chicago limo O’Hare
In The News:

Unitree, a Chinese robotics company that developed a backflipping robot, has now introduced a humanoid robot capable of doing a side flip.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
According to the FBI, cybercriminals are sending extortion letters, threatening to release victims' sensitive information unless a ransom is paid.
FireSat is a satellite project designed to detect and track wildfires early, aiming to detect a fire that's the size of a classroom within 20 minutes.
Tech expert Kurt “CyberGuy" Knutsson reports that researchers have uncovered a Chrome vulnerability used in a cyber espionage campaign.
Preserving voicemails securely on Android: Tech expert Kurt “CyberGuy" Knutsson reveals easy methods to keep memories alive forever.
This phishing kit bypasses 2FA via session hijacking and real-time credential theft. Kurt “CyberGuy" Knutsson offers four ways to stay safe from Astaroth phishing attacks.
Tech expert Kurt “CyberGuy" Knutsson discusses Joby Aviation and Virgin Atlantic planning to launch 200-mph U.K. air taxis linking airports and cities.
Fake Apple virus warnings, security alerts and messages are tactics used to prompt you to call a number or click on a malicious link. The CyberGuy explains how to protect your devices.
The combination of artificial intelligence and neuroscience allows a paralyzed man to manipulate a robotic arm by using his brain to imagine movements.
With the help of artificial intelligence, sophisticated fraud techniques emerging today are virtually undetectable to the untrained eye.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents
If you need to free up space on your Mac, consider deleting duplicate photos in your image library. Apple makes it easy to do, and the CyberGuy explains the process.
Microsoft is discontinuing Skype in May after 22 years of service. Kurt the CyberGuy addresses other options for internet-based phone and video service.
Tron 1, a Chinese company's two-legged robot, is versatile and can walk, roll and pivot, even on rough terrain. Tron 1 stands 33 inches tall and weighs 44 pounds.
Hackers are tricking people into installing password-stealing malware by making them press keyboard shortcuts under the pretense of proving they're not bots.
Saving the voices of loved ones can be a comforting way to keep alive memories. Kurt "the CyberGuy" Knutsson explains how to preserve voicemail messages.
Stay up to date on the latest AI technology advancements and learn about the challenges and opportunities AI presents now and for the future.
The FBI warns that some free online document converters load malware onto people's computers, making their private information vulnerable to attack.
Toyota's compact electric FT-Me is designed to tackle challenges of city living while offering an accessible and eco-friendly transportation solution.
Kurt “CyberGuy" Knutsson says 23andMe's bankruptcy raises data privacy fears: Opt out, download and delete data now.
UBTech and Zeekr unite with AI robot swarms to make car manufacturing faster and smarter. Tech expert Kurt “CyberGuy" Knutsson explains how the process works.
Tech expert Kurt “CyberGuy" Knutsson says Apple's Passwords app had a three-month phishing flaw from iOS 18 to 18.2 patch.
Tech expert Kurt “CyberGuy" Knutsson discusses how this super-small electric mini-truck takes a big step toward production.
Artificial intelligence-generated images and videos that use someone’s likeness typically target women without their consent. The CyberGuy unpacks how to protect loved ones.

Crystal Reports for Microsoft Great Plains

Microsoft Business Solutions ? Great Plains is designed to meet... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More

Information Products: A Business Owners Best Friend

We live in a post-industrial age where information is the... Read More

Unwanted Files

A LOT OF UNWANTED FILES.When you uninstall an item of... Read More

What You Should Know About Installing Screensavers

Do you remember that frustrating feeling when you find an... Read More

Cisco CCNA Certification: Becoming A Truly Valuable CCNA.

I've been active in the Cisco Certification track for four... Read More

Reloading Windows XP

If you have been running Windows XP for a couple... Read More

Ukraine IT Myths Dispersed

While Ukraine is becoming a new popular IT outsourcing destination,... Read More

OEComplete ? A Personal Information Manager

OEComplete is a utility for managing the personal information of... Read More

Microsoft Great Plains Upgrade ? Things to Consider and FAQ

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

Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

Microsoft Retail Management System serves retail single store as well... Read More

HSphere Control Panel Tips and Tricks - Power At Your Fingertips: Part 1

The first topic we are going to discuss... Read More

Guide to Software Marketing

Intro This concise article will tell you in plain English... Read More

Beware of The Pirated Software E-Mail Scams!

You have gotten those E_Mails buy software at deep discounts.... Read More

Microsoft CRM Lotus Notes Domino Connector FAQ

Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More

Microsoft Great Plains PM: Payables Management

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft CRM Customization - Processing In/Out-Going Email Messages

We would like to give you several situations, when you... Read More

How To Make Good Use of Spreadsheets

Most computer users use spreadsheets software such as Microsoft Excel... Read More

Microsoft Great Plains: Customization Upgrade & Recovery ? Visual Studio VB 6.0

Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has... Read More

Windows x: Basic Windows ?Security? Issues

Language development computer: Computer-based method for aiding language development seems... Read More

Best Practices In Choosing Network Monitoring Software

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

Google Brings the Earth to Your Desktop

Google Inc. has launched a new software package that allows... Read More

Microsoft Great Plains & CRM in Transportation & Logistics ? Overview

Microsoft Business Solutions Great Plains and MS CRM (client relation... Read More

Tripwire for Linux File Integrity

What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More

Dashboard Widgets for Windows

For a windows user like me, just can watch with... Read More

Chicago charter limousine service Hickory Hills ..