Skip to Content
0

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

Nov 02, 2017 at 11:06 AM

57

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Marini Shen Dec 15, 2017 at 03:54 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded