# Inventory Report and Stock Movement Report

## 1. **Inventory Report**

The Inventory Report provides statistical data on the quantity of products available in each warehouse. It helps track both Actual Stock and Available Stock:

* **Actual Stock**: The physical quantity of products currently stored in the warehouse.
* **Available Stock** = Actual Stock + Pending Stock Receipts − Pending Stock Exports ± Pending Stock Transfers.

How to access:

Go to the **Warehouse** module → select **Inventory Report**. The system screen will display as follows:

<figure><img src="/files/gwCbyKGVi1DeZXbomPIs" alt=""><figcaption></figcaption></figure>

* **Select Warehouse for Reporting**: You can select multiple warehouses (limited to the warehouses where you are assigned).
* **Search Filter**: Filter by product name, product code, product category, or group.
* **Product List**: Displays stock levels per product in each selected warehouse.

**Note**: If there's a difference between the actual stock and available stock of a product, it may indicate that some stock receipts, exports, or transfers are still pending approval. Click the **“i”** icon next to the quantity to view detailed pending transactions.

<figure><img src="/files/iNGkZDBKQheEVtrikVyz" alt=""><figcaption></figcaption></figure>

## 2. Warehouse Card

The Warehouse Card gives a detailed report of the opening stock, stock received, stock exported, and closing stock of each product per warehouse.

How to access:\
Go to the Warehouse module → select Warehouse Card. The system screen will display as follows:

<figure><img src="/files/DxjCKVOxdeGs3uPYA9Vr" alt=""><figcaption></figcaption></figure>

* **Filter Options**: Filter by product code, name, category, warehouse, and time period (default is the current month, but can be adjusted).
* **Download**: Export the Warehouse Card as an Excel file.

Note: Click the “i” icon next to each product to view detailed history of stock transactions, including receipts, exports, and transfers.

<figure><img src="/files/17ZHyxUv1MT6pcpgU9qi" alt=""><figcaption></figcaption></figure>

## 3. Stock Movement Report

The Stock Movement Report helps track both quantities and values of inventory per product and warehouse over a selected period. It includes:

* **Beginning Inventory**: Quantity carried over from the previous period.
* **Quantity Received**: Total incoming stock during the selected period.
* **Quantity Exported**: Total outgoing stock during the selected period.
* **Ending Inventory**: Quantity remaining at the end of the period.
* **Inventory Value**: Calculated by multiplying inventory quantity by the **average purchase price**.

How to access:

Go to the Warehouse module → select Stock Movement Report. The system screen will display as follows:

<figure><img src="/files/7DgEpeIVxRE5Aonc64hM" alt=""><figcaption></figcaption></figure>

**(1) Select Warehouse for Valuation**: Choose the relevant warehouse(s).

**(2) Select Time Period**: Define the period for evaluation.

**(3) Calculate Export Price**: The system will calculate and display stock movement and value per product, including beginning stock, incoming, outgoing, and ending stock.

**(4) Download**: Export the Stock Movement Report as an Excel file.

**(5) Filter Options**: Filter by product code and product name.

**Note**:\
For new users of the warehouse feature in Getfly, the Stock Movement Report will only show data after a warehouse is selected and export price calculation is performed.\
The export price is calculated using the **Weighted Average Cost** method applied to the entire period.

Cost of Goods Sold (COGS) Formula:

COGS = ((Beginning Inventory Quantity×Beginning Purchase Price)+(Incoming Stock Quantity×Purchase Price))/(Beginning Inventory Quantity + Incoming Stock Quantity)\
​\
Profit Calculation per Order:\
Profit=(Quantity×Selling Price)−Product Discount−Order Discount+Installation Fees (if any)−(Quantity×COGS)

<figure><img src="/files/uWu9ExtYCvcWQeYgRHrv" alt=""><figcaption></figcaption></figure>

<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://helpdesk.getfly.vn/web-version/images-and-media/warehouse-module/inventory-report-and-stock-movement-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
