add taxes to item in HQ

Maybe its time I install HQ on my laptop....sorry, for a while I thought you could run this same wizard in HQ; query your tax table to see what IDs are assigned to your tax code(s)

select * from tax

I don't believe the tax code assignment is in the itemdynamic table (now I'm really wishing I had hq on my laptop) - but just in case query it...

select * from itemdynamic

if there's no reference to a taxid, then its in your item table

select * from item

first run select * from item where taxid = 0 this will show you items without a tax assignment; if ALL the items displaying should have a tax assigned, then you can run an update (first backup and do this after hours if possible)

update item set taxid = x where taxid = 0

where x is the id you jotted down when you queried the tax table.....

if some items displaying are indeed nontaxable and shouldn't have their taxcode changed then you'll need an additional constraint on the update statement

sorry for the false start > I don't see a Task 170. I went into maintanance mode in RMS1.3 to "Inventory