Inventory by Preferred Location

Use the following CASE formula in your saved search criteria, to report on inventory levels for each inventory items preferred location only.

For example if my inventory item has a Preferred Location of Sydney, this search will only return inventory levels for the preferred location of Sydney. 

1. Go to Reports > Saved Searches > All Saved Searches > New.

2. Select Item

3. Under Criteria > Standard enter:

Type = Inventory Item

Formula (Text) = CASE WHEN {preferredlocation} = {inventorylocation.name} THEN 1 ELSE 0 END

Feel free to add/remove result columns to suit your needs.

When you run the saved search you will now see inventory levels, only for the Items preferred locations.

In the below example, all three items have a Preferred Location of Sydney.

 

 

Did this help? If not, try contacting us Submit a request

Comments