# 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:
* **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.
## 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:
* **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.
## 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:
**(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)
