cancel
Showing results for 
Search instead for 
Did you mean: 

Historical stock with batches and historic BIN location

pm_witmond
Participant
0 Kudos
379

Hi,

We need te create a query to show the stock on a given date.

Using OINM we can create the correct stock values but in this case we also need the batchnumer and the correct BIN code.

If someone can extend the OINM view with the correct Batch and BIN then my problem is solved

Thanks,

Paul

View Entire Topic
kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please try with below tables,

OBTL, OITL, OBIN and OITM to get required information.

Thanks

pm_witmond
Participant
0 Kudos

Hi,

What is the correct link between OBTL and  OITL

When we use :

SELECT T0."ItemCode", T0."DocQty", T0."StockQty" FROM OITL  T0 LEFT JOIN OBTL T1 ON T0."LogEntry" = T1."MessageID"

we don't get the correct records