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:

Elliott Terminates Tender Offer to Acquire Epicor Software Corporation - MarketWatch

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/0i-0fd=Rurl=http://www.earthtimes.org/articles/show/epicor-comments-on-the-termination-of-elliott-associatesrsquo-tender-offer,632860.shtmlcid=1272902427ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNHkZ2d1sawqpJWsd2aI8qRbSFfs3gimg src=http://news.google.com/news?imgefp=-zwqhIcofgUJimgurl=www.earthtimes.org/newsimage/Bus_20081121191102_35.jpg width=80 height=80 alt= border=1brfont size=-2Earthtimes (press release)/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/0-0fd=Rurl=http://www.marketwatch.com/news/story/Elliott-Terminates-Tender-Offer-Acquire/story.aspx%3Fguid%3D%257B715050E5-AD0A-4808-A8D6-38ED8DF5BC63%257Dcid=1272902427ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNH27-joKpfIwzmylsxAVQYPMJAyeQElliott Terminates Tender Offer to Acquire Epicor bSoftware/b Corporation/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr15 hours ago/nobr/fontbrfont size=-1b.../b LP and Elliott International, LP (collectively, quot;Elliottquot; or quot;wequot;), a major shareholder of Epicor bSoftware/b Corporation (the quot;Companyquot; or quot;Epicorquot;), b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-1fd=Rurl=http://www.forbes.com/feeds/ap/2008/11/21/ap5729568.htmlcid=1272902427ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNHiqUWSXYlZjcKBzo51mb58_lUAMQEpicor drops after hedge fund ends hostile bid/a font size=-1 color=#6f6f6fnobrForbes/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-2fd=Rurl=http://www.ocbj.com/industry_article.asp%3FaID%3D75658381.8793711.1711307.8237208.5233255.264%26aID2%3D131630cid=1272902427ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNHF6EPYNKNk0-hCuQE9Z4pth0UDbgHedge Fund Elliott Associates Withdraws Offer for Epicor bSoftware/b/a font size=-1 color=#6f6f6fnobrOrange County Business Journal/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-3fd=Rurl=http://www.reuters.com/article/mergersNews/idUSBNG18344320081121cid=1272902427ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNFSeMQneKPejAkjaxN5FR5fOTz9MgUPDATE 1-Hedge Fund ends offer for Epicor/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/0-4fd=Rurl=http://www.rttnews.com/ArticleView.aspx%3FId%3D782142%26SMap%3D1cid=1272902427ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNHAoc9PqEW88_bhXLFibC4hza8yyAnobrRTT News/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/0-5fd=Rurl=http://blogs.barrons.com/techtraderdaily/2008/11/21/epicor-elliott-associates-drops-bid-stock-tumbles/cid=1272902427ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNGHeBQu0ejDInh_z-gpIjuAKJMRgQnobrBarron's Blogs/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272902427hl=ennobrall 44 news articles/nobr/a/font/div/font/td/tr/table

The best thing about the 2.2 iPhone software update - CNET News

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/1i-0fd=Rurl=http://gadgetwise.blogs.nytimes.com/2008/11/21/picture-google-street-view-on-the-iphone/cid=1272850889ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNEv4iUdhpHboJ66JQO1YykHjXeVygimg src=http://news.google.com/news?imgefp=DbM9qO9EamEJimgurl=graphics8.nytimes.com/images/2008/11/21/technology/personaltech/iphonemap2.480.jpg width=80 height=32 alt= border=1brfont size=-2New York Times/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/1-0fd=Rurl=http://news.cnet.com/8301-17938_105-10105305-1.htmlcid=1272850889ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNH7EJWU2o8ibag2NU1tIUv_taAK_AThe best thing about the 2.2 iPhone bsoftware/b update/abrfont size=-1font color=#6f6f6fCNET News,nbsp;CAnbsp;-/font nobr9 hours ago/nobr/fontbrfont size=-1When it some to iPhone bsoftware/b updates, I#39;m all about the basics. Apple could enable the iPhone to cook my dinner every night, but if it added multimedia b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-1fd=Rurl=http://www.crn.com/networking/212101415cid=1272850889ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNEW4fRVOM-6roqBjQkjOCgl_BRt1gFirst Look: Apple#39;s iPhone 2.2 bSoftware/b Hits The Street (And b.../b/a font size=-1 color=#6f6f6fnobrCRN/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-2fd=Rurl=http://arstechnica.com/news.ars/post/20081121-lots-to-like-about-new-iphone-2-2-software-update.htmlcid=1272850889ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNGVp8Rn66c2feQnaDh78R7mZSzyrwLots to like about new iPhone 2.2 bsoftware/b update/a font size=-1 color=#6f6f6fnobrArs Technica/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-3fd=Rurl=http://www.appleinsider.com/articles/08/11/21/apple_releases_iphone_software_v2_2.htmlcid=1272850889ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNEJgT4aPZRJFzfKHbdLixqALBftIwApple releases iPhone bSoftware/b v2.2/a font size=-1 color=#6f6f6fnobrApple Insider/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/1-4fd=Rurl=http://www.g4tv.com/thefeed/blog/post/691179/iPhone_Software_Update_22_Out_NOW.htmlcid=1272850889ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNHaGWVBL2_89X_CQChqRWwQactY1wnobrG4 TV/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/1-5fd=Rurl=http://www.infosyncworld.com/news/n/9932.htmlcid=1272850889ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNFORSC_za6CCuBpMQfn9Q5Pm8_B1AnobrinfoSync World/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272850889hl=ennobrall 119 news articles/nobr/a/font/div/font/td/tr/table

Microsoft to offer free security software to attract beginners - eTaiwan News

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/2i-0fd=Rurl=http://blogs.zdnet.com/security/%3Fp%3D2190cid=1272030386ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNH11b9KI0Er3uP2tHCTH6489tR7lgimg src=http://news.google.com/news?imgefp=w_x6TR0l56cJimgurl=blogs.zdnet.com/security/images/windows_live_one_care.jpg width=66 height=80 alt= border=1brfont size=-2ZDNet/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/2-0fd=Rurl=http://www.etaiwannews.com/etn/news_content.php%3Fid%3D794127%26lang%3Deng_newscid=1272030386ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNGrN_DbZFGBNYrUB4RDLibFG6toLAMicrosoft to offer free security bsoftware/b to attract beginners/abrfont size=-1font color=#6f6f6feTaiwan News,nbsp;Taiwannbsp;-/font nobr18 hours ago/nobr/fontbrfont size=-119 to stop selling personal computer security bsoftware/b and to use free personal anti-virus bsoftware/b instead. The new bsoftware/b called Morro can support seven b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-1fd=Rurl=http://voices.washingtonpost.com/securityfix/2008/11/spamhaus_microsoft_now_5th_mos.html%3Fnav%3Drss_blogcid=1272030386ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNGAhmV1QxwcfL98cPJqqZiVrWs-2gSpamhaus: Microsoft Now 5th Most Spam Friendly ISP/a font size=-1 color=#6f6f6fnobrWashington Post/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-2fd=Rurl=http://www.reuters.com/article/technologyNews/idUSTRE4AI7T420081119cid=1272030386ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNHouF-a50DFnHRHPN4SJhZdQsGuOQMicrosoft: New bsoftware/b not Symantec, McAfee rival/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-3fd=Rurl=http://www.networkworld.com/news/2008/111808-microsoft-drops-onecare-antivirus.html%3Ft51hbcid=1272030386ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNHABv3CWfhorQdU-Jp-bwSgaRF4igMicrosoft to offer free security bsoftware/b/a font size=-1 color=#6f6f6fnobrNetworkWorld.com/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/2-4fd=Rurl=http://www.allheadlinenews.com/articles/7013120895cid=1272030386ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNGXGNJl7efgJjbs9IAprjRQpDpSkAnobrAHN/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/2-5fd=Rurl=http://online.wsj.com/article/SB122706587967940197.html%3Fmod%3Dgooglenews_wsjcid=1272030386ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNGbK4Yl3eOtFnizOWK7WRZAO-34YwnobrWall Street Journal/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272030386hl=ennobrall 304 news articles/nobr/a/font/div/font/td/tr/table

Traction Software Introduces Live Blog Micro-Messaging and End-of ... - MarketWatch

Hann’s On Software bouht by Mediware - Bizjournals.com

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/4-0fd=Rurl=http://www.bizjournals.com/sanfrancisco/stories/2008/11/17/daily94.htmlcid=1272927325ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNHrX7Lp5mXPLqQsI4QzDq6KExwvaQHann’s On bSoftware/b bouht by Mediware/abrfont size=-1font color=#6f6f6fBizjournals.com,nbsp;NCnbsp;-/font nobr11 hours ago/nobr/fontbrfont size=-1Mediware Information Systems Inc. has bought the assets of Hann’s On bSoftware/b, a pharmacy-management bsoftware/b provider based in Santa Rosa, for $3.5 million b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-1fd=Rurl=http://www.marketwatch.com/news/story/Mediware-Acquisition-Adds-320-Pharmacy/story.aspx%3Fguid%3D%257BD97D6EA2-0A06-49FD-BE33-0A9811CA460D%257Dcid=1272927325ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNFjUeXrf3kbkcBhAp0_VgeJ1ZH7KAMediware Acquisition Adds 320 Pharmacy Facilities/a font size=-1 color=#6f6f6fnobrMarketWatch/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-2fd=Rurl=http://www.rttnews.com/ArticleView.aspx%3FId%3D782712%26SMap%3D1cid=1272927325ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNFw7hqLnwy07ya3yNvHPLPAThqnLgMediware Information buys assets of Hann#39;s On bSoftware/b - Quick Facts/a font size=-1 color=#6f6f6fnobrRTT News/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-3fd=Rurl=http://www.ibtimes.com/prnews/20081121/pharmacy-software.htmcid=1272927325ei=UoonSZSYDZqO9QTZwKAJusg=AFQjCNHUmPaspZFuqEIGHEpzRmkd07XvKAMediware Acquisition Adds 320 Pharmacy Facilities/a font size=-1 color=#6f6f6fnobrInternational Business Times/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272927325hl=ennobrall 19 news articles/nobr/a/font/div/font/td/tr/table

Vertical Releases Feature-Rich Software Update for Wave - MarketWatch

PAR Technology Corporation Releases Next Version of SpaSoft(R) Spa ... - MarketWatch

Progress Software and QAD Propose A Formula for The Perfect Lean ... - MarketWatch

DR Systems to Feature Software-Only, Enterprise Web-PACS for ... - MarketWatch

Check Point Software Announces Participation in Fourth Quarter ... - MarketWatch

Software - Google News

RELATED ARTICLES

Microsoft CRM: Data Conversion - Import from Act!
Best Software Act! is very popular CRM for small and mid-size organization. This system attracts business owner by its low price, plus system is very easy to use.

Software Process Improvement -A Successful Journey
Background:For many organizations like ours, the interim target of achieving ISO 9001 or CMM levels is a daunting task. Discipline is no fun -Organizations readily acknowledge that striving to address projects according to ISO 9001 or CMM guidelines requires the creation of new procedures.

Corporate ERP: Microsoft Great Plains For The Plant In Brazil - Overview For CIO
Microsoft Business Solutions Great Plains as new ERP for multinational corporation manufacturing facility in Brazil.If your company plans to outsource manufacturing in Brazil by purchasing existing facility there, the first step would be to implant new management team and revise business processes and procedures.

The Death of Windows
I have always regretted how Microsoft price gouges and rips off computer users. I really regret Windows XP activation.

Free Software for Newbies and Web Developers
Here is some free software tools to help you build your own websites and create web products.Learning new skills is not difficult.

FreeDOS
Before September 1995, Microsoft Windows was an MS-DOS program. DOS was an easy to use command line operating system that provided you with complete ability to control and troubleshoot your computer.

The Truth about Colossus: Are You Just A Magnetic Image?
What is Colossus?Colossus is software licensed to about twenty-five insurance companies to aid in predicting the settlement value of claims. The insurance industry maintains it is a useful tool because it considers a great many factors, and the settlement values are just a range for use in any way the insurer wishes.

Groupware as a Document Manager: Collaboration Series #3
This article is the third of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware.

C++ Tutorials: 3, Program Flow (If, Else, While, For)
Program Flow is what you think it is. How the program will flow.

Crystal Reports for Microsoft Great Plains - Overview for Developer
Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market.� It serves the whole of vertical and horizontal market: most of the industries and company sizes.

Start Developing Your Own Software
Learning how to program software seems like a daunting task fit only for the geeks and nerds who lock themselves away in dark rooms staring at their monitors for days on end as they pour over thick manuals written largely in zeros and ones. Fortunately the reality is that it's not as complicated to make basic applications as people may think.

OS 101: Suggestions for Choosing an Operating System
An operating system (abbreviated OS) is essentially the path through which a computer accesses files, games, the Internet, and all vital stored information. The OS is the most important program on a computer because it runs all of the other programs.

Microsoft Great Plains Beverage Production & Distribution - Implementation & Customization Highlight
Microsoft Business Solutions Great Plains has many years of successful implementation in multiple horizontal markets. In today's small article we'll share our experience of implementing and customizing Microsoft Great Plains, formerly Great Plains eEnterprise/Dynamics in beverage production and distribution industries.

Examining the Substance of Studio MX
To all web designers out there, this article is for you! I guess you already heard about Studio MX (I think so!) - the ideal bundle for professional web designers, bringing together Dreamweaver MX for page design, Flash MX for animation and interactivity, and Fireworks MX for editing and optimizing graphics. With all these components, it certainly provides professional functionality for every aspect of web development.

Tripwire for Linux File Integrity
What is Tripwire?Tripwire is a form intrusion detection system (IDS) that helps you keep tabs on the integrity of the files on your computer. Quite simply it will help identify files or modifications made to your system in the event someone compromised your system.

SQL Administrator Skills Required to Support Microsoft Great Plains
Microsoft Great Plains is becoming more and more popular and we see new purchases among midsize and large corporations, where, in our opinion, Microsoft SQL Server DB administrator position is a must. If you are database administrator and you are part of the decision making team, purchasing Microsoft Business Solutions Great Plains for your corporation, we would like to set your expectation on the level of SQL knowledge, skills and experience needed to support Microsoft Great Plains in-house? Data querying.

What to Do if All Screensavers Fun is Grayed Out?
Finally, you have some time to personalize your desktop with an interesting screensaver. But wait.

Introduction To ISDN, Part II
In the previous ISDN article, we looked at how and why one router dials another using ISDN. Just as important is knowing what keeps the link up once it is dialed.

Lotus Domino: Application Integration - A Programmer View
There are two approaches for application integration:? Programmer's approach - for applications integration it is necessary to create some program codes;? Integrator's approach - in this case special software products are to be used and the integration process set up by those software settings.The following tools may be used for the first approach:? ODBC.

Microsoft Great Plains Distribution, Barcoding, Consignment - overview for consultant
Microsoft Great Plains - ERM from Microsoft Business Solutions and formerly Great Plains Software is pretty generic with its standard set of modules: GL, BR, AR, AP, IV, SOP, POP and US Payroll. However, having about twelve years of implementation and customization history - Great Plains Dynamics, Dynamics C/S+, eEnterprise being Great Plains Dexterity written application has been and still is attractive core platform for third party software development companies to write vertical and horizontal modules, written as well in Great Plains Dexterity.