Hi There, is there a quick way to reset stock levels to zero ?? I have imported a stock package from our other store but need to reset these levels back to zero. any help would be great .
Reset Stock levels
Apr 01, 2010
3 Replies
If you want to reset all Restock Levels to zero for all items, you can run the following SQL Statement: "UPDATE Item SET RestockLevel = 0". Please make a backup before you run this statement and know that thsi help is given "as is" and there is no expressed warrenty or garentee.
If you are running Microsoft RMS, select Manager, Wizards, Inventory Wizard, Task 150: Change Item Quantities, select All Depts, select Reason Code (if defined), click Finish to view the worksheet, set New On-hand Qty for first entry to 0, right-click and select Copy, right- click and select Paste to All Rows, then Commit.
If you are running Microsoft POS, select Manager, Inventory, Inventory Wizard, Next, Change item quanties, and follow a similar procedure.
Ron L.
Hi There, is there a quick way to reset stock levels to zero ?? I have imported a stock package from our other store but need to reset these levels back to zero. any help would be great .
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required