Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 12 at 01:30 PM

    Hi,

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

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13 at 12:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded