Stock Ledger Report
The Stock Ledger Report provides a comprehensive log of all stock movements within a company.
Transactions involving manufacturing, purchasing, selling, and stock transfers are meticulously recorded in the Stock Ledger, which is then summarized in the Stock Ledger Report.
This report showcases the quantity and value of stock that has been issued, received, or transferred, along with pertinent details such as the stock item and its corresponding warehouse.
Particularly useful when the Perpetual Inventory system is enabled, the Stock Ledger Report offers a detailed history of all stock transactions, providing a nuanced understanding of stock movements over time.
Stock Ledger Report Attributes
- Incoming Rate: This denotes the actual cost at which the stock was acquired and added to your inventory. It mirrors the value entered in the Rate field of the respective document.
- Balance Value: This indicates the total worth of the remaining stock in your inventory. It is computed by multiplying the Valuation Rate by the Balance Quantity of a particular stock item.
- Valuation Rate: This figure is determined based on the chosen valuation method.
The Stock Ledger Report illustrates a Stock Entry of Material Receipt as follows:
It presents an item “Chair” with a quantity of 1000 units, acquired at an Incoming Rate (Basic Rate) of Rs. 3000, and received in the warehouse “Stores – L.” Additionally, it calculates the Valuation Rate and Balance Value associated with this transaction.
You can click on the Voucher # to access the document from which this transaction originated.
Stock Ledgers are generated from the following transactions:
- Sales Invoice, Purchase Invoice (with Update Stock checked)
- Delivery Note
- Purchase Receipt
- Stock Entry
- Stock Reconciliation
You can add fields from the previously mentioned Document Types by clicking on Menu > Add Column.