Item Tax

Jul 31, 2009 1 Replies

Rate this thread:

Julie 16 years ago

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

Vote

Bopper 16 years ago

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

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required