Report for current status of lot numbered Items.

Client would like to get a report showing current inventory status of the lot numbered item.

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

2. In the criteria add

Is Lot numbered Item is True

Inactive is False

2. Go to Results tab > Columns subtab and add the field below:

Field = Inventory Number : Expiration Date

Field = Inventory Number : Available

Field = Inventory Number : In Transit

Field = Inventory Number : On Hand

Field = Inventory Number : On Order

3.  Hit Preview or Save & Run button