Inventory Starting out

Hi Pac, there are many ways you can do that i.e. Using the Physical Inventory option, using the inventory Wizard or Administrator program. I am writing below the inventory procedure using the sql script.

1. Go to Store Administrator and connect to your database click ok also
2. Go to Query Menu and click new
3. Write the query in SQL command windows UPDATE ITEM SET QUANTITY=0,QuantityCommitted=0
4. and click on > button this will make zero quantity.

Now if you how we can do this using the physical inventory or inventory wizard let me know.

Rate this please.

"Doug Pic-N-Pac" wrote:

== "Doug Pic-N-Pac" wrote in message news: snipped-for-privacy@microsoft.com... I am trying to get my inventory to zero in all the qty fields how do i do this?

Manager | Inventory | Physical Inventory | New | OK | type something in the reference number for future reference | OK | Commit | Yes

orders and layaways.