Stock Ledger Entry

Back to Stock

Overview

Stock Ledger Entry – Business Explanation

Stock Ledger Entry is a core business record in Dafater that tracks every movement of inventory across the organization. It acts as the official audit trail for stock quantity and value changes, ensuring that inventory levels, costs, and availability are always accurate and traceable.


What Stock Ledger Entry Is Used For

Stock Ledger Entry is used to: - Record every increase or decrease in inventory - Maintain an accurate running balance of stock quantities - Track inventory value changes for financial and costing purposes - Provide a reliable history of stock movements for audits and analysis

Rather than being created manually, Stock Ledger Entry is usually generated automatically whenever a stock-related business transaction occurs.


Prerequisites and Setup Requirements

Before Stock Ledger Entry can function correctly, the following must be in place: - Items (products or materials) must be defined - Warehouses or storage locations must be set up - Stock valuation method (such as FIFO or moving average) must be decided - Business processes for purchasing, sales, manufacturing, or transfers must be active

Accurate setup ensures that Stock Ledger Entry reflects true stock positions and values.


Typical Workflow and Business Fit

  1. A business transaction occurs
    Examples include purchasing goods, selling products, transferring stock between locations, or consuming materials in production.

  2. Stock is affected
    Quantity increases, decreases, or moves from one warehouse to another.

  3. Stock Ledger Entry is created automatically
    Dafater records:

    • What item moved
    • From where and to where
    • Quantity change
    • Resulting stock balance
    • Stock value impact
  4. Inventory and reports update instantly
    Inventory balances, valuation reports, and financial insights are updated based on these entries.

Stock Ledger Entry sits at the heart of inventory control, connecting operational activity with accurate stock reporting.


Key Business Scenarios Where It Is Essential

Stock Ledger Entry is critical in: - Purchasing – recording stock received from suppliers - Sales and delivery – reducing stock when goods are shipped - Internal transfers – moving stock between warehouses or branches - Manufacturing or assembly – consuming raw materials and producing finished goods - Stock adjustments – correcting discrepancies found during stock counts - Financial reporting – supporting inventory valuation and cost analysis

Without Stock Ledger Entry, businesses cannot reliably know what stock they have or what it is worth.


Important Considerations for Users


In Summary

Stock Ledger Entry is the backbone of inventory accuracy in Dafater. It ensures every stock movement is documented, valued, and traceable, enabling businesses to maintain control over inventory, support financial accuracy, and make confident operational decisions.

Basic Information

Fields

Field Name Label Type Required Options Description
item_code Item Code Link Item Item being transacted in Dafater stock ledger
warehouse Warehouse Link Warehouse Warehouse where stock movement is recorded in Dafater
posting_date Posting Date Date - Business date when stock entry is posted in Dafater
posting_time Posting Time Time - Exact time when stock entry is posted in Dafater
posting_datetime Posting Datetime Datetime - Combined posting date and time for Dafater stock entry
isadjustmententry Is Adjustment Entry Check - Indicates whether entry is a manual stock adjustment
autocreatedserialandbatch_bundle Auto Created Serial and Batch Bundle Check - Marks if Dafater auto-created serial and batch bundle
voucher_type Voucher Type Link DocType Source document type generating this Dafater stock entry
voucher_no Voucher No Dynamic Link voucher_type Source document reference number in Dafater
voucherdetailno Voucher Detail No Data - Specific line reference from the source voucher
serialandbatch_bundle Serial and Batch Bundle Link Serial and Batch Bundle Linked serial and batch bundle for this stock movement
dependantslevoucherdetailno Dependant SLE Voucher Detail No Data - Reference to dependent stock ledger entry detail
recalculate_rate Recalculate Incoming/Outgoing Rate Check - Forces recalculation of incoming or outgoing valuation rates
actual_qty Actual Qty Float - Quantity added or removed from stock
qtyaftertransaction Qty After Transaction Float - Available stock quantity after this transaction
incoming_rate Incoming Rate Currency Company:company:default_currency Valuation rate applied for incoming stock
outgoing_rate Outgoing Rate Currency Company:company:default_currency Valuation rate applied for outgoing stock
valuation_rate Valuation Rate Currency Company:company:default_currency Current valuation rate of the item in stock
stock_value Balance Stock Value Currency Company:company:default_currency Total value of stock after this entry
stockvaluedifference Change in Stock Value Currency Company:company:default_currency Change in stock value due to this transaction
stock_queue FIFO Stock Queue (qty, rate) Long Text - FIFO queue tracking quantities and rates
company Company Link Company Company to which this stock transaction belongs
stock_uom Stock UOM Link UOM Unit of measure used for stock tracking
project Project Link Project Project associated with this stock movement
fiscal_year Fiscal Year Data - Fiscal year in which the transaction is recorded
hasbatchno Has Batch No Check - Indicates whether item tracking uses batch numbers
hasserialno Has Serial No Check - Indicates whether item tracking uses serial numbers
is_cancelled Is Cancelled Check - Shows whether this stock ledger entry is cancelled
to_rename To Rename Check - Internal flag used by Dafater for record renaming
serial_no Serial No Long Text - Serial numbers affected by this stock transaction
batch_no Batch No Data - Batch number associated with this stock transaction

Permissions

Role Read Write Create Delete Submit Cancel
Accounts Manager
Stock User
DocType Relationship Module
Company Links to Setup
Item Links to Stock
Project Links to Projects
Serial and Batch Bundle Links to Stock
UOM Links to Setup
Warehouse Links to Stock