Business Value
- Monitor all store transfers and usages within any date range in one report.
- Filter by source store, destination store, expense account, or item.
- Compare requested, approved, and available quantities side by side.
- Track each movement’s status and the staff who requested and approved it.
Use Cases
- Inventory controller reviews all transfers between stores for the week to verify stock movements.
- Cost controller filters by expense account to see usages charged to a specific department.
- Store manager checks Draft requests still awaiting approval before month-end close.
How It Works
| Where: Back Office → Reports → BO → Store Usage/Transfers |
|---|
Running the Report
From Date / To Date: Reporting period — returns transfers and usages with a request date in this range. From Store: (Optional) Filter to movements out of one or more source stores. To Store: (Optional) Filter to transfers into one or more destination stores. Expense Account: (Optional) Filter to usages charged to one or more expense accounts. Item: (Optional) Filter to one or more specific items. State: Filter by document state. Set to All to include every state, or pick a specific one (e.g., Draft, Approved). Report Type: Filter by movement type. Set to All to include both, or choose Transfer or Usage only. File Type: Choose the export format — XLS, XLSX, ODS, or PDF. Available actions: Download | Preview | PrintReport Layout
- Results are grouped under an item group header (e.g., BAKERY ITEMS).
- Each item lists its individual transfer/usage lines, followed by a Total row that sums the Requested Qty, Approved Qty, and Available Qty for that item.
Report Columns
| Column | Description | Example |
|---|---|---|
| Item Number | System item code for the moved item. | 140014 |
| Item Description | Name of the item. | BREAD CRAMBS |
| Type | Movement type — Transfer or Usage. | Transfer |
| ID | The transfer or usage document number. | 808 |
| Request Date | Date the transfer or usage was requested. | 2026-05-30 |
| Requested Qty | Quantity originally requested on the document. | 9 |
| Approved Qty | Quantity approved for the movement. | 9 |
| Available Qty | Quantity available in the source store at the time. | 118 |
| Status | Current document status (e.g., Approved, Draft). | Approved |
| Requester | User who created the transfer/usage request. | kit@alkasr |
| Approver | User who approved the movement. | M.salah@alkasr |
| Note: A Total row appears after each item, summing its Requested Qty, Approved Qty, and Available Qty. Items are grouped by item group. |
|---|
Update: June 10, 2026
Price and Total Columns
The report now shows the unit price and total cost for every item, giving you full financial visibility into store movements.What’s New?
Two new columns — Price and Total — are added to the report, placed after the Approved Qty column and before the Available Qty column.How It Works
- Price shows the unit price of the item in the transfer or usage.
- Total shows the total cost (Price × Approved Qty) for the line.
- The Total column is summed at both the item level and the item group level.
