Create a Report or a Search which Displays Specific Costs for Each Serial-Numbered Item.

To create a report or search which displays specific costs for each serial-numbered item, perform the following:

1. Navigate to Lists > Search > Saved Searches > New.
2. Click Transaction.
3. On Criteria tab and Standard subtab, set the following:
   • Item Fields... > Costing Method = Serialized
   • Account Type = Other Current Asset
   • Posting = True
   • COGS Line = False
4. On Results tab and Columns subtab, set the following:
   • Item : Summary Type = Group
   • Transaction Serial/Lot Number : Summary Type = Group
   • Units : Summary Type = Group
   • Transaction Serial/Lot Number Quantity : Summary Type = Group
   • Item Rate : Summary Type = Sum
   • Formula (Numeric) : Summary Type = Sum : Formula = {rate}*{serialnumberquantity} : Custom Label = Value
5. Click Save.

Note: Users may attach their case to Enhancement 174119: Ability to pull the specific cost per serial number of a serialized item on the search report.