Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft RMS Customization ? PO Items Receiving in Great Plains > NetSparsh - Viral Content you Love & Share

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:

This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

Forbes

Digital Transformation Reveals Limitations Of Software Packages And SaaS
Forbes
Most large enterprises were on a journey for the past 30 years where a higher and higher proportion of the core systems driving the enterprises was software packages or software as a service. Traditional wisdom for companies was “don't build – buy ...

and more »

The Verge

Microsoft alters Surface Hub 2 hardware, delays new software features to 2020
The Verge
Microsoft is unveiling hardware changes to its Surface Hub 2 today. The software giant first unveiled its 50-inch display earlier this year, with a promise of a 2019 release. While the hardware will now be released in Q2 of 2019, many of the cool new ...
Ignite 2018: Microsoft shows off Surface Hub 2 running latest WCOS softwareOnMSFT (blog)
What's next for Surface Hub 2 - Microsoft Devices BlogMicrosoft Devices Blog - Windows BlogWindows Blog

all 54 news articles »

American Software: The SaaS Narrative Collapses
Seeking Alpha
American Software has tried to frame itself as an SaaS company - but 'cloud' sales still represent less than 12% of revenue. A disappointing Q1 undercuts much of the optimism that revenue growth is set to accelerate. After a nearly 40% plunge, AMSWA ...

and more »

TOP500 News

IBM Introduces Software to Alleviate AI Bias
TOP500 News
A cancer treatment recommendation powered by machine learning may be right 98 percent of the time, but what are the liabilities of the software-maker when a misdiagnosis results in death? A less fatal, but still undesirable type of bias comes into play ...

and more »

Threatpost

Adwind RAT Scurries By AV Software With New DDE Variant
Threatpost
The spam campaign features two types of droppers that leverage a new variant to the already-known DDE code-injection attack on Microsoft Excel – enabling them to bypass AV software. DDE is a legitimate method for transferring data between applications ...

and more »

ZDNet

Adwind Trojan circumvents antivirus software to infect your PC
ZDNet
"Although both the generic method and the payload are known, this campaign show[s] how some variance into well-known artifacts can trick antivirus [software]," Cisco Talos says. "Their behavior, however, is clearly classical, which means that ...


CMSWire

Choosing a SaaS Product: 7 Non-Software Related Considerations
CMSWire
When it comes to choosing software, you need to consider more than just the code itself. As more and more companies incorporate software-as-a-service (SaaS) tools into their marketing technology stacks, we felt it was important to address seven vital ...


GeekWire

Pixvana's new virtual reality production software lets you edit VR content while wearing a headset
GeekWire
Seattle startup Pixvana today released the full version of its software platform SPIN Studio that helps virtual reality filmmakers edit, process, and deliver video at 8K resolution. Perhaps the most notable update to SPIN is the ability to edit VR ...

and more »

Mashable

Snag this illustrating software on sale for 50% off
Mashable
Clip Studio Paint Pro is an all-inclusive software meant to make it easier to draw and paint on your computer or tablet. Once you download the software, you'll have access to over 10,000 downloadable brushes as well as a handful of 3D models and figurines.

and more »

Epic Concepts Achieves Innovative Preferred Software Partner™ Status
PR Newswire (press release)
NEWPORT NEWS, Va., Sept. 24, 2018 /PRNewswire/ -- Innovative Enterprises, Inc., an expert strategic partner to the background screening industry, proudly announced that Epic Concepts has achieved Innovative Preferred Software Partner™ status.

and more »
Google News

C++ Function Templates

C++ Function templates are those functions which can handle different... Read More

MSN Messenger Is A Sweet Way To Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

Story Development Software: Good or Evil?

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

Interactive Mapping Brings Information to Life

What is Interactive Mapping?Interactive mapping is a visual display medium... Read More

DB Integration - Software for Combine MS Access Databases

Our company, Novaprof Inc., developed unique software - DB Integration.... Read More

Microsoft Great Plains Security Setup - Overview For Consultant

Microsoft Business Solutions Great Plains is very good fit for... Read More

Microsoft Great Plains Implementation in Russia ? Overview for Consultant

Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

Microsoft CRM Conversation Gateway: VoIP - Implementation & Customization

Microsoft CRM is winning market share step-by-step from such the... Read More

The Death of Windows

I have always regretted how Microsoft price gouges and rips... 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

How to Choose the Right Accounting Software for Your Business

With any good luck and a good amount of hard... Read More

Microsoft Great Plains e-Commerce ? additional considerations for programmer

Microsoft Great Plains, designed back in 1990th as database transferable... Read More

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

How to Backup Windows XP Home Edition

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

Five Reasons for Using an O/R Mapping Tool

So, why should you use any O/R mapping tool? I... 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 Customization Recovery & Upgrade for Large Corporation

At the end of XX century, in the late 1990th... Read More

IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

Microsoft CRM Implementation & Remote Support

We would like to give you pluses and minuses of... Read More

Computer Phones ? Facts and Fallacies

The stakes are high when considering security, privacy, and savings,... Read More

Microsoft Great Plains eCommerce ? Stored Procedures Approach

Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More

Start Developing Your Own Software

Learning how to program software seems like a daunting task... Read More

Microsoft Great Plains Project Accounting ? Overview For IT Director/Controller

Microsoft Business Solutions is now in process of creating so... Read More