tax not being applied to all items

Update:

Certain items are still not being taxed when scanned at POS. It's not random...some items will get tax applied, some will not. If I go into an item properties and manually click the tax id dropdown then the item taxes correctly and problem is fixed. But we have 13,000 items in db so this isn't an option. I also ran a sql command: "update item set taxid = 3 where departmentid = 2" and the command completed successfully. But the problem still exists. Could this be database corruption?

One more update...sorry

If I do a query into the database using "select * from item" to see all items, I have specifically found items that have a taxid set, but when scanned into the POS they do not get tax applied. And I have rebooted everything.

Thanks

there was a hotfix that addressed the tax selection box not properly being affiliated with the tax field in the table, but this was a long time ago.. Are you up to the latest version??

I'm on 2.00.016

I've found that if I manually go into an item, change the tax drop down to unassigned and then change it back to "sales tax" that seems to fix the problem. But again it's 13,000 items so I'm trying to figure out why program doesn't seem to be working correctly.

Thanks for the response.

Sounds stupid but I just updated all my stores for the NYC sales tax change and Z'ed out each register as it says. Well guess what, you need to RESTART the register for it to take not just run a Z report. I figured this out a bit late.

I'm on 2.00.016

I've found that if I manually go into an item, change the tax drop down to unassigned and then change it back to "sales tax" that seems to fix the problem. But again it's 13,000 items so I'm trying to figure out why program doesn't seem to be working correctly.

Thanks for the response.

I'm on 2.00.016

I've found that if I manually go into an item, change the tax drop down to unassigned and then change it back to "sales tax" that seems to fix the problem. But again it's 13,000 items so I'm trying to figure out why program doesn't seem to be working correctly.

Thanks for the response.