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

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

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

    • Change – Add Salesman No. to Open Order Report by Customer, Change CSV Order of Fields

      Release date: 6/24/16 For COP --> Reports, --> Order Status Reports, --> Print, --> Open Order report/All Items if field "1. By Item, Cat, Customer or Ship-to?" is C and field "18. Show QTYAVAILBYCOMP Attrib Info ?" is N, the Open Orders by Customer ...

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

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