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.