Sales tax disappears in Headquarters

Jan 24, 2008 2 Replies

In headquarters; sales tax for different manufactures is all of a sudden disappearing. We have used an SQL tax updates to fix our HQ database followed by a 260 worksheet. We run this update after all the stores are closed, but the next day the sales tax is missing both in headquarters and at the store level again. We are completely at a loss as to how to fix this. Is anyone else having similar problems or have any suggestions as to how to permanently fix this? Again, this problem is at the headquarters level so each time the stores sync with the server they go back to not having sales tax. This syncing overrides any tax wizards used at the store level. Please offer any suggestions.



Thanks in advance, Aaron



In headquarters; sales tax for different manufactures is all of a sudden disappearing. We have used an SQL tax updates to fix our HQ database followed by a 260 worksheet. We run this update after all the stores are closed, but the next day the sales tax is missing both in headquarters and at the store level again. We are completely at a loss as to how to fix this. Is anyone else having similar problems or have any suggestions as to how to permanently fix this? Again, this problem is at the headquarters level so each time the stores sync with the server they go back to not having sales tax. This syncing overrides any tax wizards used at the store level. Please offer any suggestions.

Thanks in advance, Aaron

I am not sure what sql scripts you have issued against your hq db, or any triggers that might be in place, but let's say that the scripts were not harmful and not triggers are in place - It is possible that if you have different tax structures at stores from HQ, you would see this conflict on the SO side where updated tax would not list, and errors would be received on the HQ worksheet as well as you will receive an error on the store side relating to 'duplicate tax entry'.

Did you receive any errors, have an example of your tax structure on a manufacturer, RMS version #?

I do not know if this is at all related to your issue - but this is something that has happened to us with taxes:

This is all based on huge assumptions (I know) on something I have seen before. HQ has one generic tax structure that does not encompass any tax authorities. Many stores were built out to this same generic tax structure. Because tax was not centrally owned at the HQ level, stores had the ability to change and modify - which would work if you do not need a tax authority structure. Our stores required this structure, or did not like the wording if the generic 'Sales Tax', changing it to their state code + State Tax (i.e. MN State Tax). What these store level mods brought with them was a duplicate record issuing and conflict. The HQ tax code and SO tax codes remained the same, while the descriptions had been modified. All taxes were stripped out. The store had to delete the duplicated line item of Sales Tax and run a Task

190: Assign Item Sales Tax. Because of these issues, our stores are now required to run the Wizard on a monthly basis, or more often if needed, as HQ is now releasing items w/out tax assigned.

Join the Discussion

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

Didn't find your answer?

Ask the community — no account required