Item usage template reference

Overview

The item usage import template is used to update stock on hand and usage history for existing inventory items in Maximo Inventory Optimization Essentials. The file must contain only item usage data and the latest stock on hand value-any other information is ignored. The import process relies on a business key to match usage data with existing items in the system.

You can import multiple months of usage simultaneously. If usage for a specific period is re-imported, the system overwrites existing values with the new ones. Items not included in the import file have their usage values for the period set to 0.

General rules

• The import file must include only usage data and the latest stock on hand value.
• Business key fields (Organization, Site, Store, Condition Code, Planning Area, Item Number) identify the item uniquely.
• Fields not used in the client’s ERP/EAM system can be left blank.
• Enter stock on hand as an integer value to achieve the best results.
• All usage data columns must follow the format: YYYY-MM usage (for example, 2024-12 usage).
• Usage data can only be for completed months. For example, if today is May 31, 2025, the latest valid column is 2025-04 usage.
• Re-importing data for the same month overwrites previous values.
• Items not present in the import file are assumed to have zero usage for the import period.
• Invalid field values are ignored. If applicable, a default is used.
• Rows with critical errors are skipped, the rest of the file is processed.

Item usage field definitions