On Hand Balances Report /Query

Summary:

My client needs a report that provides information for their on hand inventory. I ran the OTBI report, but I cannot see the item revision.

Does anyone know how to get a simple onhand report with Item Revision too?

Content (required):

Columns:

ORG

Subinventory

Locator

Item

Item Revision

Qty

UOM

LOT #

Serial # ( I plan to have a SN Controlled items on a separate report)

Are the main columns I'm interested in.

Version (include the version you are using, if applicable):

23A

Code Snippet (add any code snippets that support your topic, if applicable):