I've moved, and I am updating my item taxes.
Because the wizard doesn't seem to be very efficient at this, here is the SQL I am planning to run. The ID from my old tax is 1, and the ID for my new tax is 4. It appears that I only have the one table to update. Is there any other table I need to update?
update dbo_Item set TaxID = 4 where TaxID = 1
Thanks, Julie
Julie,
It should actually be:
update Item set TaxID = 4 where TaxID = 1
Does this work you? the sql query says it works for me, but when I ring items up it seems that the command didn't take.
Thanks
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.