Creating a Daily Inventory Additions Search

You can create a saved search that provides the names and quantities of items added to inventory each day.

To create a daily inventory additions search:

  1. Go to Reports > Saved Searches > All Saved Searches > New and click Transaction.

  2. Enter a descriptive search title.

  3. On the Criteria subtab, add the following filters to the Filter column:

    1. Date – Set the date to be today.

    2. Account – Select your inventory account.

    3. Posting – Select a Yes value for this filter.

    4. Formula (Numeric) – In the Formula field, type {quantity}, set Formula (Numeric) to greater than and Value to 0.

  4. On the Results subtab's Columns subtab, add the following fields:

    1. Item – Select a Summary Type of Group for this field.

    2. Quantity – Select a Summary Type of Sum for this field.

    3. Add and remove other fields as needed.

  5. Complete other subtabs as needed.

  6. Save the search.

Related Topics

Defining a Saved Search
Advanced Search Criteria Filters
Search Results Display Options

General Notices