Create a Custom Item Field to Dynamically Display an Items Quantity On Hand + Quantity On Order for a Specific Location

The following steps will walk you through creating a saved item search that will sum a specific locations Qty On Hand + Qty On Order and display those results in a custom item field.  This field will display in all inventory items and the calculation will be specific to the item you are viewing or editing.

Step 1:
1. Navigate to to Lists > Search > Saved Searches > New > Item
2. Main section > Enter a name and set Public, Available as list view and Available as Sublist View = TRUE
3. Criteria Tab > Inventory Location = ???
4. Results tab > Field = Formula (Numeric); Summary Type = Sum; Formula= NVL({locationquantityonhand},0) + NVL({locationquantityonorder},0)
5. Available Filters tab > Filter = Internal ID
6. Save

Step 2:
1. Navigate  to Customization > Lists, Records, & Fields > Item Fields > New
2. Name = 'Location' Qty on Hand + Qty on Order
3. Type = Integer Number
4. Store Value = False
5. Applies To tab > Inventory Item = TRUE
6. Display tab > Subtab = Main (or wherever you want it)
7. Validation & Defaulting tab > Search = select search created in step 1)
8. Click Save