πŸ“˜ Stock Ledger

🌟 Overview

The Stock Ledger in the Concord CRM Inventory Module provides an automatic, chronological log of all stock movements. It ensures traceability and auditable tracking of changes in inventory levels across warehouses and bins.


βš™οΈ How Stock Ledger Works

  • A stock ledger entry is auto-generated every time stock is modified through:

    • βœ… Receipt conversion (stock creation)

    • πŸ”„ Put Away action (stock transfer)

    • πŸ“‰ Stock Adjustment (increase or decrease)

  • No manual creation is allowed β€” system-handled only.


πŸ—οΈ Ledger Entry Structure

Each ledger entry includes:

Field
Description

🏒 Warehouse

Warehouse location (optional if unassigned)

πŸ“¦ Bin

Bin location within warehouse (optional)

πŸ†” Item SKU

SKU code from the product catalog

πŸ” Transaction Type

One of: Transfer In, Transfer Out, WIP Consumption

βž• Quantity In

Quantity added to stock (if applicable)

βž– Quantity Out

Quantity removed from stock (if applicable)

βš–οΈ Balance

Total quantity of the item in the related warehouse after transaction

πŸ”— Reference No.

Linked to receipt, adjustment, or transfer record

πŸ“ Description

Short system-generated explanation of the action

🧾 Remarks

Optional notes for additional context

πŸ•’ Created At

Date and time of the transaction

πŸ”Ž Balance is calculated per warehouse and reflects current inventory after the transaction.


πŸ”„ Transaction Triggers

🧾 Receipt Item Conversion

  • When receipt item is confirmed and converted to stock

  • Ledger records initial stock entry

πŸ”„ Put Away

  • Transfer between warehouses/bins:

    • Creates Transfer Out entry from source

    • Creates Transfer In entry to destination

πŸ› οΈ Stock Adjustment

  • Increase = Transfer In

  • Decrease = Transfer Out

  • Reason captured in remarks field


πŸ“Š Key Features

  • 🧾 Fully Automated: No manual entry needed

  • πŸ”— Linked Transactions: Reference to receipt, adjustment, or put away

  • βš™οΈ Real-Time Logging: Entries created instantly upon stock change

  • πŸ‘₯ Audit Trail: Every stock movement is permanently recorded

  • πŸ“Š Per-Warehouse Tracking: Balance calculated per item per warehouse


πŸ“ Example Use Cases

  • βœ”οΈ Confirming newly received stock adds ledger entry

  • πŸ”„ Transferring stock between warehouses logs both in and out entries

  • πŸ“‰ Reducing stock due to damage adds a Transfer Out with reason in remarks

Last updated