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:

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

• Select Time Period: Define the period for evaluation.

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

• Download: Export the Stock Movement Report as an Excel file.

• 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) ​