POS Technical Documents

Microsoft RMS SQL Tax Change

Microsoft RMS SQL Tax Change

Import all of your items from portable hand held inventory scanner and create a new tax in the system. Then run a SQL query to add tax to all items.

BACKUP YOUR DATABASE BEFORE RUNNING ANY SQL QUERIES

To run a SQL query, open Store Operation Administrator and connect to the
database. (File -> connect -> enter SQL password -> OK)
Go to Query Menu -> New

First find your TaxID
SQL query: select * from tax (the TaxID is the 3rd coloum)

Set all items to be taxed
SQL query: update item set taxid = x (where x = the TAXID, usually 1)