2 Replies Latest reply: Feb 12, 2013 11:30 PM by HrishikeshJ RSS

    Onhand - Quantity Suggested

    User434015
      Hi Gurus,

      I was looking at onhand availability screen for one item and it shows data like below:

      On-Hand Quantity: 1
      Available to reserve: 0
      Available to Transact: 0

      Then I tried to pull this information using "inv_quantity_tree_pub.query_quantities" api.
      The result set says "Suggested Quantity" as 1.

      Can anyone help me in understanding what is suggested quantity?

      Thanks in advance.

      Edited by: 987644 on Feb 12, 2013 10:31 AM
        • 1. Re: Onhand - Quantity Suggested
          PranitSaha
          Suggested quantity is the on-hand quantity itself.

          The reason it is showing 0 for both " Available to reserve" and "Available to Transact" is, there must be some record stuck in the temp table for the related item.

          SELECT *
          FROM
          MTL_MATERIAL_TRANSACTIONS_TEMP
          WHERE inventory_item_id = <your item id>

          If it returns any row, you need to delete the same to get the on-hand data corrected.

          Thanks,

          PS.
          • 2. Re: Onhand - Quantity Suggested
            HrishikeshJ
            Hi,

            check mtl_reservations table, there are only two sources to reduce ATR/ATT; reservations and move order allocations.

            Thanks,
            Hrishi