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

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 item, the value in the QTYAVAILBYCOMP attribute will come from the first component with "M" in the "Purch or Mfg?" field.  If a Kit item has no components with "M" in the "Purch or Mfg?" field, the value on the QTYAVAILBYCOMP attribute will be "P."

Begin by adding the following to Reference 4 for the QTYAVAILBYCOMP attribute (System Utilities --> System Files Setup --> Maintenance --> Attribute File)



Next, navigate to Global Setup --> Utilities --> I/M utilities --> Utilities --> generate statistic info --> Generate --> update qty. avail. by Comp. attribute --> Generate and run the report.  The new "P/M/MM/MP (Kit from comp)" field has also been added to the CSV file generated when running the report.

In the following example for a Kit item, notice the value in "Purch or Mfg?" is "P."


Since this is a Kit item, we search Kit components for the first component with "M" in "Purch or Mfg?."  In our example, the first "M" component has "P" in the "Mostly" field.



Thus, the value in the "P/M/MM/MP (Kit from Comp)" field will be "MP."



Modified programs: IMQACOMP.WS, IMQACOMP.PL, IMQACOMP.CBL, CPSABPRC.CBL (compile only)

DLM



    • Related Articles

    • 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 - Obsolete Kit Parent When First Component is Obsolete

      Release Date - 5/17/16 This feature will allow the user the option to obsolete all kit parents if the first kit component is marked obsolete through Item Master File Maintenance, through the Change Item CSV Import, or through the Mass Obsolete Item ...

    • If I Override the Value in QTYAVAILBYCOMP* Attribute to Zero, Will that Zero Value Stay?

      Release Date: 3/4/21 Version: 8.5 & Up Q - The following item is a kit parent item. Our user would like to make the Stock Qty Avail and Scheduled Qty Avail zero because they have determined the kit structure is too complicated and they have concerns ...

    • Feature - Prevent MM Item from Purchasing

      Release Date - 3/11/16 The purpose of this feature is to prevent an MM item from purchasing. MM item means the item's purchased or manufactured code is set to “M” and the item’s mostly purchased or manufactured is set to “M.” In the Purchase Order ...

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