Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 15, 2017 at 03:54 AM

    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 :)

    Add comment
    10|10000 characters needed characters exceeded