Inventory
ShopWorX ERP

Benefits

Make Better Decisions

Accurate, real-time inventory information helps you fine-tune your production and purchasing decisions.

Improve Inventory Accuracy

Physical and cycle count programs help ensure accurate perpetual inventory values.

Save Time

Tight integration with the other ShopWorX modules eliminates the need for double entries.

Maintain Full Control

A full inventory transaction history gives you an audit trail of all inventory movement.

Improve Visibility

Keep inventory by part number, warehouse, bin, batch, lot, and/or serial number with full traceability.

 

Overview

The Inventory module enhances tracking capabilities, and gives you the information you need to improve efficiencies in production cycles, material usage, and purchasing activities.

Features

Multiple Warehousing
This module allows you to track the same inventory item in multiple physical or logical warehouse locations. You can track the quantity on-hand, on-order, committed, available, and pending in each location. On hand balances can be tracked in multiple bin locations within a warehouse. The system provides the ability to transfer stock from and to any warehouse or bin location within a warehouse.

Lot Tracking
Track inventory on-hand balances and all issues and receipts for an item by lot, batch and/or serial number. Each lot/batch/serial number will provide the quantity on-hand, source of material, and the actual detail costs associated with it.

Cradle-to-grave tracing of each lot/batch/serial number provides the ability to identify the source of material, where the material is in-house, and what shipments, if any, have been made.

The flexible lot tracing inquiries allow tracing material from source to where used or where used back to source.

Inventory Valuation
Flexible costing options allows you to select standard, average, actual, LIFO, or FIFO valuation methods.

ABC Analysis
The system will rank inventory items based on inventory movement and assign an ABC classification to each item. The ABC classification can be used to determine cycle count frequency and safety stock requirements for Min/Max calculations.

Cycle Counting
Provides to the counter a worksheet based on how frequently an item should be counted and when it was last counted. You can set the frequency for each item or the system can set the frequency based on ABC classification. This feature allows you to generate count sheets, enter actual counts, print variance reports and keep both quantity and dollar statistics by classification.

Physical Inventory
The Physical Inventory module will freeze the inventory for a warehouse or for all warehouses. Print inventory tags, a Tag Edit Report to identify missing or duplicate tags, an Uncounted Parts Report to identify parts frozen with an on hand balance that have not been counted, and quantity and dollar variance reports.

The frozen inventory feature allows the system to take a snapshot of inventory balances so that, after the physical inventory is counted, you can continue to ship, receive, and process transactions while you finish entering and validating the inventory counts. The frozen on-hand balances are compared to the quantities counted, and the difference is used to update the current quantity on-hand. Variances are calculated and can be posted directly to the general ledger.

Transaction History
You have the detail of every transaction available online. Who made the transaction, what was affected, and the value of the transaction are all available. The information is kept on-line for as long as you find it worthwhile. It can be used to help spot trends and resolve discrepancies.

Inventory Integration

  • Panorama
  • Quoting
  • Customer Orders
  • Shipping
  • Sales Analysis
  • Bills of Material
  • Process Sheets
  • Configurator
  • Enterprise Resource Planning
  • Rough Cut Planning
  • Master Scheduling
  • Shop Orders
  • Purchasing
  • Customer Billing
  • Accounts Payable
  • General Ledger
  • Costing

 

     


Click here for a printer-friendly version of this data sheet.