Quantity Avaiable field

Hello all,

I am trying to find a way to solve an issue that I have with how the Quantity Available field is displayed in Item Inquiry.  It's kind of a difficult issue to explain but I'll try my best here:

Lets say I have 300pcs of an item On Hand.  Let's say a customer order 300pcs and we create a sales order for that customer.  Then quantity available shows 0pcs.  This is fine and works as it should.  However, if I create a Purchase Order specially for that Sales Order, then I'd like the quantity available to show 300pcs, because that is how much I have "available" to still sell from my quantity On Hand.  And I will fill that "special order" with the purchase order that I made specially for that order.

Is there any way to address this issue?  Please let me know.  Thank you.

  • 0 in reply to Kevin M

    Hi Kevin, thanks for the reply!  The issue is that if I only want to exclude the order qtys that I have a "special" order for.  To try to explain better, here's a little more complex scenerio:

    Let's say I have a Qty On Hand of 10pcs and I have 3pcs on order/backorder as committed and 20pcs on PO.  As it stands now, qty available will correctly show as 7pcs because that is what I have available to ship to others.  Now let's say I get a "special" order for 50pcs, and I put in a PO for 50pcs for this particular order.  I'd still like qty available to show as 7pcs because that's what I have available to sell others.  If I change quantity available to include PO's, the quantity available in this scenerio would show 27pcs, because I have a total of 70pcs on PO, 10pcs on hand, and 53 pcs committed in sales orders/backorders.

    Please let me know.  Thanks.

  • 0 in reply to rmmfg

    The system doesn't have the ability to treat different PO's as "special", if that is your question.  You could enter the special SO as a Master or Quote instead, which should not drain Available.