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 [email protected].

In The News:

OpenAI refuses to release software because it's too dangerous  Fast CompanyAI researchers fed their piece of software the first sentence to George Orwell's 1984, and it produced the following text: advertisement. I was in my car on my way ...
Software: Start Early, Use Often  Manufacturing.netReaching corporate-grade production with additive manufacturing in a production environment.
NIOSH releases new EXAMiner training software  Mining TechnologyNIOSH has released a beta version of its new EXAMiner training software, which is designed to help miners improve their ability to identify hazards.
How to make PDFs in macOS Mojave without any extra software  AppleInsiderYou've been able to make a PDF out of any document on Macs for years. We take it so much for granted, though, that we don't know what extra options we've ...
'Couldn't do it without technology': Embracing clinical software for trial recruitment  OutSourcing-Pharma.comGetting patients into possibly life-saving trials has long been a complex process, however, with the age of electronic health records and cloud-based data, there ...
Novel Software May Help Detect Heart Diseases: Study  Doctor NDTVResearchers have developed a new software that could spot potentially lethal heart diseases and may lead to improvements in prevention and treatment, says a ...
Study: The 4 software development trends that will dominate 2019  TechRepublicThe software development landscape is changing, but developers are using four key methods to handle it, according to an Atlassian survey.
HR Software Technology: Which Problems Recruitment Software Can Solve?  BOSS MagazineThe recruitment process can be streamlined by adopting the right HR software.
Private equity is on a spending blitz in cloud software  CNBCVista's agreement on Tuesday to buy Ellie Mae is the latest example of private equity jumping into cloud software.
Software development isn't a manufacturing process  BetaNewsThe following is an exclusive excerpt from Project to Product: How to Survive and Thrive in the Age of Digital Disruption with the Flow Framework by Dr. Mik ...
Israeli software firm DriveNets raises $110 million in first round of financing  HaaretzDriveNets said its software allows communication *service* providers to handle growing demand without sacrificing profitability.
Pinpoint Unveils World's First Advanced Analytics Platform for Software Engineering  GlobeNewswireNew technology uses data science to advance the way people and teams deliver software.
DriveNets Pockets $110M to Pave Software Disaggregation Path  SDxCentralIsraeli software startup DriveNets landed $110 million in first round financing to boost its focus on helping *service* providers disaggregate proprietary routers from ...
The New PCI Software Security Framework -- What You Need To Know Now  ForbesThe Payment Card Industry Security Standards Council just launched the PCI Software Security Framework targeting application security. After over a year of ...
Ultimate Software Ranked #8 on Fortune's 100 Best Companies to Work For 2019 List  Business WireUltimate Software announced today that Fortune and Great Place to Work have ranked Ultimate #8 on their 2019 list of 100 Best Companies to Work For.
Profile Software releases Axia Suite 2.1  Wealth AdviserProfile Software, an international financial solutions provider, has launched Axia Suite release 2.1., which the company says delivers advanced investment ...
The top 5 trends in software development  TecheratiBeing flexible with these trends is the way forward to a more efficient and effective delivery pipeline, says Jeff Keyes.
Anti-violence measures including phone checks for hidden software  The AdvertiserPeople who fear they are being cyber-stalked by a controlling partner would be able to scan their mobile devices for hidden software under a trial to ensure the ...
Music Composing Software Market by Instrument Simulation - Global Market Size, Share, Development, Growth and Demand Forecast (2013-2023) - ResearchAndMarkets.com  Associated PressDUBLIN--(BUSINESS WIRE)--Feb 15, 2019--The “Music Composing Software Market by Instrument Simulation - Global Market Size, Share, Development, ...
Crossover: A software sweatshop  Forbes IndiaTwo decades ago, Joe Liemandt became the youngest member of the Forbes 400 by building an enterprise software juggernaut. He's quietly returned, bigger ...
Today's Pickup: Beyond Software In The AV Space; SmartWay Slashes Emissions, Fuel Costs  BenzingaGood day,. As the self-driving vehicle space matures, industry experts are calling attention to technology challenges that aren't quite as sexy as AV software but ...
Iowa software company seeks more than $2.5M in state help  News8000.com - WKBTA software company wants more than $2.5 million in state aid to expand in Ames.
Xiaomi’s MIUI 10 Global software is getting a built-in dark theme  XDA DevelopersXiaomi's MIUI 10 will receive a system-wide dark theme soon on the lines of Android Q's dark mode, starting today with the MIUI 10 Global Beta v9.2.14.
Top 4 auto SMS sender software for PC to use in 2019  Windows ReportAn auto sms sender software for PC with auto responding facility helps users send messages in bulk for marketing purpose.
Global $78.62 Bn Automotive Software Market, 2018-2026 - Key Players are NXP, Renesas, BlackBerry, Elektrobit, Microsoft, NVIDIA, Airbiquity, Green Hills Software, Wind River and Aricent  GlobeNewswireDublin, Feb. 15, 2019 (GLOBE NEWSWIRE) -- The "Global Automotive Software Market Size, Market Share, Application Analysis, Regional Outlook, Growth ...
Harris Beach creates software company  Rochester Business JournalThe Harris Beach law firm has created a new company, separate from the law practice, offering a cloud-based subscription software tool to help companies with ...
ADTRAN Unveils New Software-Only Solution to Help CAF Service Providers Comply and Manage Performance Testing  Business WireCloud-based, open system works without extra equipment or raising privacy concerns—delivering enhanced user experience.
Should You Invest in the Invesco Dynamic Software ETF (PSJ)?  NasdaqIf you're interested in broad exposure to the Technology - Software segment of the equity market, look no further than the Invesco Dynamic Software ETF (PSJ), ...
How to update the software on your Honor 8X  Android CentralUpdates bring new features, tighten up security, and generally make us feel good. Make sure you never miss one on your Honor 8X by learning how to update it.
Move Over Actors And Artists, Software Developers Are True Creative Heroes  ForbesSoftware engineers are not workhorses, they are inherently creative people who, given the right environment, can transform the fortunes of a company. Business ...
ACC buys foreign language software for students, community | News, Sports, Jobs  Alpena NewsALPENA — There is now Rosetta Stone at Alpena Community College for anyone to use to learn new languages. There are 16 languages in the college's ...
Top 5 software to recover Microsoft Excel passwords  Windows ReportForgoten password for your MS Excel spreadsheet and WorkBook? Here are the best software to recover MS Excel password on Windows 7-8-10 PCs.
Israeli software firm DriveNets raises $110 million in first funding round  Reuters UKTEL AVIV (Reuters) - Israeli networking software company DriveNets said on Thursday it raised $110 million in its first round of financing led by Bessemer ...
Business Process Management Software Market 2018: Global Industry Top Key Players (Ibm, Appian, Oracle Corporation, Agile Point, Pegasystems, K2 Software, & Fujitsu, Bizagi)  Wise AwarenessThe global Business Process Management Software market report deals with a number of industry and market parameters including latest trends, market ...
Synopsys Releases Simpleware ScanIP Medical Software for 3-D Printing  Imaging Technology NewsFebruary 14, 2019 — Smart technology company Synopsys recently announced the release of the Synopsys Simpleware ScanIP Medical edition for 3-D printing ...
Software for assigning family members same polling booth  Times of IndiaPune: The Election Commission of India (ECI) has instructed the electoral registration officers of all the assembly constituencies to complete “family.
Police Hope Software Can Help Avoid \'Losing\' Sex Offenders  Government TechnologyContinually improving information sharing, mapping and *content* management systems have allowed law enforcement agencies across the country to keep ...
Samsung One UI (Android 9 Pie) review: Samsung's best software yet  Android CentralSamsung's Android 9 Pie release, with the new One UI interface and features, is something every Samsung phone owner should look forward to.
This software program could help prevent future school shootings  CNNIn the wake of increasingly frequent school shootings, school districts across the country are using a combination of tools to try to prevent another tragedy. One of ...
Global Dental Practice Software Market 2018:2025, Top Players – Solutionreach, Bestosys Solutions  Industry News NetworkMRS Research Group recently Published Global Dental Practice Software Market research study with more than 100 industry informative desk and Figures ...
InfluxData raises $60 million for time-series database software  VentureBeatInfluxData has raised $60 million for InfluxDB, its time-series data management software that's freely available on GitHub.
What Will Software Look Like Once Anyone Can Create It?  HBR.org DailyA former YouTube executive on building apps without knowing how to code.
Copper Recognized as a Best Software Product of 2019 for Sales  MarTech SeriesCopper, the Google-recommended CRM for today's digital workplace, has been recognized by G2 Crowd as a best software product of 2019 in two categories.
Software app to clear investment proposals in Kerala within 30 days  BusinessLineSignalling the end of the licence raj era, the Kerala government has come out with a software application K-SWIFT (Kerala Single Window Interface for Fast, ...
Brokerages Set Software AG (SOW) Target Price at $41.24  Fairfield CurrentSoftware AG (ETR:SOW) has been assigned a consensus rating of “Hold” from the nineteen research firms that are covering the company, MarketBeat reports.
AMD Releases Radeon Pro Software for Enterprise 19.Q1: Adds Limited Support for Consumer Radeon Cards  AnandTechHeadlining this release, on the heels of the launch of the prosumer-oriented Radeon VII, AMD is introducing Radeon Pro Software compatibility for many of their ...
Global Customer Communication Management Software Market 2018:2025 – Adobe Systems, Cincom Systems, Doxee SPA, Dell  Industry News NetworkThe Customer Communication Management Software Global market 2019-2025 from QY research gives basic data to advertisers, managers, analysts, business ...
Video Management Software market 2022  Wise AwarenessMarket Research Report on Video Management Software 2022 by Research for Markets.
Global Diagram Software Market 2018:2025, Top Players – Microsoft, JGraph, Cinergix, Slickplan, SmartDraw, Gliffy  Industry News NetworkMRS Research Group recently Published Global Diagram Software Market research study with more than 100 industry informative desk and Figures spread ...
UK software firm Micro Focus 'back on track' as revenue tops expectations  City A.M.London-listed software firm Micro Focus said sales had fallen less than expected last year, causing its share price to jump as much as 15 per cent.
Advice software firm integrates with XPLAN  ifaA client relationship measurement software firm has announced an integration with IRESS's XPLAN adviser platform. MyNextAdvice said in a statement that it ...
Making the Grade: iTunes U and iBooks Author are suffering from software rot  9to5MacApple has a software rot problem with two of its K-12 focused applications. iTunes U and iBooks Author seem to be on life support with no end in site.
Former Sage CEO joins software firm  BusinessCloudStephen Kelly and ex-Salesforce chairman Steve Garnett invest in fast-growing company which helps keep millions of people engaged with online *content*.
Slic3r vs Cura – 3D Printer Slicer Software Shootout  All 3DPIf you've been trying to find the latest features on the best slicers, look no further. We compare the top two open source slicers, Slic3r and Cura, focusing on their ...
Atlassian rewrites the SaaS playbook with beloved products like Jira  Business InsiderAtlassian is so vital to how businesses work, it's practically recession-proof, says BTIG's Joel Fishbein.
Here’s How P/E Ratios Can Help Us Understand Beta Systems Software AG (FRA:BSS)  Simply Wall StWant to participate in a short research study? Help shape the future of investing tools and you could win a $250 gift card! This article is written for those who want ...
Software developers need more confidence on Stack Overflow  QuartzEvery software developer is familiar with the site Stack Overflow, the 11-year-strong compendium of questions and answers. Part knowledge base, part social ...
Enjoy a '93 video tour of id Software while Doom was being made  GamasutraThe clip appears to have been online for ages, but if you haven't yet seen it it's well worth a watch to get a sense of what id Software (and game dev.
Belize-born software pioneer shares inspiration with US students  Breaking Belize NewsPosted: Tuesday, February 12,2019. 1:50 p.m. CST. By BBN Staff: A Belizean-born software engineer is using his story to encourage students at a school in ...
New Astaroth Trojan exploits anti-malware software to steal credentials  Software Testing NewsA new Astaroth Trojan campaign targeting Brazillian and European countries is exploiting software made by GAS Tecnologia to steal online credentials.
Global Yard Management Software Market 2018:2025, Top Players – HighJump, c3 Yard, DEPOT Core, Omni-ID  Industry News NetworkMRS Research Group recently Published Global Yard Management Software Market research study with more than 100 industry informative desk and Figures ...
Global Vulnerability Management Software Market 2018:2025, Top Players – Rapid7, Tenable Network Security, AlienVault  Industry News NetworkMRS Research Group recently Published Global Vulnerability Management Software Market research study with more than 100 industry informative desk and ...
Best file recovery software  TechRadarAccidentally deleted a file, or had it nuked by a virus? All is not lost.
Why Software Companies Should Care About Global Warming  ForbesGlobal warming could affect every industry and area of the planet. Many tech giants are working toward greater energy efficiency and sustainability -- and your ...
Call to Action: Tell the Patent Office Not to Reopen the Software Patent Floodgates  EFFThe Supreme Court took a major step in cutting back on abstract software patents when it issued its landmark ruling in Alice Corp. v. CLS Bank. Since then ...
In Quadriga saga, 30-year-old software engineer makes a $560K mistake  BNNBloomberg.caTong Zou wasn't a stereotypical crypto bro bent on accumulating flashy trophies such as Lamborghinis when he deposited his life savings into Quadriga CX's ...
5 Reasons Rimini Street, Other ‘Lower-Cost’ Software Maintenance Providers May Be More Expensive  ForbesThird-party enterprise software support companies such as Rimini Street promise to cut business customers' application update and support prices, but buyer ...
The Internet Was Built on the Free Labor of Open Source Developers. Is That Sustainable?  MotherboardA look at the complicated business of funding open source software development.
Who is in Charge of Quality in Software Development  InfoQ.comAs silos break down, the whole team is responsible for quality in software development. As process more and more defines people and processes, how can you ...
The Best Online Tax Filing Software for 2019  TheStreetThe 2019 online tax preparation packages are out, and there is no shortage of great tax management deals to choose from....HRB.
Why free software evangelist Richard Stallman is haunted by Stalin's dream  FactorDailyMore than 30 years ago, Richard Stallman quit a doctorate program at the MIT to start the GNU Project, a free software operating system. Not only has he been ...
WeWork Continues Its Software Company Acquisition Bender, Aims To Be Tech Company  BisnowWeWork snaps up yet another software company, the better to become a tech giant.
Stupid Patent of the Month: IBM's Software Patent on Texting and Driving  EFFIn the smartphone era, “distracted driving” is a serious, and well-known, problem. Official warnings about poor driving habits are as old as the automobile itself.
11 Best Free Floor Plan Software Tools in 2019  G2 CrowdFloor plan software has myriad uses, including office space planning, facility plant floor planning, and venue management planning. Even parking lots benefit ...
Amazon Still Pushing Biased Facial-Recognition Software To Law Enforcement, MIT Researcher Contends  ForbesAmazon CEO Jeff Bezos was made aware of biases in its facial-recognition software last June when Joy Buolamwini, an activist at MIT Media Lab and founder of ...
Apple Planning to Modify iPhone 7, iPhone 8 Software and Hardware to Circumvent Ban in Germany: Report  Gadgets 360After being forced to pull the iPhone 7 and iPhone 8 from sale in Germany, Apple has reportedly found a way to bypass Qualcomm's patent infringement claims.
KKR KKR strikes billion-dollar software deal with OneStream February 7, 2019 KKR has agreed to  PitchBook News & AnalysisKKR has agreed to back OneStream Software at a valuation of more than $1 billion, with The Wall Street Journal reporting the firm will shell out over $500 million ...
More On The Return Of Tesla’s Software-Limited Battery Pack Scheme  InsideEVsWe really can't say we're surprised to see the return of Tesla's software-limited battery scheme. It just makes more sense to handle "trims" this way.
Stanford spurs AI navigation for space rendezvous software | Stanford News  Stanford University NewsAn AI-powered navigation system would direct spaceborne 'tow trucks' designed to restart or remove derelict satellites circling aimlessly in orbit.
Help Health Canada to Regulate Software as Medical Devices (SaMD) |  MedgadgetHealth Canada has written a guide for regulating software as medical devices (SaMD). They are now asking for input on their regulations by healthcare.
Lawrence school board to hear update on PowerSchool student management software  Lawrence Journal-WorldStory updated at 8:45 a.m. Monday, Feb. 11: The Lawrence school board on Monday will hear an update on the student management software that the distr.
Looking to give wings to your software development and deployment?  The RegisterEvents Whether you're just piloting your first DevOps projects, want to scale things up, or are ready to leap into Kubernetes or Serverless, you should be joining ...
SolarWinds CEO On MSP Software, Private Equity And DRaaS  ChannelE2ESolarWinds CEO Kevin Thompson's favorite acronym appears to be MSP (managed services provider). The evidence: Thompson, his executive team, and Wall ...
Cisco’s AppDynamics software ties in SDN, serverless for greater app management  Network WorldThe wide-ranging Cisco AppDynamics announcement targets enterprise customers looking to monitor performance and automate the response to problems in ...
Ciena Spins Off Blue Planet Software Into an Independent Division  SDxCentralCiena anticipates that Blue Planet will reach $50 to $60 million in annual revenue during fiscal 2019, and to $100 to $120 million in 2021.
How Lloyds' software dept. is engineering the bank of the future  TecheratiFor banks to truly benefit society, they need to harness the combined power of all the great minds sitting in their engineering ranks, says James McLeod.
6 Best Free Vacation Rental Software Solutions in 2019  G2 CrowdVacation rental management is a whole different beast than residential property management. One, effective guest management is top priority, and two, proper ...
How Software Outsourcing Can Empower Digital Transformation  DevOps.comSoftware outsourcing businesses often adapt better to the evolving digital landscape because they aren't afraid to look outside an organization.
Hill AFB opens new, $35 million software facility at research park  Standard-ExaminerYou can reach reporter Mitch Shaw at [email protected] Follow him on Twitter at @mitchshaw23.

A Time-Saving Programming Tactic that Doesn?t Work

Let's say that you have a software project that's under... Read More

Computer Based Language Development and Spell-checking

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

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Microsoft Great Plains BR: Bank Reconciliation

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

Microsoft CRM Data Import FAQ

Microsoft CRM has built-in conversion tool, however you should probably... Read More

Microsoft Great Plains in Construction & Building ? Implementation & Customization Highlights

Microsoft Great Plains could be tuned and setup to fit... Read More

Linux Dual Boot-How To Format

Just the thought of a duel-boot scares many people away,... Read More

Who Is Minding Your Sensitive Data?

Stealing company information used to be the specialty of spies... Read More

Demand More From Your Lead Tracking Software

An integral part of any quality CRM system is lead... Read More

Microsoft Great Plains, Navision, Axapta ? Selection Considerations

During the years of our consulting practice, which comes back... Read More

ERP Consulting: Microsoft Great Plains Partner Future Directions

In the Clinton era the status quo was simple: you... Read More

Story Development Software: Good or Evil?

In the early days of the personal computer, we're talking... Read More

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

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

Collaboration Software: Index of Collaboration Software Technologies

Collaboration SoftwareCollaboration Software, also known as group collaboration software or... Read More

New SQL Delta Version 3.1

COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

Microsoft Great Plains Jewelry ? Implementation & Customization Overview

Each Industry and market niche has business specific and unique... Read More

Oracle Development: JDeveloper 10G ? Java, J2EE, EJB, MVC, XML - Overview For Programmer

In 2004 Oracle, Inc. made its new step toward J2EE... Read More

Document Templates Give You The Perfect Framework For Your Documents

When it comes to running an office, the SOHO entrepreneur... Read More

Passwords Used In Microsoft Word Documents

You would like to protect your documents, wouldn't you? Reasons... Read More

15 Questions to Ask Your Software Vendor

When making a decision to buy any piece of software... Read More

What is Groupware?

Vince Lombardi once said that, "The achievements of an organization... Read More

Tools for Customizing Great Plains

Microsoft Business Solutions ? Great Plains has captured the US... Read More

Looking for an Alternative to Microsoft Office? You Should Be!

Now is the time to look at an alternative to... Read More

How to Make Attractive and Effective PowerPoint Presentations

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

An Easy Way to Develop JAVA Enterprise Applications

Research bears that less than 70 percent of development projects... Read More