Stock Movement History

Stock Movement History

Stock movement history provides a complete audit trail of all inventory transactions, showing when, how, and why stock quantities changed. This guide explains how to view and use stock movement history in EquiBillBook.

What is Stock Movement History?

Stock movement history records:

• All increases and decreases in stock quantities
• Details of each transaction affecting inventory
• User who performed the transaction
• Date and time of each movement
• Reason or reference for the movement

Types of Stock Movements

Stock movements are categorized as:

• Opening Stock: Initial stock entry
• Purchase: Stock increase from purchase bills
• Sales: Stock decrease from sales invoices
• Stock Adjustment: Manual adjustments (increase or decrease)
• Stock Transfer: Movement between locations/branches
• Sales Return: Stock increase from customer returns
• Purchase Return: Stock decrease from supplier returns
• Stock Adjustment: Corrections and adjustments

Accessing Stock Movement History

To view stock movement history:

1. Navigate to Items → Stock Movement or Stock History
2. Alternatively, go to Reports → Inventory Reports → Stock Movement Report
3. For a specific item, open the item details and view stock history

Stock Movement Report Details

The report typically shows:

• Date: Date and time of the movement
• Item: Item code and name
• Transaction Type: Type of movement (Purchase, Sales, Adjustment, etc.)
• Reference: Invoice number, adjustment number, or transfer reference
• In Quantity: Stock quantity added
• Out Quantity: Stock quantity deducted
• Balance: Stock balance after the movement
• Cost Price: Cost per unit at the time of movement
• Value: Total value of the movement
• Location: Branch or location
• User: User who created the transaction

Filtering Stock Movements

You can filter movements by:

• Date Range: View movements for a specific period
• Item: Filter by specific item or item group
• Transaction Type: View only purchases, sales, adjustments, etc.
• Location/Branch: Filter by location
• User: View movements by specific user
• Reference Number: Search by invoice or document number

Viewing Movement for Specific Item

To view history for a single item:

1. Go to Items module
2. Search for and select the item
3. Open the item details page
4. Navigate to Stock History or Movement History tab
5. View all movements for that item in chronological order

Understanding Movement Types

Purchase Movements:

• Show stock increases from purchase bills
• Include purchase price and supplier information
• Reference the purchase bill number

Sales Movements:

• Show stock decreases from sales invoices
• Include selling price and customer information
• Reference the sales invoice number

Adjustment Movements:

• Show manual stock adjustments
• Include adjustment reason
• May be increases or decreases

Transfer Movements:

• Show stock transfers between locations
• Include source and destination locations
• Reference transfer document number

Stock Movement Audit Trail

The history provides a complete audit trail:

• Who made the change (user information)
• When the change occurred (timestamp)
• What changed (quantity and value)
• Why it changed (transaction type and reference)
• Where it changed (location/branch)

Exporting Stock Movement History

You can export movement history:

• Export to Excel for detailed analysis
• Export to PDF for reporting
• Schedule automated movement reports
• Share reports with auditors or management

Using Movement History for Reconciliation

Stock movement history helps with:

• Reconciling physical inventory with system records
• Identifying discrepancies and their causes
• Tracking unauthorized stock movements
• Investigating inventory issues
• Auditing inventory transactions

Stock Movement Reports

Available reports include:

• Stock Movement Summary: Overview of all movements
• Item-wise Movement: Movements grouped by item
• Date-wise Movement: Movements by date
• User-wise Movement: Movements by user
• Location-wise Movement: Movements by location
• Movement by Type: Movements grouped by transaction type

Best Practices

• Review stock movement history regularly
• Use history to identify unusual patterns
• Reconcile movements with physical inventory
• Maintain proper documentation for adjustments
• Use movement history for audit purposes
• Export and archive movement reports periodically
• Investigate discrepancies promptly

Common Use Cases

Stock movement history is useful for:

• Inventory Audits: Verifying all transactions
• Discrepancy Investigation: Finding causes of stock differences
• Trend Analysis: Understanding stock movement patterns
• Compliance: Meeting audit and regulatory requirements
• Training: Reviewing user activities
• Reporting: Generating management reports

Need Help?

If you have issues with stock movement history:

• Ensure stock tracking is enabled for items
• Verify that transactions are being recorded correctly
• Check user permissions for viewing movement history
• Ensure proper date range is selected
• Contact support if movements are not appearing

Stock movement history is an essential tool for inventory management, providing transparency, accountability, and auditability for all inventory transactions. Regular review helps maintain accurate inventory records and supports effective inventory control.