Item Master Tab
The following fields may be viewed in the Item Master screen. This screen is the starting point when the Add a New Inventory Record Action button is clicked or an existing record is highlighted within the summary screen.   Clicking the Edit action button allows editing of existing Fields that are not grayed out.  The ICM module will display "Internal" in the screen Header/Title bar, if internal inventory is open, and display the Customer name in the Screen Header/Title Bar if you have consigned inventory open.  This will allow users that have multiple inventory screens open at the same time to seen at first glance which screen contains what type of inventory data.  


 
See Article #4765 for further detail on how to Use the X-Reference Find

 

Item Master Tab Field Definitions

Part Source
This field is hard coded in the system. Select BUY for purchased parts and assemblies, MAKE for an item made in-house (assemblies and sub-assemblies) and PHANTOM which is a list of parts that is common to several subassemblies. 
 
A good example of where a Phantom can be used is a video card with different memory options.  On all the variations of the memory card, there are a lot of parts which are common, including the circuit board.  If we assume the only thing unique to each assembly is the amount or type of memory component and a couple of resistors, then the parts common to all the assemblies can be listed as a PHANTOM assembly.  The PHANTOM part number is then listed as a component under each of the top-level assemblies.  The BOM of the Phantom is exploded in the kitting module as if they were part of the BOM (hence the word Phantom) and pulled with the top level assembly.  It becomes easy to maintain these BOMs since one change in the Phantom will ripple through all the video card variations. 
Phantom/Make If the Part Source is a MAKE and this box is checked, the system will treat the part as a Phantom when the sub-assembly components are called up during the Kitting process BUT as a Make part for a stand alone assembly when the part is NOT a sub-assembly.

 

You can assign the status of "Make/Phantom" to a sub assembly.   In this condition, it will cause the components to be added to a kit for the top assembly as if it was a Phantom BOM. On the other hand, you can also create work orders and demands for the sub assembly itself.  The difference between this Make/Phantom and a straight Phantom is that you cannot build the straight Phantom.

 

Phantoms We suggest that the user utilizes this feature, especially if the subgroup of parts are going to be used in more than one top assembly.   If the subgroup has a modification to its BOM, the user does not have to go to each top level and change all of them.  By simply changing the BOM in the Phantom assembly  (or Make/Phantom), the kitting for all top assemblies including this subassembly will be changed to the new configuration.   If you did not use the Phantom, and copied the parts into numerous top assemblies, you will have to make a change to every one of them if the subgroup of parts was modified.
Make/Buy

Make/Buy is setup to allow users to have a part in the system that they wished to BUY but also keep documentation within the system (BOM).  If the Part Source is a MAKE and this box is checked, the assembly MUST be purchased from an outside sourceIf a Part is marked as Make/Buy within Inventory the MRP will only give PO Actions and that product will NOT be available for selection within the Work Order Management module, (due to MRP calculating incorrect demand and showing incorrect message with safety stock).  If the part souce on a product is originally setup as a MAKE the user WILL be allowed to edit the record and change the part souce to Make/Buy.  For further details see Article #3289 .

Part Class

This is a general part, product or item classification that must be selected from the drop-down box.  If an appropriate choice is not available when entering a new item, you may add a new part class in Inventory Part Class, (examples of Part Classes are BATTERY, DIODE, FUSE, FILTER, IC-SMT, CAP-SMT, RES-TH, etc.)

Part Type
Type is a sub-classification of Part Class. If an appropriate choice is not available when entering a new item, you may add a new part type in Inventory Part Class (examples of Part Types for the Class IC-SMT would be 0603-5%, 0805-10%, 0805-5%, 1206-5%, 1210-5%, etc.)
 
NOTE:  A user does have the option of leaving the Part Type blank, however if this option is selected the prefix for the part number will be omitted.  There is no reason to enforce part type if a user doesn’t want to have that kind of detailed classification.  If the user decides to leave the Part Type blank they will receive a message and at  this point they have the option to continue or go back and pick a Part Type.
Description

There are 45 characters available to put descriptive data about the item being entered that is not already in Part Class and Part Type. For instance, in the previous figure the Part Class and Type already show that it is a RESN-SMT 2512 so this information need not be repeated in the Description.  We suggest when entering the description, that you be consistent with your capitalization and punctuation.  Some of the screens and reports can be sorted by description so the more consistent you are the easier it will be to use the system in the future.

Material Type

This field is an Item fields which is repeat at the top of all Tabs to display the selected Item.  

If the Inventory Material Type is set to "Auto" (within the Material Type Setup), everytime the user modifies the AVL material type, the program will update the Inventory Material Type automatically. 

>> If any of the AVL material type for the item is 'Unk' - the item level type will be 'Unk'
>> If any the material type is the same for all of the AVL's of the same item, the material type for the item will be the same as material type of the AVL's without a suffix.  For example:  if AVL types is anyof the 'LF-P/N', 'LF-Date', 'LF-Mark', the material type for the item will be 'LF'.  If AVL's material type is 'ROHS-P/N', 'ROHS-Date', 'ROHS-Mark', the item's material type will be 'ROHS'
>> If any of the material type of the AVL's for the same item are different and none of them is 'Unk' then the type of the item will be 'LF'

Any changes to the AVL material type that drives the item material type to a lower level will display a warning.

If the control is set to "Manual", then the user will be able to modify the Inventory Material Type from the Material Type pulldown.  Keep in mind that the program will NOT validate if the material type in Inventory and AVL levels are in sync.
 

The AVL Material Type is carried forward for the consign part when the consign part is first added to the system or when new AVL was added to the internal part and the user elects to add this AVL to the existing consign parts.  If the user later changes the Material Type on the internal part, the change is NOT carried over to the consigned part. 
 
Changed This field will display the date of the last change to the material type.  
Initials This field will display the initials of the user that made the last change to the material type.
Serialize

This box will be available only if the option to use Serial Number Tracking in Shop Floor Tracking Defaults is set up.

The system allows this box to be check for a MAKE or BUY part. If this box is checked for a BUY part, all components are being tracked by a serial number that was assigned to the part at time of receipt. If this box is checked for a MAKE part, the FG assemblies will be tracked by the serial number through complete process. Note:  Once a serial number for a MAKE part is created, we don't allow user to turn off the serialized checkbox anymore, even if there is no qty on hand and all accounting records are cleared.  This is so no history of Shop Floor tracking, shipping, RMA’s, etc. . . . for the Make Parts are lost. 

If a user changes a non-serialized part to a Serialize part the system will check.  * If the part has allocated qty, (user has to un-allocate parts before the system will allow user to check the "Serialize" box).  *If  the part has any OPEN kit (kit in process), (user has to de-kit or close kit before system will allow user to check the "Serialize"  box)  *If the parts is a BUY part and has un-reconciled PO (user has to reconcile all receipts before system will allow user to check the "Serialize" box).

After all these criterias are passed, if the part has quantity on hand, the user has to enter the serial numbers to match the quantity on hand.
 
Note: Users have to have special access in order to modify this checkbox, this access is assigned through Security/User Rights. 
Status All items must be Active in order to buy, receive, issue, invoice or ship. Use Inactive Status to remove items from use that have already had transactions against the Part Number.  Use Delete button to delete Items with no transactions.  Changing status from Active to Inactive (for a Make Inventory part) will NOT change BOM status. User will have to change BOM status seperately.  Changing from Inactive to Active status can be used to release items from Engineering.  Note:   If WIP (Work-in-Process) exists for a part the system will not allow the part status to be changed.  This will prevent any possiblity's of qty on hand being returned to an inactive part if the users would happen to dekit.   
Part Number

Item/Part number is a unique identifier for every Item Master record entered in the database.  Part numbers can be setup to be manual numbered, or auto assigned to all items except MAKE assemblies, or all items including MAKE assemblies (within the Number System setup module). The standard part number is a 3-digit dash seven digit format where the three-digit prefix is used to define the part class, part type setup in the Inventory Part Class setup module to work with auto or manual numbered parts and assemblies. A manually assigned part number can be 25 characters.  Alphanumeric part numbers are permitted.  The revision field is 4 characters, also alphanumeric. ManEx uses separate assembly and revision fields making it easier to group all revisions of the same assembly and verify that the correct version is selected for production

 ABC
Stock/BOM UOM
 

This is the Unit Of Measure (Foot, Inch, Each, Gallon, Quart, etc.) that is used to specify how much of the Item displayed or being entered is issued from Stock or is used in a Bill of Material for an assembly.   ManEx tracks stocking units of measure within inventory, kitting, MRP, etc.   

Purchase UOM
This is the Unit Of Measure (Foot, Inch, Each, Gallon, Quart, etc.) that is used to specify how the Item displayed or being entered is purchased from a supplier.

NOTE:  When creating a PO for an item with different purchasing and stocking UoMs, be sure to enter the MRP suggestion into the Stocking qty field rather than the purchasing qty field.  The system will automatically convert the stocking unit into the purchasing unit for the purchase order qty.

For example if  the buyer is creating a PO for an item that is used by inches but sold by the foot, the user would enter the 24 inches into the stocking qty field and the PO would automatically convert it to 2 feet in the purchasing qty field.  So the supplier deals in feet, but ManEx deals in inches.  The conversion between the two are established in the Unit of Measure & Conversion  module. 

Once the items have been accepted into inventory it is then converted over to Stock UOM and from that point forward everything within the system is using the Stock UOM.
 
ManEx DOES NOT recommend changing either of the UOM's if the part has a qty on hand.  See Article #3414 for further detail.
Package

This field defines how the components are to be packaged (ie. Reel, Tray, 6-Pak, Ream, Individually, etc.) when it is delivered.  This defaults to what is setup in the Inventory Part Class setup.  User can edit this field to fit the component package as it is purchased for your organization. This will default to the PO Screen.  The buyer has the right to override the package definition in the item master or on the PO screen.  (ie. Reel, Tray, 6-Pak, Ream, Individually, etc.)

Last Changed This captures the date,and time from the password of the individual making the changes to this screen and/or changes to the fields displayed on this screen from outside modules. Anytime an edit/save occurs this field is updated.   Note:  This field will NOT be adjusted from outside modules that change the costs, such as the Purchase Order module or the Cost Adjustment module those Last Changed dates will be displayed in the Last Changed fileds displayed next to the costs. 
By

This captures the initials from the password of the individual making the changes to this screen and/or changes to the fields displayed on this screen from outside modules.  Anytime an edit/save occurs this field is updated.   Note:  This field will NOT be adjusted from outside modules that change the costs, such as the Purchase Order module or the Cost Adjustment module

Buyer

This field is automatically filled in from the information entered in the Inventory Part Class setup module.  This field is used in the MRP lookup as a sort field to allow a buyer to find the parts they are exclusively responsible to purchase.  If a buyer leaves or is replaced, there is a global replacement of one buyer to another located in the System Utilities.exe/Change Parameters for the Part/Class

Mgmt Lock

This option is for Inventory parts that need to be protected, even from those users that have edit capabilities. Only Supervisors or users with Lock/Unlock rights within the Security/User rights can modify this checkbox.  If locked, all users can access the screen, but only supervisors or those with Lock/Unlock rights will have the capability to bypass the lock and make changes, while the Inventory part is still in lock mode. The reason we do NOT force the user to unlock the Inventory part before making any changes, is to protect it from anyone else making changes while the 'authorized" user is making their changes.

Lock Date This displays the date and time the Approved user implemented the Mgmt lock.
By

This is the users initials that implemented the Mgmt lock.

Configuration Charge

This is NOT a part of the standard cost total.It is a specific cost used with the MANEX Order Configurator module and represents any additional cost over and above the standard cost total.

Run Scrap %

This amount is added to the exact quantity used on an assembly to provide an overage to cover losses during running due to predictable machine and human losses.

Setup Scrap Qty

Setup losses may be added to the BOM requirement and Run Scrap for an item.For instance, an auto-insertion machine may use extra parts for alignment checks.

  Depressing this button will give the users the ability to scan any related documents directly into the ManEx system and attached the document directly to the item in the ICM Module.  For further detail see Article #2396.  If this button is displayed in Red there is Related documents attached. 
Inspection / Quality Spec

Checking the box will cause the item to require inspection to whatever Quality Spec. shows in the Quality Spec box. The Quality Spec appearing in the box is entered in System Setup Inventory Part Class Setup. Any Part Type in a particular Part Class can have Inspection Required turned on or off.

Certs Required/ Cert Type

Checking this box will allow selection of Cert Type. Cert Type choices are Receive, Ship or Both.  A typical Cert would be UL or CSA Certification on wire. Check the box and then depress the down arrow for the types to display.  Select the desired type:  Receive - Requires user to check the "Certificate Required" box has been Done at Receiving.  Ship - Requires user to check the "Certificate Required" box on Packing List/SHipping.  Both - Requires user to check the "Certificate Required" box at both Receiving and Packing List/Shipping.  

First Article Checking this box will alert the users that the item requires a first article check at receiving inspection
NC NR

Checking this box, means that once the part is ordered it can not be returned or the order can not be cancelled.

MRC

The Material Risk Codes listed in the pull down are entered in the System Setup Material Risk Code Setup. This is to inform the users which items are Low Risk or High Risk (can not be cancelled or returned).

EAU The quantity displayed in this box is the estimated Annual quantity.  This is calculated from information entered into the ABC Types screen. 
Last EAU Calculated The date shown in this box is the date the EAU was last calculated in the ABC Types screen.
PPM (Parts per million)

This is a data entry field and is not involved in any calculations or used anywhere within the system at this point.It is planned to be used in the future to calculate the component level of PPM and then update the assembly PPM within the routing module.

Length

Specific length allowed for part.

Width

Specific width allowed for part.

Depth Specific depth allowed for part
Weight

Specific weight allowed for part.

Material Cost  For BUY Parts:  This is the purchase price of the BUY part.  For MAKE Parts:  The sum of the STANDARD COSTS of BUY parts in the assembly.  Whether or not setup scrap is included is a system setup option.
Labor Cost For BUY Parts:  If the user wishes to include any preparation labor costs associated with a BUY part, like crimping, tinning testing. etc., those costs may be included here.  For MAKE Parts:  The user may include the labor associated with building the assembly.
Overhead Cost

For BUY Parts:  Any additional costs associated with the labor, such as heating, lighting, etc., that the user may wish to include in the cost of the inventory value.  For MAKE Parts:  Any additional costs associated with the labor, such as vacations, sick leave, meeting times, etc., that the user may wish to include in the inventory value.

Other Cost For BUY or MAKE Parts:  This is up to the user  to decide if there are any other costs that should be absorbed in the inventory value. 
User Defined For BUY or MAKE Parts:  This is a field where a user may define the field name and include any optional costs.
Standard Cost

The STANDARD COST of an item is a calculated value determined by the sum of individual costs.  These individual costs may be in any combination of the Material, Labor, Overhead, Other and User Defined costs.   Each of the individual costs should have their own account number in the Inventory Setup , and those accounts will accrue the costs when material is added to inventory.  User MUST have optional rights within the Security module to "Allow Updating Inventory Std Cost and Standard Cost Rollups".

If ManEx Accounting is neither installed nor active, then there is no value other than reference in including values in these fields.

Important Notice:  It is very important to have standard costs (as determined above) in place for any part entering inventory.  ManEx allows users to enter a standard material cost at the time of purchase, if one is not already entered.  Without accurate cost data, the inventory value could be next to useless, and major variances would show in Purchase Price, Configuration and Manufacturing Variances.  If the material cost if the assembly does not equal the computed sum of the standard costs of the components based on the system setup, a configuration variance will be accrued.

Target Price This field is currently only a data entry field and will be reflected in the Purchase Order module for "BUY" or "MAKE/BUY" parts.  This field is not editable for "MAKE" or "PHANTOM" parts.  NOTE:  To assign prices to products ("MAKE" parts), ManEx suggests using the Sales Price List Information module.  This module allows users to enter prices by product and by customer so different customers can have different prices.  This price will default into the sales order, but is still editable within the Sales Order module. 
Weighted Cost - Last 5
If the Part Source is a BUY,  the weighted cost is calculated by dividing the extended total cost from 5 purchase order by the total qty from 5 Purchase Orders.  The Purchase Orders used is with the latest version date (example if the original PO date is 1/3/06, but it was revised/edited on 12/5/06 it will use the 12/5/06 date, no matter what was edited on the PO).  (if a user accidently selected the wrong PO to edit and had depressed the edit button, they could depress the abandon changes button to avoid the PO version date from being updated).   
   
 
Last Changed This captures the date of the last change to the cost within this module and/or the outside modules such as the Purchase Order module and/or the Cost Adjustment module.  

If the Part Source is a BUY, the purchase history will list information of 10 latest POs.  The PO's will only be displayed on this list if the status is "OPEN" or "CLOSED".  If the PO status is "EDIT" or "CANCEL" it will NOT be displayed on the the list.  The system will select POs by original date.    Note that the User may sort by depressing the Date, Supplier, PO Number, Manufacturer or Price button.  For further detail see Article #3203