SIMMS Inventory Software: Complete Guide & Key Features

Getting Started with SIMMS Inventory Software: Setup & Best Practices

Overview

SIMMS Inventory Software is a configurable inventory-management system designed for small-to-medium businesses that need serial/lot tracking, purchasing, sales, and warehouse management. This guide walks through initial setup, configuration best practices, and workflows to get you inventory-accurate quickly.

1. Pre‑setup checklist (what to prepare)

• Business goals: List top 3 inventory goals (reduce stockouts, improve FIFO compliance, shorten cycle counts).
• Inventory master data: SKU list with descriptions, units, dimensions, weight, cost, preferred vendor.
• Location map: Warehouse layout and bin locations, with naming convention.
• Opening balances: Current on‑hand quantities by SKU and location.
• User roles: Who will be Admin, Warehouse Manager, Purchasing, Sales, and Audit.
• Hardware: Barcode scanners, label printers, mobile devices, and any integrations (ERP, accounting).

2. Installation & system setup

1. Choose deployment: Decide between on‑premises or hosted/cloud (SIMMS offers both).
2. Install prerequisites: Ensure supported Windows/SQL versions (or cloud provisioning).
3. Database setup: Create and secure the SIMMS database; configure backups and retention.
4. Install application and services: Run installer, apply licenses, configure IIS/ports as needed.
5. Apply security: Enforce strong passwords, TLS for web access, and IP restrictions for admin consoles.

3. Initial configuration (high‑impact settings)

• Company profile: Add business name, address, tax settings, fiscal year.
• Units of measure & conversions: Define base units and alternate units (e.g., each, case).
• Locations & bins: Create warehouse locations, zones, and bin structure matching your layout.
• Inventory costing method: Select FIFO, LIFO, or Average Cost — default to FIFO unless accounting dictates otherwise.
• Serial & lot control: Enable where required and set expiration date handling for perishables.
• Document numbering: Configure purchase order, sales order, and receipt numbering to avoid collisions.
• User accounts & roles: Create users, assign granular permissions (restrict delete/price changes).
• Integration endpoints: Configure API/EDI connections to ERP/accounting and e‑commerce if used.

4. Data import and validation

1. Map source fields: Align CSV/Excel columns to SIMMS fields (SKU, desc, UPC, cost, qty, location).
2. Import small batches: Test with 50–100 SKUs first, verify results.
3. Run reconciliation: Compare imported quantities to physical counts and adjust variances.
4. Audit trail: Ensure all imports create traceable entries and user attribution.

5. Receiving, putaway & bin strategy

• Receiving workflow: Use purchase receipts to capture purchase lot/serial numbers and form expected vs. received counts.
• Putaway rules: Implement rule-based putaway (primary bin, overflow bin, zone priority).
• Bin sizing & ABC: Store fast movers in accessible bins; use ABC analysis to reduce travel time.
• Labeling: Print barcode labels for new SKUs and bins; include SKU, lot, expiry, and unit info.

6. Picking, packing & shipping best practices

• Pick methods: Configure wave, batch, or single‑order picking based on order volume.
• Pick lists & scanning: Require barcode scan at pick/pack/ship to reduce errors.
• Hold and QA: Use quality control holds for inspected inbound lots before making them available.
• Shipping integration: Automate carrier rate checks and update shipment status back to SIMMS.

7. Cycle counts & physical inventory

• Cycle count frequency: Count high‑value/fast movers more frequently (daily/weekly); slow movers less often (monthly/quarterly).
• Count methods: Use blind counts and reconcile via variance reports.
• Adjustments: Make documented adjustments with reason codes and manager sign‑off.
• Reporting: Monitor count accuracy trends and root causes.

8. Reporting & KPIs to track

• On‑hand accuracy (%) — compare system vs. physical counts.
• Stockouts per month — frequency and root cause.
• Days of inventory (DOI) — by SKU and category.
• Turnover rate — sales / average inventory.
• Aging & expiry — lots near expiry.
• Cycle count variance — adjustments over time.

9. Security, backups & maintenance

• Backups: Schedule nightly full backups and transaction log backups more frequently.
• Access control: Enforce least privilege, periodic access reviews, and two‑factor for admins.
• Patching: Apply OS, database, and SIMMS updates in a staging environment before production.
• Performance monitoring: Monitor SQL performance, index fragmentation, and application logs.

10. Training & change management

• Role‑based training: Create quick start guides for warehouse, purchasing, and admin users.
• Sandbox environment: Provide a test instance for staff to practice receiving and shipping.
• Go‑live plan: Staged rollouts—start with one warehouse or product line, validate, then expand.
• Support escalation: Define internal and vendor support contacts and SLAs.

11. Common pitfalls & how to avoid them

• Poor SKU hygiene: Use clear naming conventions and avoid duplicates — enforce during import.
• Skipping physical verification: Always reconcile opening balances with counts.
• Over‑permissive access: Limit permissions to avoid accidental adjustments.
• Ignoring integrations: Keep ERP/accounting integrations aligned to prevent duplicated transactions.

Quick start checklist (summary)

• Define goals, collect master data, and map warehouse.
• Choose deployment and install SIMMS.
• Configure locations, costing, serial/lot control, and users.
• Import data in batches and reconcile with physical counts.
• Implement barcode scanning for receiving/picking.
• Start cycle counts and track KPIs.
• Train teams and roll out in stages.