Item Inventory

Report Module Guide: Available Item/Service (Stock Status Report)

Module Location

Inventory > Reports > Item Inventory

Module Objective

The Available Item/Service Report module is used to generate a comprehensive inventory status report. This report provides a detailed overview of the quantity of each item, broken down by its various locations or statuses within the company's workflow (e.g., stock in the main warehouse, stock in the production area, quarantine stock, etc.).

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:

• Item/Service Category Type:

  • Filter the report for a specific item category, such as FINISHED GOODS.

• Period:

  • Specify the reference date ("as of" date) for the stock position to be displayed.

• Expiry Status:

  • Filter to view items based on their expiry status (for example, to only display items that are about to expire).

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, especially the Category Type and the Period.

Step 2: Generate the Report

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

• [Display Report]: To preview the stock status report 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 very detailed matrix table, providing a comprehensive view of stock distribution.

• Rows: Each row represents one Material Name or item.

• Columns: The columns show the quantity of that item in various different locations or statuses, such as Warehouse Stock, Production, Transfer, etc.

• How to Read: By reading a single row horizontally, you can see the total stock distribution of one item across all areas of the company on the selected date.

Tips & Important Notes

• This report provides a more holistic view of the stock position compared to a Stock Card, which only tracks the history of movements.

• Use this report for total stock reconciliation at month-end or to understand where your stock is located both physically and in the system.

• This is an advanced report that is very useful for Inventory Managers and the PPIC team.