Skip to Content
author's profile photo Former Member
Former Member

To locate committed stock is for which customer

Posted on Nov 07, 2016 at 03:52 AM 62 Views Last edit Jun 08, 2017 at 06:48 AM 2 rev.

Please help teach me how to know committed stock is for which customer or which open SO?

SAP Business One
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Nagarajan K
    Nagarajan K
    Posted on Jun 10, 2017 at 12:00 AM

    Hi,

    1. Find particular item from Item master data

    2. Right click and then choose 'Inventory status'

    3. Double click the row to see committed qty for sales order.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Balaji Selvaraj
    Balaji Selvaraj
    Posted on Jun 12, 2017 at 04:24 AM

    Hi Kimberley

    Try the below query

    SELECT T0.[ItemCode], T2.Quantity, T1.[DocNum], T1.[CardCode], T1.[CardName] FROM OITM T0 inner join Rdr1 T2 on T0.ItemCode = T2.ItemCode INNER JOIN ORDR T1 ON T2.[DocEntry] = T1.[DocEntry] WHERE T0.[ItemCode] =[%0] and T1.[DocStatus] Not In ('C') and and T1.[CardName] =[%1]

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded