Feature - New QTYAVAILBYCOMP Attribute Fields

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 items or components will arrive so they can be back-ordered and the promise date can be updated.  If nothing is available to ship or produce in the near future, then the order can be cancelled. The attribute information can also be used for purchasing purposes. These attributes can be updated through Global Setup-> Utilities-> I/M Utilities-> Utilities-> Generate Statistic Info-> Generate-> Update Qty Avail By Comp Attribute.

The feature will add two new fields to the attribute QTYAVAILBYCOMP2. The following is a list of fields for these attributes. The the new fields appear in bold:
a. QTYAVAILBYCOMP – R1 – BOMP Active Group
b. QTYAVAILBYCOMP – R2 – BOMP Avail Qty Group
c. QTYAVAILBYCOMP – R3 – BOMP Sched Qty Group
d. QTYAVAILBYCOMP – D1 – Next Schedule Date
e. QTYAVAILBYCOMP – D2 – Next PO Date
f. QTYAVAILBYCOMP – D3 – Next BOMP Date
g. QTYAVAILBYCOMP – A1 – Stock Qty Available
h. QTYAVAILBYCOMP – A2 – BOMP Qty Avail
i. QTYAVAILBYCOMP – A3 – Scheduled Qty Avail
j. QTYAVAILBYCOMP – C1 – Sched Qty from Stock
k. QTYAVAILBYCOMP – C2 – Sched Qty-RR Status
l. QTYAVAILBYCOMP2 – D1 – BOMP Active Group Sched Date
m. QTYAVAILBYCOMP2 – A1 – BOMP Active Group Qty Avail
n. QTYAVAILBYCOMP2 – A2 – BOMP Active Group Sched Qty
o. QTYAVAILBYCOMP3 – D1 – Next PO Date
p. QTYAVAILBYCOMP3 – D2 – Next BOMP Date
q. QTYAVAILBYCOMP3 – A1 – Next PO Qty
r. QTYAVAILBYCOMP3 – A2 – Next BOMP Schedule Qty Avail
s. QTYAVAILBYCOMP3 – A3 – Stock Qty Available (Neg)
t. QTYAVAILBYCOMP3 – C1 – Next PO Qty-RR Sts
u. QTYAVAILBYCOMP3 – C2 – Nxt BOMP Qty-RR Sts

Currently, the calculation of column “Schedule Qty Avail” is based on ATP. It could be the ATP of the parent item or the components. If it is from the parent item, then the check box “Sched Qty from Stock” will be set to “Y.” If “Sched Qty from Stock” is set to “N,” then it means the "Scheduled Qty Avail" comes from the component ATP.

Currently, for each parent item, there can be multiple ways to produce it. In the product structure, seq# 010 – 090 is defined as the “Active Group” and 100 – 190, 200 – 290..etc. as the “Alternate Group” and they are marked as “obsolete.”  If the "Scheduled Qty Avail" is from the component, then it is based on the “earliest available group,” which can be an active or alternate group. The “Next Schedule Date” represents the earliest group schedule receiving date (from ATP).

This feature adds two additional attribute fields that show Schedule Date and Qty based on the BOMP Active Group.



Thus, we are adding the fields "BOMP Active Group Sched Date" and “BOMP Active Group Sched Qty.”  The Active Group is the preferred way if production is needed. If making a purchasing decision on buying the components, the Active group information is the preferred information, not the alternative group which may arrive earlier.

The "Stock Qty Available" field amount was supported in the QTYAVAILBYCOMP and QTYAVAILBYCOM3 attributes. The field in the QTYAVAILBYCOMP3 attribute now shows the Stock Qty Available, including negative values.



All three fields have also been added to the CSV file that can be generated when the utility is run.

Programs Modified: IMQACOMS, IMQACOMP
CLS



    • Related Articles

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

    • Feature - Read Only Attribute Fields

      Release Date: 4/7/23 Version: 8.5 and Above This feature gives the user the ability to mark an attribute field as "Read Only." Fields that are "Read Only" are shown on the attribute screen but they are disabled and cannot be changed in Attribute ...

    • Feature - Improvements to QTYAVAILBYCOMP and QTYAVAILBYCOMP2 Attributes

      Release Date: 3/29/2017 Two improvements have been made to Atrribues. 1) For attribute QTYAVAILBYCOMP, the BOM Active Group will show if it has a value; even if the BOM Qty Avail is 0. 2) For attribute QTYAVAILBYCOMP2, a new field has been added -- ...

    • Feature - Fields Added to User-Defined CSV to Support the EDI 846

      Release date: 9/10/2019 Version 8.5 & up The primary purpose of this enhancement is to support the EDI 846 (Inventory Inquiry/Advice). E-retailers, like Amazon, Target, Wayfair, Home Depot, and Lowes, often request an updated inventory feed several ...

    • Elliott V7.5 Release Notes: What's New Since Elliott V7.4

      What’s New Since Elliott V7.4 Elliott 7.5 Overview Netcellent has rewritten all the legacy manufacturing modules for Elliott V7.5 and consolidated them into the BOMP module. It simplifies manufacturing data collection while providing powerful ...