Diamond Systems, LLC
  © 2008

 
Diamond Systems
MTS Perpetual Inventory
Material Tracking Suite

quickly know inventory quantity, location, and status

The MTS Perpetual Inventory Module is the core module for Material Tracking Suite, providing Inventory information and management. The Inventory Module supports real-time reporting, including Days Inventory on Hand, Inventory Turns, and provides MRP with accurate inventory. MTS Inventory Module delivers advanced actual cost data. The Module provides cycle counting tools and an alternative to full physical inventory. Perpetual Inventory may be integrated with ERP or accounting systems for automated update.

Perpetual Inventory
Module Functions

  • Display inventory on hand and location
  • Count and reconcile system total against physical count, filtered by item, location, both or neither
  • Materials Availability Utilities
  • Definitions
  • Accounts
automate accounting
Application Preferences and Settings
  • Inventory Synchronization Records include inventory definition fields and non-accounting based data records. Inventory Synchronization Records may be used with or without an existing Accounting System, enabling the user to include bill-of-materials (BOM) definitions, including the following:
    • Approved substitutions
    • Unit of measure (UOM) conversions
    • Unique user definable properties
    • Item Master synchronizes with ERP or stand-alone accounting system
  • Expanded multi-level BOM with explosion and cost roll-up
    • BOM to available inventory validation utility
    • Per line consumption of BOM for WIP tracking
    • Per lot actual cost tracking with historical material consumption
  • Multiple lot types with actual cost tracking
    • Bulk
    • Controlled
    • Serialized
  • Multiple cost center support
    • Labor/production rate per hour and item
    • Overhead rate per hour and item
  • Inventory Synchronization Record Definitions include the following:
    • Price
    • Cost
    • Non-Accounting Specific Data includes the following:
      • Weight
      • Low limit and Excess limit
      • Re-order points and quantity
  • Locations
  • Users
  • System parameter section for defining all label formats
Accounts
  • Fully customizable segregation of inventory categories
  • Vendor alternative specific product numbers and data
Application Utilities
  • BOM Material availability check utility
  • Item and location spot check utility
  • Group pick utility
Features
  • Allows multiple lots per item with individual lot cost association
  • Real-time Reporting - Scrap, Picks, Quality/Grade, Locations (Fixed and Virtual)
  • Accurate on-hand inventory for MRP calculation
Searching and Viewing Inventory

The built-in search engine makes viewing inventory characteristic quick and easy, with a broad range of search criteria available.  In addition, all columns are sortable and arrangeable, enabling custom arrangement of data to the user’s preference.

Supports MS Excel and PDF

Perpetual Inventory has built-in support for export to Excel and PDF, making custom reporting quick and easy.  Any view of inventory may be exported.

Built-in Support for Barcode Labeling and Scanning

Easy to set-up and use built-in barcode labeling and scanning makes materials identification fast and simple.

Reduce manual data entry increase operating efficiency

 

 


 
 
Contact Us Home Home