Generate Batch/Lot-wise Stock Status Report
YouTube: How to Generate Batch/Lot-wise Stock Status Report?
How to Generate Batch/Lot-wise Stock Status Report?
In this tutorial, we will demonstrate how to configure and generate a Batch-Wise Stock Status Report in Logic ERP.
Open Stock Query Configuration
Navigate to the Reports/Queries section under the Stock Report category.
Open Stock Query.
Click on Configuration to create a new report.
Enter an appropriate Configuration Name for the report.
Define Print Columns
Under the Print Options tab, click on Print Columns.
A list of available columns will appear.
Select the checkboxes for the columns you want to include in your report, such as:
Lot Number
Item Name
Opening Stock
Purchase
Purchase Return
Sale
Sale Return
Closing Stock
You can rearrange the column order using the Arrow Keys as per your preference.
Configure Totals
Under the Total section, select the appropriate options based on how you want the totals to be displayed in the report.
Set Item View and Sorting
Move to the Other Options 1 tab.
Under the Item View section:
Set Lot Wise from the dropdown menu.
In the Item Sorting option, choose Item.
From the Transaction Filter, select Transacted Items to include only those items that have stock movements.
Once done, click Save Configuration.
Generate the Report
From the Configuration List, select the newly created report.
Click on Create Report to generate the Lot -Wise Stock Status Report.
Final Outcome
The generated report will display Lot-Wise stock details for each item, including:
Opening and Closing Stock
Purchases and Sales
Purchase Returns and Sale Returns
This report helps you analyze stock availability and movements Lot - Wise for accurate inventory tracking.
Last updated