Skip to Content
0

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

Apr 12 at 12:43 PM

16

avatar image

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.

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

2 Answers

Nagarajan K Apr 12 at 01:30 PM
0

Hi,

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

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
Attila Sarkady Apr 13 at 12:43 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded