SAP Business One - Stock report with batch/serial and bin location

[attila_sarkady]

Can I write a query in Business One what shows the stock quantity and value with batch/serial numbers and bin locations?

I need the stock information for a past date.

I would like to complement this query with batch/serial and bin locations:

select ItemCode, sum(inQty-OutQty), sum(TransValue) from OINM where DocDate <= @CloseDate group by ItemCode

Thank you for the answers.

[attila_sarkady]

Dear Nagarajan,

Thank you for the answer. This result is helpful.

I will check the tables what this report based on.

Thank you,

Attila Sarkady

[kothandaraman_nagarajan]

Hi,

Have you tried with Bin location content list under Inventory reports?

Regards,

Nagarajan