This discussion is archived
2 Replies Latest reply: Feb 12, 2013 9:30 PM by HrishikeshJ RSS

Onhand - Quantity Suggested

User434015 Newbie
Currently Being Moderated
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
    PS Pro
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    Hi,

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

    Thanks,
    Hrishi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points