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

GlobeSt.com

New Software Revolutionizes Site Planning
GlobeSt.com
... Areas to create, store and share work orders for properties and facilities. We sat down with Casey Rue, the founder and CEO of Common Areas, to talk about the new software, what users can expect and how it will impact the commercial real estate ...


Xconomy

Xconomy: Quest Analytics Buys Healthcare Compliance Software ...
Xconomy
BetterDoctor, a San Francisco-based startup that has built a national database with information on physicians, dentists, and other practitioners, has been ...

and more »

Forbes

What It Will Take For The Software Services Industry To Navigate A Digital Future
Forbes
No device exists without software, and the end-to-end software services and solutions for businesses across industries are being developed by the information technology (IT) sector. This underlines the need for the sector to be alert to opportunities.


Investor's Business Daily

Software Stocks Flying High, IPOs Drive Up Valuations, M&A May Suffer
Investor's Business Daily
Both Salesforce.com and Workday acquired firms at historically high prices, says Morgan Stanley. The investment bank notes 52 software acquisitions in 2018 thus far. That includes purchases of private firms. Companies bought 36 and 37 software firms, ...


eWeek

Lakeside Software: Product Overview and Insight
eWeek
eWEEK is building a new IT products and services section that encompasses most of the categories that we cover on our site. In it, we will spotlight the leaders in each sector, which include enterprise software, hardware, security, on-premises-based ...


Clarkson professor gets grant to compare DNA software
WatertownDailyTimes.com
Ms. Matthews, an associate computer science professor at Clarkson University, is leading a team that has been awarded a $75,000 Brown Institute Magic grant for her project, Decoding Difference in DNA Forensic Software. “Simply put, when computers are ...


WPRI 12 Eyewitness News

'Significant' UHIP software upgrade planned for this weekend
WPRI 12 Eyewitness News
PROVIDENCE, R.I. (WPRI) - A major software upgrade for Rhode Island's UHIP computer system is scheduled for this weekend. UHIP - short for Unified Health Infrastructure Project - is Rhode Island's problem-plagued computer system, which launched in ...


The Register

From here on, Red Hat's new GPLv2 software projects will have ...
The Register
Red Hat on Monday said all of its newly initiated open-source projects that adopt GPLv2 or LGPLv2.1 licenses will be expected to include the GPLv3 "cure" ...

and more »

512tech.com

Austin's Malauzai Software acquired by UK-based financial tech company Finastra
512tech.com
Austin-based Malauzai Software has been acquired by London-based financial technology firm Finastra, the companies said Monday. Financial terms of the deal were not released. Founded in 2009 by financial software industry veterans Tom Shen and Robb ...

and more »

TechCrunch

Kaspersky pulls plug on Europol joint venture after EU parliament ...
TechCrunch
Fresh political woes for Russian security firm Kaspersky, which has reacted angrily to a vote in the European Union Parliament last week to ban its software ...

and more »
Google News

Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

Microsoft Business Solutions Great Plains has I'd say end user... Read More

Simple Solution for Php Includes - IFrames

I have recently created my first Php program. I wanted... Read More

What Stands Behind The Software Description?

With thousands of web pages added to the Net every... Read More

Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More

Microsoft Navision Customization Upgrade ? Tips For Programmer/IT Specialist

Currently Microsoft Business Solutions is on the way of creating... Read More

Professional XP Style Icons in Software and Website Development

Using professional icons in your application or website can bring... Read More

A Time-Saving Programming Tactic that Doesn?t Work

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

Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

If you would like to pick something from Microsoft, or... Read More

Microsoft CRM Implementation for Large Corporation ? overview

Microsoft Business Solutions CRM is now approaching the phase of... Read More

Microsoft CRM Integration with Lotus Notes Domino: Messaging Connector ? Future Directions

IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More

Removing Incoming Email in MS Exchange, C# Example

The purpose of one of our projects was MS Exchange... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

Scrapbooks are very popular these days. I think that almost... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

Microsoft Great Plains Middle East - Arabic Language Support

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

Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight

Microsoft Business Solutions Great Plains has many years of successful... Read More

Mozilla Vs. Firefox

For those who are unclear on the differences between the... Read More

What is Fleet Maintenance Software?

Simply put, fleet maintenance allows companies to monitor and maintain... Read More

Two Reasons to Use Timesheet Software

This short paper will expand on two key reasons to... Read More

Microsoft Great Plains: Manufacturing or Bill of Materials - Overview for IT Specialist

Microsoft Great Plains is main Microsoft Business Solutions product, targeted... Read More

Demand More From Your Lead Tracking Software

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

Protect Your Most Vital Business Asset with Security Software

Homeland security, airport security, Internet security â?" these days weâ??re... Read More

QuarkXpress Tips: How to Move Content Between Print and Web Layouts

Since its release in 1987, QuarkXpress had made an immediate... Read More

Algebra Help Software

Need help making sense of algebra? Have algebra lectures in... Read More

Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

All of us know that Microsoft bought former Great Plains... Read More

Software Piracy

SOFTWARE PIRACY We regularly hear reports... Read More