WITS — Warehouse Inventory Tracking System

WITS (Warehouse Inventory Tracking System) is a comprehensive, multi-tenant warehouse management solution designed to manage customer-owned inventory from receiving and storage to picking, dispatch, inventory adjustments, reporting, and warehouse billing.

The system provides warehouse teams and customers with a centralized platform to maintain accurate inventory records, track stock by SKU, lot number, best-before date, and pallet, and maintain a complete operational history of warehouse movements.

Key Capabilities

Inventory & Warehouse Management

• Customer-based inventory management

• SKU and product master management

• Lot and batch-level inventory tracking

• Best-before/expiry date monitoring

• Real-time stock quantities

• Automated FIFO/expiry-ordered lot allocation

• Inventory movement history

• Inventory adjustments for damaged, spoiled, expired, or recalled stock

• Physical inventory counting and reconciliation

Inbound & Outbound Operations

The system manages the complete warehouse movement lifecycle:

Inbound Receiving

• Create receiving documents

• Record suppliers and shipping carriers

• Capture SKU, lot, quantity, and best-before information

• Automatically create or update inventory lots

• Automatically organize received quantities into pallets

• Generate receiving charges for billing

Outbound Dispatch

• Create customer pick lists

• Convert approved pick lists into outbound shipments

• Automatically allocate stock from available lots

• FIFO-based quantity allocation across multiple lots

• Automatic pallet grouping

• Stock validation before dispatch

• Generate outbound dispatch charges

• Maintain complete shipment history

Automated Pallet Management

WITS automatically calculates pallet quantities based on each customer's configured pallet rules.

The system considers:

• Unit of measure

• Units per pallet

• Customer-specific pallet configuration

• Partial pallet handling

• Historical pallet rule snapshots

This eliminates manual pallet calculations and ensures that historical warehouse documents remain accurate even when customer billing or pallet rules change later.

Multi-Tenant User & Permission Management

The application uses role-based access control with customer-level data isolation.

Supported roles include:

• Super Admin — complete system and warehouse access

• Customer Admin — manages users and customer-specific settings

• Editor — manages customer pick lists and operational history

• Viewer — read-only access to dashboards, history, and reports

Customer users can only access data belonging to their assigned customer, helping prevent cross-customer inventory and operational errors.

Warehouse Billing & Service Charges

WITS includes integrated warehouse billing functionality instead of treating inventory and billing as separate systems.

It supports:

• Included pallet storage

• Storage overage charges

• Inbound receiving fees

• Outbound pick/dispatch fees

• Customer-specific billing rates

• Effective-dated service rates

• Saved document-level charges

• Itemized billing reports

The system preserves the applicable rate at the time of each warehouse operation, allowing historical charges to remain accurate even after billing rates change.

Reporting & Business Intelligence

The reporting module provides filtered, print-ready operational reports including:

• Customer Stock Report

• Inventory Movement Report

• Pick List Demand Report

• Storage Billing Report

• Weekly billable itemization

Reports can be filtered by customer, SKU, shipping carrier, date range, and reporting period. Inventory movement reports can also be emailed directly to customers.

Operational Documents

The system generates print-ready documents for daily warehouse operations, including:

• Pick Lists

• Inbound Receiving Documents

• Outbound Bills of Lading (BOL)

• Inventory and billing reports

Documents are organized by customer, pallet, SKU, and lot where applicable, making them suitable for warehouse operations and customer communication.

Business Impact

WITS transforms warehouse operations from disconnected manual processes into a structured digital workflow.

It provides a single source of truth for customer-owned inventory, helping warehouse teams:

• Reduce manual inventory calculations

• Minimize stock allocation errors

• Track inventory by lot and expiry

• Improve inbound and outbound accuracy

• Maintain customer-level data separation

• Automate pallet calculations

• Preserve complete inventory history

• Simplify warehouse billing

• Generate customer-ready reports and documents

Technology & Architecture

The application was designed as a desktop-first internal business application, focused on operational efficiency, data accuracy, role-based security, and reliable inventory workflows rather than public-facing website functionality.

The architecture supports complex relationships between customers, SKUs, inventory lots, warehouse documents, pallets, billing rates, document charges, users, and operational reports.

Project Highlights

Project Type: Warehouse Management System / Inventory Management System
Primary Focus: Warehouse Operations, Inventory Tracking & Customer-Owned Stock
Core Features: Inventory Management, Lot Tracking, FIFO Allocation, Pallet Management, Pick Lists, Inbound Receiving, Outbound Dispatch, Billing, Reporting, Role-Based Access Control, Multi-Tenant Data Isolation

WITS demonstrates how a custom warehouse management platform can combine inventory control, warehouse operations, customer portals, automated stock allocation, pallet management, billing, and reporting into one integrated business system.