Inventory Control

INVENTORY CONTROL maintains part information and inventory balances, providing you more control over your purchased goods and materials.

Parts may be stored in single or multiple locations within one storeroom or multiple storerooms.

MODULE FEATURES

Parts Master File Maintenance
  • Variable part number length (up to 25 characters)
  • Browse capability to find parts by number or by search name
  • Substitute part number, preferred vendor
  • ECN, pending ECN, drawing revision fields, drawing size
  • Dates for: created, effectivity, original release, active, obsolete, last update
  • Manufacturer/vendor part cross reference (maintained in Purchase Order)
  • Customer part cross reference (maintained in Sales Order)
  • Classification by commodity, product line and part class
  • UPC and ITF Codes
  • Lead times: vendor, receiving, kitting, manufacturing, shipping, planning, cumulative
  • Order point, order quantity, and quantity for sales order processing
  • Planner and buyer identification
  • Flags: MRP, master scheduling, lot control, serial number
  • Minimum sales quantity, maximum order quantity
  • Stocking, buying and selling unit of measure conversion
  • Variable decimal quantities (set by Part Identification)
  • Part yield, shelf life, default storeroom
  • Multiple user-defined fields and notes
  • Attachments
    • Documents
    • Web addresses
Global Part Inquiry
  • Drill down detail by sales order, purchase order, kits, jobs, stock, sales and purchase history, serial numbers, lots, routings
  • Supply and demand summarized availability
Kit Issues to WIP
  • Complete with one transaction
  • Partial kit/partial return options
  • Exceptions handling for shortages
  • Automated lot and multi-location control
  • Simplified kit returns
Kit Shortage Tracking
  • By part, job, buyer
  • Automated warning of shortages for any received part
Issue and Returns Entry
  • Automatic inventory posting
  • Kit shortage updating
  • Support for expense issue ABC count days
  • Snapshot of MTD and YTD quantities: beginning, receipts, issues, adjustments for each part/store-room
  • Last activity dates: receipt, issue, on hand, physical, count sheet
Reorder Point Reporting
  • By part and storeroom location
Backflush Issue
  • No job or work order required
  • Automatic inventory relief from WIP or main stores
  • Variance calculations (option to override accounting)
  • Issue configuration options
  • Phantom BOM processing

Multiple Locations

  • Multiple storerooms (up to 1,000)
  • Automatic general ledger accounting by storeroom
  • Approved storeroom for purchase
  • MRP and MPS netting control by storeroom
  • Stock status control
  • Optional multi-location control
  • Safety stock quantity by storeroom
  • Cycle count days overrides
Multiple Locations within a Storeroom
  • Location field up to 16 alphanumeric characters
  • Unlimited locations within a storeroom
  • Password control by storeroom
  • Stock status information available by storeroom, part, location
  • Part quantities for current, on hand, book, physical
  • Automatic date capture of last activity, receipt, issue, physical inventory, cycle count work sheet, last update
  • Multiple location transfer
  • Create new locations if not previously established
Stores Transfer and Adjustments
  • Transfer of an individual part or a complete kit
  • Ability to adjust on-hand stock quantity (automatic update to appropriate G/L account)
Value Distribution Reporting
  • ABC code calculation based on user criteria
  • Unit cost
  • Lead time
  • Percent usage
  • Forecasted or actual YTD usage
  • Option to update ABC code on parts master file
Daily/Monthly Transaction Reporting
General Ledger Transaction Creation and Tracking
  • By department, account, job, batch number
Card image cap

Part attributes are defined in Expandable using the Parts Master Editor

Real-time Integration
  • Multiple Location
  • Lot Tracking
  • Tag Inventory
  • Purchasing
  • Product Data Control
  • Sales Order
  • Sales and Booking Analysis
  • General Ledger
  • Multiple Company
  • Foreign Currency
  • Job Scheduling/Costing
  • Shop Routing
  • Materials Management (MRP)
  • Master Scheduling
  • Configuration Control
  • Consignment Inventory
  • Engineering Change
© 2022 Expandable Software, Inc. | All Rights Reserved