ICMM - Inventory Master Maintenance

New features added, version 7.5.2, 7.5.3, 8.1, 8.5.1

See Also Programs

Program ICMM, Inventory Master Maintenance, is used to add new item numbers to the system and to delete item numbers from it. You can also maintain certain pieces of information about each item. Item numbers must be entered into the system with this program before the item can be used by the system.

You can use other programs to maintain inventory data in the system, including sales, planning, and cost data. This information is optional, but it is necessary for integration with other modules, such as the Sales Order (SO) Module. These other programs are program ICSM, Inventory Sales Data Maintenance, program ICPM, Inventory Planning Data Maintenance, program ICCM, Inventory Cost Data Maintenance, and program ICEC, Engineering Change Level Maintenance.

Comments for items can be entered in this program with the comment types POR - purchase orders and receiving, RE - receiving, and PO - purchase orders only. When the item is used on a purchase order or a receiver, the comments will be displayed, depending upon the comment type.

 

See Also

Alternate Units of Measure and Preferred SKUs

Restricting Customer/Item Purchases

Sales Restrictions by Low Stock Allocation

Shipping Temperature Comments

Deleting Items

Item Comments

Control Items

Assigning Control Numbers to Controlled Items

Stocking, Picking, and Backflushing Controlled Items

Changing Item Control Types

Changing the Stock Unit of Measure for Items

Engineering Templates and Inventory Items

Entering Inventory Items

Assigning Engineering Templates to Items

Copying Item Cost and Price Information Between Plants

Converting Model Items to Inventory Items

ICMM Action Buttons

 

Deleting Items

When items are deleted from this program, you have the option of deleting the item and all of its history or keeping the item history.

The system does not allow the addition of items that already exist. Similarly, it does not allow you to delete items that are being used elsewhere in the system, for example, in bills of material, routings, sales orders, scheduled receipts, material shortages, customer contracts, WIP material, and physical inventory cycle counts. An error message is displayed if either of these actions is attempted.

Before deleting an item, the program checks

Item master values:

qty_on_hand, qty_alloc_sales, qty_alloc_mfg, qty_on_order, qty_short, qty_in_receiving, qty_backordered, qty_in_inspection, qty_reserved, qty_in_shipping, qty_in_mrb, qty_in_transit, qty_planned

Bill of material:

Exists as a parent or component on any bill

Routing header:

A routing exists

Physical counts:

In any batch with status S

Material shortages:

A shortage exists

Sales orders:

Exists on any sales order line with any status (quotes, canceled, templates, shipped, invoice, won, lost, abandoned, open, etc).

Exists as a component of a kit or model on any sales order line with any status.

Work orders:

Exists as a parent or component on any work order with any status.

Contracts:

Exists on any customer contract.

Item plant quantity values:

qty_xfer_ord_in, qty_in_trans_in, qty_xfer_ord_out, qty_in_trans_out, qty_on_hand, qty_on_order, qty_alloc_sales

Modular bills:

Exists as a parent or component on any modular bill

 

Item Comments

Comments are accessed with the [Comments] image\ebx_1202995823.gif button.

Item comments differ somewhat from the standard comment functionality in NDS. When customer comments are entered in this program, you can define a target comment type to be used when the comment is copied to the appropriate programs.

Comments for items can be set up so that they are always displayed when a sales order line, a purchase order line, or a receiver line is entered for the item.

On the comments page, there is a flag with three settings: Silent (Normal), Show Indicator, and User must read.

 

Control Items

Controlled items can be optional control items, lot control items, or serial control items. Kit items cannot be controlled items.

 

Assigning Control Numbers to Controlled Items

Lot and Serial control numbers are defined in program ITCM, Item Control Number Maintenance, with specific details about the lot. They can also be automatically generated according to the control number generation rule entered for the item in program ICEM, Item/Plant Maintenance.

Control numbers for controlled items are assigned when goods are received. Once control numbers are assigned, they must be supplied whenever the associated inventory item is moved: transferred into stock, sold to a customer, transferred to another plant, or issued to a work order.

 

Stocking, Picking, and Backflushing Controlled Items

Controlled items that are not defined as optional control cannot be stocked in non-controlled locations. Non-control items can be stocked in both non-controlled and controlled locations.

Controlled items cannot be backflushed from non-controlled locations. Do not define the backflush location for a controlled item as a non-controlled location.

Controlled items must have a control number to be picked for sales order and work orders, regardless of the optional control flag in program ICEM, Item/Plant Maintenance. Controlled items cannot be shipped or staged from non-controlled locations.

 

Changing Item Control Types

You can change existing items from lot to serial control or serial to lot control. Controlled items can be changed to non-controlled items only if the following conditions are met:

1. The controlled item is defined as optional control in program ICEM, Item/Plant Maintenance.

2. All current inventory for the item exists in non-controlled locations.

3. The item is not a component of any open or closed work orders or production schedules.

4. The item is not a component of any open transfer orders.

If the controlled item is changed to a non-controlled item, any existing control numbers for the item will be moved to item control history. If any zero on hand quantities exist for control numbers for the item, they will be deleted.

You can change non-controlled items to controlled items only when all current inventory exists in non-controlled locations. If an item is changed from non-controlled to controlled, any zero on hand quantity locations for the non-controlled item will be deleted.

 

Changing the Stock Unit of Measure for Items

When the stock unit of measure is changed for an item, the following records are also updated with the new stock unit of measure.

 

Engineering Templates and Inventory Items

Engineering templates assigned to items are pulled into customer conformance specifications entered in program CSCM, Customer Conformance Maintenance. See the Conformance Specifications Module for more information.

Engineering templates can be added to items using the [Templates] button.

Some variables that were assigned to the template in program ESTM, Engineering Template Maintenance, can be defined as verbose.

The [Specifications] button is used to view and maintain the variables that have been assigned to the item.

 

Entering Inventory Items

  1. In the Item Number and Desc fields, enter the item number and description.

  1. In the Product Group field, if the item is assigned to be a product group, enter the product group.

  1. In the Unit of Measure field, enter the default unit of measure for the item.

  2. In the Current ECL field, enter the engineering change level for the item, if a bill of material exists for the item.

  3. In the Current Rtg Rev field, enter the current routing revision level for the item, if a routing was entered for the item in program RTMM, Routing Master Maintenance.

  4. Set the Control Type pop-list to the desired setting. The choices are None, Lot, and Serial.

  1. The Item Category pop-list indicates the type of item displayed.

  1. Set the Maintain On Hand flag to on to indicate that this item can be maintained as on hand inventory.

  2. Set the Fast Receipt flag to the desired setting. This flag determines whether fast receipts can be entered for this item in program REFS, Miscellaneous Receipts.

  1. Set the Backflush flag to on if this item can be backflushed.

  1. Set the Drop Ship Only flag to on if ALL sales order lines entered for the item will be shipped from the vendor as a drop ship purchase order. You must have the Maintain On-Hand flag set to off if this flag is set to on.

  1. Set the Phantom flag to on if the item will be identified as a phantom in bills of material.

  1. Set the Hazardous Matl flag to the desired setting. The setting of this flag is used when shipping orders with the Connectship / WorldEase Interface. Set this flag to on if the item is considered a hazardous material for shipping purposes.

  1. Set the Inspection Req'd flag to on if you wish the Inspect flag to default to on for this item in program POEM, P.O. Entry/Maintenance.

  1. Set the Discontinued flag to on if the item has been discontinued.

  1. Set the Common Item flag to the desired setting. This flag is only used with the Fulfillment Management feature in the fulfillment house database master instance.

  1. Set the Inactive flag to on if the item is inactive.

  1. Set the Expiration Date Req'd flag to the desired setting. Set this flag to on if when control numbers for this item are created, an expiration date must be entered.

  2. Set the Allow Est Freight flag to the desired setting. Set this flag to on to allow custom calculation of estimated freight if this item is on an order.

  3. Set the ROHS Flag pop-list to the desired setting. The setting of the pop-list indicated whether the item is in compliance with European Union rules.

  1. In the Product Code field, if the item is assigned to a product code, enter the product code.

  2. In the Product Line field, if the item is assigned to a product line, enter the product line.

  3. In the Acct Class field, if the item is to be assigned to an account class, enter the account class.

  1. In the Commodity/HS Tariff field, enter the US commodity code or world class organizations harmonized code for the item.

  1. In the WCO HS Code field, enter the international commodity code or world class organizations harmonized code for this item, if desired.

When the VALIDATE_WCO_HS_CODE parameter in program MURM, Initialization Parameter Maintenance, is set to YES, the values will be validated.

When the parameter is set to NO, the values will not be validated.

  1. If this item will be used in Item Specific allocation types, in the Alloc Qty field, enter the quantity that the customers assigned to Item Specific allocation types will be able to order when this item reaches its low stock allocation level.

  1. If you are using allocation types to restrict sales, enter the low allocation stock level in the Trig Lvl field, if appropriate.

  1. In the ABC Class field, enter the ABC class for the item.

  1. In the Count Cycle field, enter the number of days between cycle counts for this item.

  1. In the Country of Origin field, enter the country of origin for the item, if desired.

  2. If the item is to be used in Point of Sale transactions, enter the description for the item for point of sale.

  1. In the Drawing Ref field, enter the drawing reference, if desired.

  1. In the CAD Code field, enter the CAD code, if desired.

  1. In the Item Type field, enter the item type for the item.

  1. In the Item Code field, enter the item type code, if desired.

  1. In the Ship Temp field, if the item has a specific temperature that cannot be exceeded during shipping, enter the temperature in degrees Fahrenheit.

  1. In the Project Class field, if this item will be used on projects in the project management module, enter the project class for the item. When a sales order with this item is converted to a project with program PMSM, Convert Order/Quote to Project, this information is copied to the project line code.

  1. In the Project Group Code field, if this item will be used on projects in the project management module, enter the project group code for the item. When a sales order with this item is converted to a project with program PMSM, Convert Order/Quote to Project, this information is copied to the project line code.

  2. In the Cust field, enter the fulfillment customer number for which this item is a common item. If the item is a common item for all fulfillment customers, leave this field blank. This field is only used with the Fulfillment Management feature in the fulfillment house database master instance.

  1. In the BO Notify Pct field, enter the percentage of the item's safety stock for which backorder notifications will be sent.

  1. In the BO Notify Days field, enter the number of days for which a sales order will be considered for backorder notification if one of the sales order lines is for this item.

  1. In the Blank Weight field, if you are using Customer/Item Surcharges, enter the weight in pounds for this item's surcharge calculation in this field. A weight must be entered for surcharges to be calculated.

  2. Set the Add Surcharge flag to the desired setting.

  1. In the Surcharge Per Lb field, enter the default surcharge amount per pound for this item.

  1. In the GTIN field, enter the GTIN code for this item. The code must match the GTIN Format selected in program ILPM, Plant Code Maintenance. Depending on the setting of the GTIN Generation pop-list in program ILPM, Plant Code Maintenance, this value may have already been generated.

  1. In the TH, WD, and LN fields, enter the dimensions of the item.

  1. In the Item Code 1 through Item Code 9 fields, enter the values for the nine inventory codes, if desired.

  1. You can assign a different item number to different versions of the same item. To do this, press the [Multi-lengths] button.

  1. You can enter additional descriptions for the item with the [Description] button. Additional descriptions are only used for custom reporting.

  2. You can enter alternate units of measure for the item for purchasing, sales, and pricing units of measure. To do this, use the [Alternate U/M's] button.

  1. Press [Commit].

 

Assigning Engineering Templates to Items

1. Query the item to which you wish to add engineering templates.

2. Press the [Templates] button.

3. Press the [Templates Selector] button.

4. Find the template that you wish to add to the item.

5. Set the Action flag to Add.

6. Press [Commit].

7. To remove a template, set the Action flag to Delete and press [Commit].

8. Press [Return]

9. The template variables will be displayed.

10. You can enter values for the template variables using the [Specifications] button, if appropriate.

11. Press [Commit].

 

Copying Item Cost and Price Information Between Plants

1. You can copy cost and price information entered in your current plant to other existing plants.

2. Query the item in this program.

3. Press the [Push $] button.

4. The Price / Cost Push screen will be displayed. All plants but the one that you are currently logged into will be displayed on this screen.

5. Set the Costs flag to on for all plants to which you want to push the cost entered in this plant.

6. Set the Price flag to on for all plants to which you want to push the sales price entered in this plant.

7. Set the Push Price Matrix flag to the desired setting.

8. When you have selected all desired plants, press the [Push Prices / Costs Now] button.

9. The costs and prices will be copied to the selected plants, overwriting any information that had been entered previously in those plants.

10. If the Push Price Matrix flag was set to on, the price matrix was also copied to the plants for which the Prices flag was set to on.

 

Converting Model Items to Inventory Items

Model items can be converted to inventory items here. In order to be converted, the item cannot be the parent or child of any other model item in program MOTM, Modular Bill Maintenance.

1. Query the item that you are converting to a model item.

2. Change the item category pop-list from Model Item to Inventory Item.

3. Press [Commit].

 

ICMM Action Buttons

Alternate U/M's

Use this button to enter unit of measure codes for this item for the purchasing, pricing, and sales units of measure. The conversion for this unit of measure should be the multiplier required to make this unit of measure equal to the item's stock unit of measure. For example, if the stocking unit of measure is inches, and this unit of measure is feet, the conversion factor would be 12. If the stocking unit of measure was feet and this unit of measure was inches, the conversion factor would be 0.08333.

These conversions are used in program ICSM, Inventory Sales Data Maintenance, and program POEM, Purchase Order Entry/Maintenance. For each sales unit of measure there must be an individual record, as the sales unit of measure cannot be changed in the record.

Description

Use this button to enter any additional description for the item. You can enter up to sixty characters per line. The description entered here can be printed on custom reports.

Generate GTIN

Press this button to generate the GTIN number for this item, according to the parameters in program ILPM, Plant Code Maintenance. If the GTIN Generation pop-list in program ILPM, Plant Code Maintenance, is set to Manual, this button will not generate the GTIN number for the item.

Deselect All image\ebx_-1457451925.gif

Over the Costs flags on the Price / Cost Push screen, press this button to set the Costs flag to off for all displayed plants.

Over the Prices flags on the Price / Cost Push screen, press this button to set the Prices flag to off for all displayed plants.

Multi-Lengths

Use this button to assign a different item number to different versions of the same item. An example would be a plank of wood. You can have a plank of wood that is two inches wide, and two inches thick, but has varying lengths. You can enter the different lengths in this record. You have the choice of either assigning the item number for the different lengths yourself or leaving the field blank and having the system create the item number according to the auto-numbering rule in program SPAN, Auto Number Control.

These records are still linked to the main item number. If you change something on the main item number, it will change in all of those records linked to it. If you change something in a linked item number, nothing will happen to the main item number or any of the other links. All of the links can be maintained separately.

Push $

Press this button to copy prices and costs from the current plant to other plants. The Price / Cost Push screen will be displayed to allow you to select the desired plants to which you wish to copy prices and costs.

This button is disabled if the PLANT_PROTECT parameter is set to Y in program MURM, Initialization Parameter Maintenance.

Push Prices / Costs Now

Press this button to copy prices and costs from the current plant to the selected plants. The costs and prices being copied will overwrite any existing records for this item in the selected plants.

Select All image\ebx_1308180707.gif

Over the Costs flags on the Price / Cost Push screen, press this button to set the Costs flag to on for all displayed plants.

Over the Prices flags on the Price / Cost Push screen, press this button to set the Prices flag to on for all displayed plants.

Specifications

Press this button to view the engineering variables and values assigned to your item from the templates assigned with the [Templates] button.

Templates

Press this button to view or maintain templates assigned to the item.

Template Selector

Press this button to select templates to add or remove from the item.

Update Component ECLs in Bills

If you have changed the current engineering change level (ECL), use this button to update the engineering change levels for the item in all of the bills of material in which the item is a component. The engineering change level (ECL) is the revision level indicating the number of times the bill of material has been modified