Feature - Change QTYAVAILBYCOMP “Stock Qty Avail” Calculation Logic

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 means that this is the quantity you can ship today by excluding back orders.

However, if the Qty Allocated is less than Qty Back Ordered, the resulting Stock Qty Avail will report a quantity greater than what is actually available.  In the following example, the "Stock Qty Avail" would be reported as 11.



Generally speaking, Qty Allocated should be greater than or equal to Qty on BO. So the above scenario is weird.  The reason this can happen is if you have Work Orders with a negative component.  The negative component will decrease Qty Allocated (instead of increasing Qty on Order.)  As of this writing, we are planning to change this logic.

To consider what scenarios can cause Qty Allocated to be less than Qty BO, the calculation logic has been changed as follows:  if the Qty Allocated is less than the Qty on BO, the "Stock Qty Avail" will be equal to the Qty On Hand. For the example above,  the "Stock Qty Avail" will now be 4. If the Qty Allocated is not less than the Qty BO, the current calculation logic will be used.



The QTYAVAILBYCOMP attribute is reset by going to Global Setup -> Utilities -> I/M uUtilities -> Utilities -> generate statistic infO -> Generate -> update qty avail. by Comp. attribute -> Generate

Modified: IMQACOMP.PL

DLM
  
 



    • Related Articles

    • 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 ...

    • 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 ...

    • Customer Account Summary Inquiry Age Days Calculation Logic

      Release Date: 07/07/2021 Version: 8.5 Q - In A/R Customer Account Summary Inquiry, what is the logic on a partially paid invoice? See example below: In the above example, invoice number AXI990 was partially paid on 6/18/21. That is 49 days after the ...

    • Feature - Stock Analysis Processing

      Release Date: 10/28/16 This new feature is available under COP -> Processing -> Pick/Pack Tickets/Ship Labels-> Stock Analysis. This new feature is only available when the QTYAVAILBYCOMP, QTYAVAILBYCOM2 and QTYAVAILBYCOM3 attributes are in use. These ...

    • 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 ...