Microsoft Retail Management System (rms) Sql Customization ? Overview For Programmer
|
Microsoft Retail Management System serves retail single store as well as retail chains clientele. The customization scenarios, described in this article deal with the chains, when Microsoft RMS has multiple stores databases and Headquarters. Microsoft RMS is SQL Server-based application, so we will consider SQL programming ? SQL queries, views and stored procedures. Also Microsoft RMS could be integrated on the SQL level with other applications, such as Microsoft Great Plains, Microsoft CRM and non-Microsoft applications, such as Lotus Notes/Domino
? Microsoft RMS Architecture and data flow. As it is POS automation application, it assumes that all the POS transactions are originated at the store. The mechanism used is worksheets. When store is closed ? Headquarters pulls its transactions via worksheet. There are some exceptions ? global data, such as global customers are updated on the headquarters level and updates propagated to the stores.
? Data Update. If you need custom logic work with the POS transaction ? you have to update store database data. If you try to update Headquarters database ? the chances are that it will be rolled back by the next worksheet, because original data sits on the store level and is different from your altered data in the HQ
? Store Level Web Services. Yes ? they will enable you to communicate with store database and have transaction data updated over there. The other way is having all the stores as linked servers from Headquarters MS SQL Server Enterprise Manager
? Integration with Great Plains or other SQL Server Accounting package. RMS normally replicates transactions from the stores to Headquarters upon the store business hours close. At this time they are ready to be integrated with such accounting system as Microsoft Great Plains. Here we are talking about custom integration, which you can create as a stored procs set.
? Gift Card puzzle. There are few funny things in MS RMS you should be aware. Imagine ? you issue Gift Certificate. It exists on the Headquarters level and each store knows about the balance on the card. Customer uses card in store A and then walks in to the store B. If worksheet mechanism didn't play during this time interval ? store B gift card balance will show incorrect value. To fix the issue you need to trigger worksheet creation and launch on the headquarter level to replicate new balance to all the stores.
Good luck with customization and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft RMS, Great Plains, Microsoft CRM customization company, serving clients in Chicago, California, Texas, Florida, New York, Georgia, Arizona, Minnesota, UK, Australia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. You can contact Andrew: andrewk@albaspectrum.com
|
|
|
Razzle Dazzle Them
Once upon a time not so long ago, there was a little boy who went to the market to try to sell his wares. He wasn't having any luck. "Who will buy my sweet red roses? Two blooms for a penny," he sang ou...(related: Software)
Computer Phones ? Facts And Fallacies
The stakes are high when considering security, privacy, and savings, and the old adage, "look before you leap" might be a more judicial approach when searching for a computer phone provider, aka VoIP (voice over internet protocol).FACTS? PC phones (VoIP) can save individuals and businesses up to 80% on current phone bills, regardless of whether calls are made from PC to landlines or mobile phones.? Secure lines that include patented technology are protected against terminal viruses, worms, Trojan horses, unscrupulous hackers, and uninvited guests listening in on private conversations.? Unsecure lines cripple users by creating dangerous vulnerability to security and privacy due to operating on open platforms or shared services.? Over 90% of all VoIP provider services a...(related: Software)
Great Plains Dexterity: Customizations & Source Code Programming
Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on GPS proprietary programming language and development environment ? Great Plains Dexterity. When Microsoft bought Great Plains Software, Dynamics was renamed into Microsoft Great Plains, but Dexterity is still the architectural base, there were trends to move MS Great Plains to .Net and reprogram it in C#, but in our opinion Microsoft is probing its own technologies and places them into competition with each other. Microsoft Business Portal is probably the direction, wh...(related: Software)
Microsoft Crm Implementation & Customization: Ms Crm Fax Gateway
With this small article we are continuing Microsoft Business Solutions CRM customization, development, modification, setup and implementation discussion.Microsoft CRM at this moment doesn't have advanced fax automation ? you can register the fact of fax receiving or sending, but it is not sufficient for your daily work with your clients. User should be able to send and receive faxes in her/his work environment ? it is in MS CRMFax software automation market is very mature and we don't have to re-invite the bicycle here. All we have to do is ? integrate one of the reliable solutions into Microsoft CRM. Let's look at the technical aspects of the integration:? Modification should be based on the standard event Fax Activity logic alteration. Standard CRM version allows in- or...(related: Software)
Four Desktop Tools To Drastically Increase Your Productivity
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes on your desktop or send them instantly over the Internet.StickyNote also enables you to adhere notes to documents or windows AND to attach documents to your note.StickyNote eliminates the clutter and confusion of keeping up with the reminders and phone num...(related: Software)
Microsoft Crm Customization Secrets ? Second Edition
This article is for advanced Microsoft CRM SDK C# developers. It describes the technique of direct SQL programming, when SDK doesn't have the functionality to do the job.Introduction. Looks like Microsoft CRM becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision (the last two in progress).Here we describe the technique of creating closed activity-email using MS CRM SDK and direct SQL programming.Imaging something like this. Y...(related: Software)
Great Plains Dexterity ? Microsoft Great Plains Customization Overview
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics and eEnterprise are Dexterity-written applications. Also small business line: Microsoft Small Business Manager or Small Business Financials is written in Dexterity and uses the same code base as Great Plains.The history of the Dexterity. Great Plains Dexterity - is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package - Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope - that C will provide platform independence). You can install Dexterity from Great Plains 7.5 CD #2. Obviously it requires a lot of learning / training, but it allows your custom piece b...(related: Software)
Microsoft Crm Development
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole conception behind CRM seems to be different. In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind. Microsoft CRM is dedicated to Microsoft technology and so deploys all the Microsoft tools: Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explo...(related: Software)
What Is Preventive Maintenance Software?
Preventive Maintenance (PM) is defined as scheduled work done on a system to identify and fix any occurring issues before they become problems. The concept of preventive maintenance applies to many different industries. PM is often done on buildings, various types of machines, computers, institutions, as well as personal assets, including finances and property.A common example of preventive maintenance is a car getting its oil changed. Usually, this is done when the car is in good working order to prevent any future problems resulting from the car running on old oil.In the past, preventive maintenance ...(related: Software)
Microsoft Great Plains: Exchange & Brokerage ? Implementation Notes
If you company is small or mid-size special products or materials exchange broker, you probably have custom in-house made exchange application. Nowadays exchange is done over the internet, so you might have advanced web-based exchange application. Microsoft Business Solutions Great Plains could play the role of the backend: accounting, sales and purchasing ordering, backordering, allocation, collection. In this case we expect tight integration between your exchange application and Great Plains. In this small article we consider industry / market niche specifics and the ways to realize these requirements:? Exchange Transaction. Exchange transac...(related: Software)
Why Stick With Email Clients Like Outlook?
Trying to figure out a stream in banning one email client or another is no easy job. As soon as somebody rises up saying Outlook is bad, somebody else comes saying it's good and the other one is bad. And the story goes on and on.On one hand, email clients like Outlook Express and (even more) MS Outlook do a really good job when it comes to user friendliness. What email client allows you to use more options on the agenda, bell ringers, flag wavers and contact managing tip...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software