RR Import Utility - How to assign item taxes to imported items

we are adding dynamic update over the next 2 weeks for tax, re-order point and reorder level.

Assuming that all items in any given store should have the same tax setting...

Disclaimer: BACKUP FIRST. It'd be best if you did this after hours, just in case something goes wrong. Execute any query at your own risk.

From SO Admin, run these two queries separately:

SELECT * from Tax

Take note of the ID for the tax you want to assign

UPDATE Item SET TaxID = X

Where X = the ID of the tax you want to assign.

This will set the tax for ALL ITEMS. If you want to be selective, you'll need to determine the appropriate criteria to narrow the scope of your UPDATE statement. For example, you could append 'WHERE DepartmentID = X' or some other similar criteria like Supplier, Category, etc. If you have, say, LABOR as a non-inventory, non-taxable item, you could use WHERE ItemType 7 (ItemType 7 = Non-Inventory Item) to exclude all non-inventory items.

If you need more help, let me know

Tom

No we will allow you to define the tax and reorder point and reorder level by store and by item.

We just purchased the RR Import Utility from our Microsoft Partner. We are unable to find out how the license works. Can we use the utility more than once? What about different databases. For example, if we decide that an import fails can we start over? Our partner does not know the answer and have not been able to get an answer from RR.

We have a single store and want to import from our current system (another MS SQL database).

Please advise.

YES you can. There is a word document that explains how this works. Please email me and I will have someone contact you to help you with it.