What is the SQL query behind the Serial Number Transaction Report in SAP Business One?

[Former Member]

Hi Team,
I'm trying to run the Serial Number Transaction Report in our backend SQL database. Does anyone know the query used in that report?

Thanks!

Valerie

[Former Member]

Hi Valerie,
you can try using select * from OBVL, this is a table of Serial Numbers and Batch Valuation Log.
If you want to link it to its master data, you can join the table to : OSRN (Serial Numbers Master Data)

Please have a try 🙂