Overview
The Stock Ledger is a report used to view the movement of stock for a selected product and warehouse over a specified period. It provides details of inward and outward stock movements along with opening balance, current total, grand total, and closing balance.
Stock Ledger Filters
The Stock Ledger can be filtered using the following options:
- Date Range – Select a predefined date range for the report.
- From Date – Specify the starting date of the reporting period.
- To Date – Specify the ending date of the reporting period.
- Product Name – Select the product for which the stock ledger needs to be viewed.
- Type – Select the applicable stock type, such as Physical.
- Warehouse – Select a specific warehouse or choose All to include stock from all warehouses.
Click the Search button to generate the Stock Ledger based on the selected filters.
Stock Ledger Details
The report displays the following information:
- SL.NO – Serial number of the stock movement.
- DATE – Date of the stock transaction.
- TYPE – Type of stock transaction.
- REF NO – Reference number associated with the transaction.
- REMARKS – Additional information related to the stock movement.
- OUTWARD – Quantity of stock issued or moved out.
- INWARD – Quantity of stock received or moved in.
Stock Summary
The Stock Ledger provides a summary of stock movements through the following values:
- Opening Balance – Stock quantity available at the beginning of the selected reporting period.
- Current Total – Current stock movement total for the selected period.
- Grand Total – Total inward and outward stock quantities recorded during the selected period.
- Closing Balance – Stock quantity remaining after considering the inward and outward movements.
Stock Movement
The Stock Ledger records stock movements based on transactions affecting the selected product and warehouse.
- Inward represents stock received or added.
- Outward represents stock issued or reduced.
- The Closing Balance reflects the resulting stock after the recorded movements.
Export and Print Options
The Stock Ledger provides options to generate or export the report:
- Print – Print the Stock Ledger report.
- Excel – Export the report to Excel format.
- PDF – Export the report to PDF format.