How Is Scheduled Qty Avail Calculated in QTYAVAILBYCOMP Attribute for a Manufacture Item?

Release Date: 11/18/20

Version: 8.5 & Up

A - How is "Scheduled Qty Avail" calculated for a manufacturing item? See example below:

In the above example, since we didn't purchase this parent item directly, does it means we can promise customers that we will have enough components on 12/13/2020 so we can produce 26 of them?

Q - The answer is "YES" based on the current quantity availability of the components. But allocation for parents and components can change between now and 12/13/2020.  Below are the details. This MM item consists of the following components:

Item#	Qty Per	Stock Qty Avail	Schedule Qty Avail	Schedule Date
KBX8130*	1	26	192	1/3/2021
KX8610	1	79	420	12/15/2020
KBH8960DXC	1	0	60	12/13/2020
KBH8960DXH	1	10	60	12/13/2020
KBDH8960DX	1	86	180	2/21/2020

The component KBH8960DXC is the critical component now. But if you consider the fact that you are going to receive 60 of them on 12/13/20, then it is no longer the critical component on that date. Our schedule date thus is 12/13/20. On that date, item KBX8130* becomes the critical component which we expect to have 26 of at that time.

 Therefore, you can promise 26 on 12/13/2020 as of this moment. 

 EMK

• Related Articles

• How Is Scheduled Qty Avail Calculated in QTYAVAILBYCOMP Attribute for a Purchase Item?

  Release Date: 11/18/2020 Version: 8.5 & Up Q - Can you explain how the 'Scheduled Qty Avail' in QTYAVAILBYCOMP attribute is calculated? Below is the Stock Status Inquiry screen: The attribute QTYAVAILBYCOMP shows: How is the Scheduled Qty Available ...

• Common Issues Raise Questions about QTYAVAILBYCOMP Stock Qty Avail

  Released Date: 10/01/20 Version: 8.5 & up For those users who use the QTYAVAILBYCOMP attribute, they may frequently have questions on how the value of "Stock Qty Avail" in QTYAVAILBYCOMP is calculated. See sample screen below: Well, it is ...

• Feature - New QTYAVAILBYCOMP Attribute Fields

  Release Date - 9/2/16 The QTYAVAILBYCOMP, QTYAVAILBYCOM2, and QTYAVAILBYCOMP3 attributes can be used to decide whether or not there is enough stock to ship or produce a parent item. If not, the attribute fields contain information on when the parent ...

• Feature - Change QTYAVAILBYCOMP “Stock Qty Avail” Calculation Logic

  Release date: 2/4/2021 The current calculation logic for the QTYAVAILBYCOMP attribute field "Stock Qty Avail" is: Qty On Hand - Qty Allocated + Qty Back Ordered This is the same definition as Excess Qty, which means "Short Term Qty Available." It ...

• Feature - Support P/M/MM/MP Value in QTYAVAILBYCOMP Attribute from the First Kit Mfg Item

  Release date: 4/6/2021 Version 8.5 & Up This project adds support for a new field in the QTYAVAILBYCOMP attribute that will show the value in the "Purch or Mfg?" and "Mostly" fields on the Item Inquiry or Maintenance screen. If the item is a Kit ...