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: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
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. |
home | site map | contact us |