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 Aplikasi Akuntansi 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 didnt 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
PUEBLO CONTINENTE
Microsoft Retail Management System (RMS) SQL customization overview for programmer
Loyd Grano (2019-02-28)
| Enviar respuesta
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.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 Aplikasi Akuntansi 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 didnt 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
Añadir comentario