Is there a way to reset all the inventory for all the products while keeping all the products in the database?
I would like to save time by taking the database from location 1 to location
2 and use the same database, but set the inventory of location 2 to 0. That way I will have the database that I want and the inventory can be added to the database after it is delivered to the store.Thanks,
Tom
Tom, You could always run an SQL script to reset the Quantity and Quantity Committed fields to 0 in the Item table, but if this is a 2nd location you are setting up you might need to a different solution. Keep in mind that all sales history, item movement history, po's, etc will be copied as well. This is probably not what you want. Are you using HQ? If you are there is a function to create a new database from existing data for this exact reason.
Try this
UPDATE Item SET Quantity = 0 Update Item Set QuantityCommitted = 0
Make sure you have no open workorders, layaways, etc.
TomT
Ryan,
No. I am not using HQ. This just a standard installation of RMS/POS 2.0.
Is there a way to simply c> Tom,
Hi Tom - backup the database; create the second store's database from the first store's backup - in SO administrator, use the delete transactions feature (database - delete transactions) to remove all history, and use the already mentioned sql update query to set your qty on hand and committed to zero....
Here's some sample info form the help guide...
Important: Customer purchase history, purchase orders, and > Is there a way to reset all the inventory for all the products while keeping
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.