RMS IMPORT UTILITY DOSNT IMPORT TAX

"daniel buntic" wrote in news:002901c88831$942e81b0$6f01a8c0@techpublic:

In the PLU/Inventory file? Or is this the setup for store TAX %...which one?

It would be the inventory, the actual items. The store tax I can do manually but we have over 5000 items to import. Meaning its not importing the item tax

-----Original Message----- From: STEP2000 [mailto: snipped-for-privacy@step2000.net] Posted At: Monday, March 17, 2008 3:42 PM Posted To: microsoft.public.pos Conversation: RMS IMPORT UTILITY DOSNT IMPORT TAX Subject: Re: RMS IMPORT UTILITY DOSNT IMPORT TAX

"daniel buntic" wrote in news:002901c88831$942e81b0$6f01a8c0@techpublic:

In the PLU/Inventory file? Or is this the setup for store TAX %...which one?

Import all of your items 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)

This will do it in about 2 seconds.

Hope this helps

HELLO, DOES ANYBODY KNOW HOW TO IMPORT THE TAX FIELD WITH THE IMPORT UTILLITY TO RMS. IT SEEMS WHATEVER I TRY IT WILL NOT IMPORT IT.

ANY HELP WOULD BE APPRICIATED. TX

CHICAGO CASH REGISTER Daniel Buntic snipped-for-privacy@chicagocashregister.com 847-965-9500