Dynamics Community Forum Thread Details

Zero Out Inventory Totals

This is the first year that we are completing an inventory. I already have scanned our items with a handheld scanner and have the new data files to import our floor's inventory. My problem is that all of our current items show 0 or a negative number. I want to make all of these inventory totals zero before importing my current accurate inventory totals.We have about 20,000 items, so doing this by hand on each item will not work. I would imagine I can do this with a SQL command in Administrator. Does anyone know of a way that I can do this? Any help is appreciated.

Hi DVC. There is an easy way to do this, but please be advised.

*** There is absolutely no way to undo this action. This action requires running a SQL query. If you are not comfortable doing so, please contact your RMS reseller for assistance. If you do not have one, you may email me at support@firsttechsolutions.com for assistance. You need to be sure and make a backup of your database before you do this. To create a backup quickly, you can open Store Operations Manager, login, then under the Utilities menu click Backup Database. Make sure to store your backup in a location on your hard drive that will be easy to remember. ***

When you are ready, open Store Operations Administrator. Under the File menu, click Connect. In the Password field, type your sa password and click OK. You should see the Server and Database in the bottom left corner populated with the correct information. Under the Query menu, click New. In the New Query window, type the query below exactly as it appears, then press F5. Once you run the query, all of your quantities should be set to 0.

UPDATE Item

SET Quantity = 0

Quick Links

Leaderboard