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

    • IM2900 Inventory Management Kit File Maintenance

      Kit File Maintenance Application Overview The Kit File Maintenance application allows the user to design and maintain kit structures. A kit is essentially a flat bill of material that maintains single level relationships between a parent item and a ...

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