Stock Ledger Report
A Stock Ledger Report is a detailed record that keeps track of stock movements for a company.
Inward or outward transactions related to Manufacturing, Purchasing, Selling, and Stock Transfers are recorded in the Stock Ledger which then is reflected in the Stock Ledger Report.
It reflects the quantity and value of stock issued, received, or transferred along with the stock item and its warehouse details.
It can be referred when the Perpetual Inventory system is enabled, as this report reflects the history of all your stock transactions. It presents a more granular view of the stock transactions.
Stock Ledger Report Attributes
Incoming Rate: It reflects the actual value of the stock at which it was brought under your inventory. It reflects the same value as entered in the Rate field of the document.
Balance Value: It represents the total value of the remainder stock in the inventory. It is the product of Valuation Rate and Balance Quantity of a stock item.
Valuation Rate: It is calculated based upon the valuation method selected.
Here is how Stock Ledger Report represents a Stock Entry of type Material Receipt.
It reflects an item Chair of quantity 1000 units with Incoming Rate (Basic Rate) as Rs.3000 received in warehouse Stores - L along with calculating Valuation Rate and Balance Value.
You can click on Voucher # to open the document this transaction was created from.
Stock Ledgers are generated from the following transactions:
- Sales Invoice, Purchase Invoice (with Update Stock checked)
- Delivery Note
- Purchase Receipt
- Stock Entry
- Stock Reconciliation
- We need to add Basic Rate to the Stock Ledger Account
You can add fields from the previously mentioned Document Types by clicking on Menu > Add Column.