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:

Los Angeles Times

Software for supervising students
Los Angeles Times, CA - 4 hours ago
Here's an overview of some of the more popular programs: MealpayPlus: A program from Horizon Software International that lets parents go online to put money ...
Online tools let parents peer into their kids' school day Los Angeles Times
all 4 news articles


Times Online

Open Sauce Software
ZDNet UK, UK - 1 hour ago
Chrome is still my default browser, and there are everyday things I can't do so easily in it as in Firefox. Perversely. I think what I want is a Google ...
Video: Tech Test: Google Chrome Lacks Polish AssociatedPress
Google Chrome: A Hit with Online Software Vendors CIO
How will Google Chrome change the user experience on the web? CNET News
MarketWatch - Reuters
all 3,435 news articles


Lieberman Software Launches Virtual Server Management Initiative
MarketWatch - 22 hours ago
LOS ANGELES, Sep 04, 2008 (BUSINESS WIRE) -- Lieberman Software's User Manager Pro Suite, a configuration management solution for Windows-powered servers ...
Vendors scramble to rein in virtual environments NetworkWorld.com
Azaleos' OneServer Now Supports Microsoft Hyper-V Server TMCnet
Hyper-V Virtual Monitoring Appliance Debuts at Microsoft Conference WebWire (press release)
MarketWatch
all 23 news articles


Sun to Craft Software Stack Into NAS Appliances
PC World - 10 hours ago
Sun Microsystems will introduce a storage appliance based on its FISHworks software package by the end of this year and later extend the technology to other ...


Roper Industries buys Horizon Software
Bizjournals.com, NC - 16 hours ago
Horizon, based in Duluth, Ga., will continue to market its products and services under its current brand names and will become part of Roper’s radio ...
Roper Acquires Horizon Software, Expands K-12 Business with Food ... Education Channel Partner
Lakewood Ranch company acquires software player Sarasota Herald-Tribune
Roper Industries Acquires Horizon Software International MarketWatch
SunHerald.com
all 14 news articles


Advent to Acquire Leading Research Management Solution (RMS
Bobsguide (press release), UK - 2 hours ago
“We chose Tamale Software because, as the clear industry leader and a pioneer in the field of RMS, they bring unparalleled vision and a track record of ...
Advent acquires Tamale Software Banking Technology (subscription)
Advent acquires research management outfit Tamale Finextra
all 3 news articles


Arxan Hosts Complimentary Webinar on Software Protection Best ...
PR Web (press release), WA - 3 hours ago
What application hardening and software protection best practices can be put to use so companies can take back control of their applications and revenues. ...


Schools Consider Software Update
Tampa Tribune, FL - 7 hours ago
By RONNIE BLAIR LAND O' LAKES - The Pasco County School District is considering replacing its outdated computer software with something new that could ...


An Examination of China's Software Outsourcing Market in 2007 ...
MarketWatch - Sep 3, 2008
In 2006, China's offshore software outsourcing market reached US$1.43 billion (about US$ 50 billion of the world), an increase of 55.4 percent year-on-year. ...
China's Mobile Internet Device (MID) Market Research Report ... MarketWatch
Fully Comprehensive Market Outlook Detailing United Kingdom's ... MarketWatch
all 258 news articles


Software engineering degree coming to SUNY Oswego
NewsChannel 9 WSYR, NY - 7 hours ago
Oswego, New York (WSYR-TV) – Central New York students looking to major in software engineering now have a cheaper, closer option to choose from. ...
Software Added SUNY Oswego
all 2 news articles

Software - Google News

home | site map
© 2006