Stock Items

Stock Items are linked Catalog Items found at a one particular Warehouse. The same Catalog Item might exist as multiple Stock Items in the same or at the different Warehouses.

Example 1. Existence of stock items in the same warehouse

  • One Stock Item for Equipment in new condition

  • Another Stock Item for used condition

  • A third Stock Item for refurbished condition

The same Catalog Item can be located at the same Warehouse.

Key Features

With FieldFX EAM Stock Items, you can:

  • Make Stock Items Serialized or not

  • Set a reorder point

  • Make the source replenishment from vendor by a Purchase Order or another Warehouse using a Transfer

  • Source in one Unit of Measure (such as Box) and stock in another (such as Each)

  • Track inventory valuation by Weighted Average Cost or LIFO (Last In First Out)

  • Make the demand for Stock Items on Work Orders that are either in one of these statuses:

    • Ready to Schedule

    • Scheduled

    • In Progress status

      Demand impacts Planned Stock.

  • Store Stock Items in bin locations

    A Stock Item may have more than one location.

How Stock Items Work

Flowchart of how Planned Stock is determined

List Views

FX EAM provides five default Stock Item list views to assist a Warehouse manager with managing inventory.

Auto Reorder
Qualified Items		 Inter-Stores
Sourced Items		 Items to Reorder Items with
Open Orders		 Serialized
Stock Items

All Active Stock Items are displayed where

Reorder Quantity

is greater than 0

Sourcing Type

Purchase Order

Auto Order

Selected

These are items set for automatic reordering in the Batch Purchase Order process.

All Stock Items are displayed where the Sourcing Type is set to Transfer Order.

  • These items are not ordered directly from a vendor, but instead shipped from another Warehouse, such as a central stocking Warehouse.

All Active Stock Items are displayed where the Reorder Quantity is greater than 0.

  • These are items that should be kept on hand at the Warehouse.

All Stock Items are displayed where the On Order Qty is greater than 0.

All stock items are displayed where Serialized is set to Yes.

For more information, see Serialized Inventory.

List Actions

From the Stock Items tab’s list view, complete actions by selecting the button or dropdown in the top right of the screen:

Generate Purchase Order

  • After selecting items, the action generates a Purchase Requisition to start the Purchase Order process.

  • FX EAM generates a separate Purchase Requisition for each Warehouse and Vendor combination.

Generate Transfer Order

  • After selecting items, the action generates a Transfer Requests to start the Transfer Order process.

  • FX EAM generates a separate Transfer Request for each Requesting Warehouse and Fulfilling Warehouse combination.

Step-by-Step Guide

The only required entry is Stock ID.

  1. In FieldFX Back Office, select EAM and go to Stock Items.

  2. Enter the following in Information for Stock ID and Catalog Item:

    Field Value

    Stock ID

    Unique identifier for this particular Stock Item.

    Description

    User defined short description.

    Nameplate Data

    User defined long description (up to 255 characters).

    Status

    • Draft until ready to use

    • Active when stocking

    • Inactive when no longer used

    Catalog Item

    The Catalog Item stocked at this warehouse, search for existing records or create a new record.

  3. Enter the following in Serialized Component Setup for Serialized and Condition:

    Serialized inventory are items that are tracked by unique identifying numbers.

    Common examples include vehicles and computers.
    If Serialized is set to Yes, also enter Serialized Control Point and Equipment Record Type
    Field Value

    Serialized

    Yes if tracking serial numbers, otherwise No

    Condition

    New, Used, or Refurbished

    Serialized Control Point

    If Serialized is Yes, assign a serial number either at time of Receipt or at time of Issue

    Equipment Record Type

    If Serialized is Yes, the record type for the serialized inventory record.

    For more information, see How to Work with Serialized Inventory

  4. Enter the following in Stocking Information:

    Field Value

    On Hand Qty

    Current quantity available at the warehouse in all inventory locations.

    Primary Inventory Location

    Primary Bin location to find the item in a Row → Section → Level → Bin hierarchy.

    After assigning Primary Inventory Location, additional inventory locations can also be added.

    Warehouse

    The Warehouse for this Stock Item, search for an existing record or create a new record.

    Stock UOM

    Unit of Measure to use for stocking; the smallest unit of measure that can be issued to a Work Order.

    Reorder Point

    Minimum on hand quantity at which a replenishment order should be placed.

    Cycle Count Group

    User defined group for creating inventory cycle counts.

    Criticality Code

    Inventory stocking priority: -None-, High, Medium, or Low.

  5. Enter the following in Ordering Information:

    Field Value

    For Sourcing Type

    Purchase Order

    Enter specific information for:

    • Preferred Vendor

    • Vendor Item #

    • Purchase Price

    • Purchase Pack Qty

    • Purchase UOM

    Transfer

    Enter Source Warehouse and Source Stock Item

    To enable Batch Purchase Ordering,
    select Auto Order.
    Field Value

    Sourcing Type

    Purchase Order to replenish from a vendor or Transfer to replenish from another Warehouse

    Preferred Vendor

    For Purchase Order Sourcing Type, the Vendor account normally used for ordering this item.

    Vendor Item #

    For Purchase Order Sourcing Type, the Vendor’s item number to used for the purchase order.

    Purchase Price

    Price paid to the vendor for 1 quantity of the Purchase UOM.

    Last Price Update

    Read only field displays the last time the purchase price changed.

    Source Warehouse

    For Transfer Sourcing Type, the Warehouse used for replenishment requests.

    Source Stock Item

    For Transfer Sourcing Type, the Stock Item number for this Catalog Item at the replenishing Warehouse.

    Auto Order

    Whether to enable this item for Batch Purchase Orders.

    Purchase Pack Qty

    How many of the Stocking quantity is ordered in 1 purchase quantity.

    Purchase UOM

    Unit of Measure used for purchase orders.

    On Order Qty

    Read only field that displays the current number of items on open Purchase Orders or Transfers (not yet received).

  6. Enter the following in Cost & Usage Valuation Method:

    For Standard Valuation Method, also enter Standard Cost.
    Field Read Only Value

    Last Issue Date

    Yes

    Last time the item was issued to a work order.

    Last Order Date

    Yes

    Last time the item was ordered for replenishment.

    Last Receipt Date

    Yes

    Last time the item was received.

    Last Gain Date

    Yes

    Last time on hand quantity was adjusted by an increase.

    Last Shrink Date

    Yes

    Last time on hand quantity was adjusted by a decrease.

    Last Cycle Count Date

    Yes

    Last time the item appeared on a cycle count.

    Valuation Method

    Type of inventory valuation to use:

    • LIFO

    • Weighted Average

    • Standard

    Standard Cost

    For Standard valuation, the user-defined value of each item.

    Last In Cost

    Yes

    For LIFO valuation, the value of each item on the last receipt.

    Weighted Avg Cost

    Yes

    For weighted average valuation, the current value of each item based on receipt transactions.

    Unit Value

    Yes

    Value to use for inventory gain and shrink transactions.

Recommended Reading