inventory list with available serial numbers

[Laura_Nest]

i would like to create a simple list of inventory items by warehouse with their available serial numbers so I can to a pre-audit/pre-count before the end of year physical count.

Can someone please help me with the query? I tried using RSRN table but the available status is blank.
?

I just need warehouse, item, serial number(available only)

thanks,

Laura

[Laura_Nest · Accepted solution]

i had success using the OSRI table for rows with status <> 1   as 1 = not available.

[Former Member]

Dear Laura

The serial number managed you can find in the next tables OSRN, OITL, ITL1

I show the image of SDK help

Best regards