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

We have stores in different states, so we assign different item taxes to different stores for each item in our HQ database. Normally when we create a new item we start by copying an existing item. This also copies the tax assignments for each store for the item and makes item creation easier.

We have started to use the RR Import Utility to import certain new items, but RR has not yet given us a proceedure for easily updating the store item taxes for the imported items. Does anyone out there know how to do this? When we import an item using the Import Utility, do we have to go into each item and manually asign the item taxes for each store?

Reply to
Charles
Loading thread data ...

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

Reply to
Afshin Alikhani

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

Reply to
Terrible Tom

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

Reply to
Afshin Alikhani

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.

Reply to
jenifern

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.

Reply to
Afshin Alikhani

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.