Skip to main content

Stock Card Report

Report Module Guide: Stock Card Report

Module Location

Inventory > Reports > Stock Card Report

Module Objective

The Stock Card Report module is used to generate a "Stock Card," which is a report that provides a detailed and chronological transaction history for one or more specific items. This report is a fundamental tool for tracking every goods movement (in and out) and validating the ending balance.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

  • Warehouse / Select Bin:

    • Filter the report for a specific warehouse location or bin.

  • Item/Service Code:

    • The primary filter to select one or more specific items for which you want to see the stock card.

  • Period:

    • Specify the transaction date range in the From and To fields.

  • For Accounting:

    • Check Yes if the generated report requires value details or other accounting information.

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially selecting the Item/Service Code to be checked and specifying its Period range.

Step 2: Generate the Report

After all parameters are set, click one of the buttons at the bottom:

  • [Display Report]: To preview the stock card directly on your screen.

  • [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report is a Stock Card or a subsidiary ledger for the selected item, which begins with a Beginning Balance and details every transaction.

  • Report Content (Conceptual): Although the details are not visible, this report will display:

    • The Beginning Balance.

    • A chronological list of transactions containing In, Out, and Ending Balance columns for quantity.

    • If the "For Accounting" option is selected, the report will also display the value (price) of each movement and the ending inventory value.

Tips & Important Notes

  • This report is very similar to the Inventory Report (Stock Card) that was discussed previously, and most likely presents the same data with a slightly different format or filters.

  • Use this report to investigate stock discrepancies or to track the complete history of a specific item.

  • This is a crucial audit report for the Warehouse and Inventory Accounting teams.

No comments to display

Back to top