i want to creat a saved search or report that sum quantity on hand per items that serial number end with 24 and the serial number for example is LOT#2924 and for your information called ends with in

Criteria

tab

AI generated answer (using internal Slack threads):

To create a saved search or report that sums the quantity on hand per items where the serial number ends with '24', you can follow these steps: 1. Navigate to

Reports > New Search

. 2. Select

Inventory Detail

as the record type. 3. In the

Criteria

tab, add a new filter. Select

Serial/Lot Number

as the field,

Ends With

as the operator, and '24' as the value. 4. In the

Results

tab, add

Item

,

Serial/Lot Number

, and

Quantity On Hand

. For

Quantity On Hand

, set the summary type to

Sum

. This will give you a report that sums the quantity on hand for each item where the serial number ends with '24'. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******