Reset all inventory to 0

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