![]() There are few funny things in MS RMS you should be aware. Here we are talking about custom integration, which you can create as a stored procs set. At this time they are ready to be integrated with such accounting system as Microsoft Great Plains. RMS normally replicates transactions from the stores to Headquarters upon the store business hours close. Integration with Great Plains or other SQL Server Accounting package.The other way is having all the stores as linked servers from Headquarters MS SQL Server Enterprise Manager ![]() Yes – they will enable you to communicate with store database and have transaction data updated over there. 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 If you need custom logic work with the POS transaction – you have to update store database data. ![]() There are some exceptions – global data, such as global customers are updated on the headquarters level and updates propagated to the stores. ![]() When store is closed – Headquarters pulls its transactions via worksheet. As it is POS automation application, it assumes that all the POS transactions are originated at the store. Microsoft RMS Architecture and data flow.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |