Skip to main content
Solved

Issue with Available QTY on Sales Order

  • Nov 11, 2024 10:21 PM UTC
  • 6 replies
  • 203 views
  • Translate All

Forum|alt.badge.img

Hello,

Is there any way to not include the PO open order quantity in the available quantity on sales order ? For example, we have 2.28 CS of this item on hand, but the system shows 6.28 CS available because it included 4 CSs from open purchase orders that have not been received yet. 

 

Best answer by Dawood

Thank you @Laura02 ,

 

I unchecked these, and it still includes the open PO QTY in the available QTY, although I removed the item and added it back to the sales order.

 

View original

6 replies

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Nov 11, 2024 10:29 PM UTC

Hello,

Please Check the Availability Calculation Rules for this Stock Item/Item Class:

 

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • Nov 11, 2024 10:41 PM UTC

Thank you @Laura02 ,

 

I unchecked these, and it still includes the open PO QTY in the available QTY, although I removed the item and added it back to the sales order.

 

Translate

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Nov 11, 2024 10:48 PM UTC

Hello,

We have one more step: Recalculate Inventory, at least for the Item Class whose Availability was changed.  From the help:

Laura

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Nov 11, 2024 11:45 PM UTC

Hello @Laura02 ,

It solved the available QTY on the sales order screen, but I have to update the sales order form to show the available QTY for shipping under the “Avail” column . I had a hard time finding the field from available tables on the report design. 

Do you know how to show the available QTY for shipping on the form?

 

 

Translate

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Nov 11, 2024 11:54 PM UTC

Hi,

I think I see the field you need in your screenshot - QtyHardAvail.

I used Customize → Inspect Element, to see what Field, in what DAC is behind “Available Quantity for Shipping” in Inventory Summary screen:  it’s QtyHardAvail.

Laura

Translate

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Nov 14, 2024 5:36 PM UTC

Hello ​@Laura02 ,

 

Thank you for the screenshot. I updated the field with QtyHardAvail on the form. 

Translate