1. The first step is to build a query for all of the inventory you have updated. 
    1. Go to Analysis > Information Library 
    2. Click to add a new Ad-hoc query 
    3. Select the Record type of Merchandise Item
    4. Choose Merchandise Query and click OK
    5. In the left column, expand Inventory Item, then highlight History. In the middle column, drag Action Date to Include records where. Set this to be equal to or between the dates of your inventory update. 
    6. With History still highlighted in the left column, drag Action Type to Include Records Where. Set this to be equal to Physical Count. Your query will appear like this:   Image of Query with Updated Inventory
    7. On the Set Save Options Tab, name your query and check the boxes to Create a selection and to Show the selection in query designer.                                           Image of Set Save Options Tab
  2. The next step is to use this selection to create a report of merchandise not updated in your inventory process. 
    1. Go to Analysis > Information Library 
    2. Click to add a new Ad-hoc query 
    3. Select the Record type of Merchandise Item
    4. Choose Merchandise Query and click OK
    5. In the left column, highlight the Selections folder. In the middle column, drag the selection you saved in the previous step to Include Records Where. Set this to be equal to No. This will pull in all items that were not updated through a physical count. Your field will appear like this:  Image of filtering on a selection
    6. You may also want to exclude Inactive items. To do this, highlight Merchandise Query at the top of the left hand column and drag Active from the middle column to Include Records Where. Set this to be equal to Yes. This will only include active items in your results.
    7. You may also want to see information about this item in the results. Here are a few suggestions for output fields: 
      1. Inventory item\Quantity - will show you the current quantity of the item
      2. Inventory item\Retail Price - will show you the current retail price of the item
      3. Inventory item\Average cost - will show you the average cost of the item
      4. Inventory item\Current cost - will show you the current cost of the item
      5. Inventory item\SKU - will show you the SKU number
      6. Inventory item\Current vendor\Name - will show you the name of the Vendor. 
    8. Save your query and export the results to Excel to review your list.
  3. The last step is to review your list and update any items that need to be reduced to 0. To update your items, go to Merchandise > Update Inventory.
  4. Create a new batch and enter the items in your query. Reset the quantity for all of these items to 0. 
  5. Save your batch. 
  6. Commit your batch to the database to complete the process.