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

    • Avalara Attribute Support

      Release Date: 4/28/23 Updated: 1/26/28 Version: 8.6 and Above For Elliott to work with the Avalara Sales Tax Interface, there are additional data to be stored on the Elliott side. Our implementation chooses to store these data in the following ...

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

    • Change - Update Both Kit Parent and Components Usage

      'Release Date: 5/17/2016 Issue with Update Kit Parent Item Usage Before the Elliott 7.56.602 or 8.06.602 release, when a kit was posted in COP sales journal, it was possible the usage of the parent item was not updated. This behavior was based on the ...

    • BM1501 Bill of Material Feature/Option Configuration Maintenance

      BM1501 Bill of Material Feature/Option Configuration Maintenance ← Bill of Material / Work Order Plus Feature/Option Configuration File Maintenance Application Overview The Feature/Option Configuration File Maintenance application enables the user to ...

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