Historical stock with batches and historic BIN location

[pm_witmond]

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

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please try with below tables,

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

Thanks

[pm_witmond · Accepted solution]

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