Material Fields

The following fields display on the Details tab of the Material Details panel:

  • Material Id: A unique number used to identify the material. This is the Code defined for the material and is what users see if the Material Tree Text Display preference is set to Code, or Code~Description. See Configure Text Display in Cityworks in the Designer Office Companion 23 Guide to set this preference for your login, or Configure General Preferences in the Designer Office Companion 23 Guide to set this preference for the domain.

IMPORTANT: Material UIDs that contain a mix of letters and numbers must use uppercase letters for the material to appear in ELM.

  • Description: This is the Description defined for the material and is what users see if the Material Tree Text Display preference is set to Description, or Code~Description. See Configure Text Display in Cityworks in the Designer Office Companion 23 Guide to set this preference for your login, or Configure General Preferences in the Designer Office Companion 23 Guide to set this preference for the domain.
  • Category: The category for the material, if applicable. This is populated in Preferences under Custom Codes > AMATCAT.
  • Model: The manufacturer's identification for the material.
  • Manufacturer: The maker of the material.
  • Detail: Enter more a detailed description of the material, if desired.

NOTE: The Detail field is not displayed on a work order.

  • Supplier: The name of the default supplier of the material.
  • Part Number: The part number of the material, if applicable.
  • Is Active: Select if this material is currently being used. Clear this check box to make the material unavailable to users, but still maintain historical data associated with it. If any material is inactivated, it appears grayed out in the list of material.
  • Units of Measure: The units used to measure the material.
  • Is Splittable: Select this to allow the material to be split into fractional amounts. If this is not selected, only whole units can be entered.
  • Audit Interval: The frequency that this material is audited.
  • Justification Required: When a requisition is created in Storeroom and materials are added to it, there is a justification field. This field is used to enter a reason for the requisition. Select this check box to make the justification field on a requisition a required field per unit.
  • Unit Cost: The cost of the material.
  • Cost Type: The cost type of the material.
  • Current: The current price of the material when it was most recently received.
  • Weighted Average: All the costs for the material are divided by the number of units on hand.
  • FIFO: First In First Out (FIFO) inventory method which uses the older unit costs first when distributing parts until the older inventory is gone. Then the newer unit costs are used for the newer inventory.
  • LIFO: Last In First Out (LIFO) inventory method which uses the most recent costs first when distributing parts until the newer inventory is gone. Then the older unit costs are used for the older inventory.

NOTE: Weighted Average, FIFO, and LIFO cost types are for use with Storeroom. If you are not using Storeroom, the Current value must be manually entered every time you receive the material.