Friday, March 29, 2019

Search to show the net/total on hand quantity of two locations

Search to show the net/total on hand quantity of two locations

1. Navigate to Lists > Search > Saved Searches > New > Item.

2. Under Criteria tab > Standard subtab, enter the following fields:
Type: <item type>
Inventory Location: any of <Location 1> and <Location 2>

3. Under Criteria tab > Summary subtab, enter this field:
Summary Type: Sum
Field: Formula (Numeric)
Description: Greater than 0
Formula: {locationquantityonhand}

4. Under Results tab, enter the following:
Name
Summary Type: Group

Description
Summary Type: Group

Formula (Numeric)
Summary Type: Sum
Formula: {locationquantityonhand}

5. Enter a Search Title and hit Save.

 

 

 

No comments:

Post a Comment