Inventory Reports - Default View
Overview
The Default View provides a snapshot of items in stock. If a date is selected, additional columns are added showing the stock movements.
Buttons Explained
| Button | Description |
|---|---|
| View | Generates a summary Inventory Report based on the selected filters. |
| Actions |
|
| Rebuild multi-selected Items | Rebuilds the inventory transactions for the selected items. |
| Rebuild All | Rebuilds all the inventory transactions. |
| Output | Available on request. |
| Menu | See the Menu button described under Inventory Reports Settings. |
Filters Explained
| Filter | Description |
|---|---|
| Date | You can select a date option from the dropdown list. Depending on the chosen option, Start and End Dates for the report can be set in the provided blocks. |
| ⬅ ➡ | Adjusts the date field in the direction of the arrow. |
| Customer | A dropdown list of customers allowing you to view All or a specific Customer. |
| Category | A dropdown list of categories allowing you to view All or a specific Category. |
| Location |
|
| Hide blanks | A checkbox. If checked, suppresses records with no values. |
| Active | A checkbox. If checked, only displays Active Inventory Items. |
| Exceptions | A checkbox. If checked, only displays Inventory Items that are exceptions (e.g. negative stock quantities). |
Top Row Fields Explained
Info
These fields only apply if a specific date was selected.
| Field | Description |
|---|---|
| Field Chooser (*) | Add or remove columns. |
| Detail | Opens a section which displays the transaction status and details such as description, supplier and location. |
| Opening | Provides the opening balance as the start of the selected period. |
| Movement | Provides the inventory movements based on transactions during the selected period. |
| Closing | Provides the closing balances at the end of the selected period. |
Detail Band Fields Explained
| Field | Description |
|---|---|
| Field Chooser (*) | Add or remove columns. |
| ID | A system-generated number for the inventory item. |
| Customer | The name of the Customer that is linked to the inventory item. |
| Subcategory | The inventory item's Subcategory. |
| Status (Location) | The Status of the Location. |
| Status (Item) | The Status of the Inventory Item. |
| Category | The inventory item's Category. |
| Description | The inventory item's description. |
| Type | The type of item (e.g. MAT or ASM). |
| Supplier |
|
| Location | The Location of the inventory item. |
| Unit | An abbreviation describing the item's Unit. |
| Date | The date on which the item was first created as an inventory item (inventory checkbox checked and a location added on the Inventory tab). |
| Min Qty | The Minimum Quantity that was filled in on the inventory item's Inventory (tab). The number is highlighted if the current quantity of stock is less than the minimum quantity that should be in stock. |
| Reorder | The Reorder Quantity that was filled in on the inventory item's Inventory (tab). |
| Bin No | The inventory item's Bin Number. |
| Unit Price | The Unit Price of the inventory item. |
| Value | The value of the inventory on hand (unit price x quantity). If the value is negative (due to negative quantity in stock) the value appears in red. |
| Reference | The item's reference. |
| Code | The inventory item's code. |
Opening Fields Explained
| Field | Description |
|---|---|
| Qty (Opening) | The quantity on hand at the start date. |
| Unit Price (Opening) | The Unit Price of the inventory item. |
| Value (Opening) | The value of the stock on the opening date (opening qty x unit price). |
Movement Fields Explained
Info
Negative movements appear in red.
| Field | Description |
|---|---|
| Received | The quantity received during the selected period. |
| Issued | The quantity issued during the selected period. |
| Adjusted | The quantity adjusted during the selected period (e.g. by performing stock checks). |
| Total | The total quantity of stock movements during the selected period. |
| Value | The value of the inventory on hand (unit price x quantity). |
Closing Fields Explained
| Field | Description |
|---|---|
| Qty (Closing) | The quantity on hand at the end date. |
| Unit Price | The unit price of the inventory item. |
| Value (Closing) | The value of the closing inventory (unit price x qty). |
| Value (Received) | The value of stock received during the selected period. |
| Value (Adjusted) | The value of stock adjustments during the selected period (unit price x adjusted) |
| Unit Price % | The percentage change between the Opening and Closing Unit Prices. If the unit price decreased, the percentage change is negative and shown in red. |
| Value (Issued) | The value of stock issued during the selected period. |
No Date Fields Explained
Info
When No Date is selected, the opening and closing balances and movements do not appear.
Negative quantities or values appear in red.
| Field | Description |
|---|---|
| ID | A system-generated number for the inventory item. |
| Customer | The name of the Customer that is linked to the inventory item. |
| Subcategory | The inventory item's Subcategory. |
| Status (Location) | The status of the Location. |
| Status (Item) | The status of the Inventory Item. |
| Category | The inventory item's category. |
| Description | The inventory item's description. |
| Type | The type of item (e.g. MAT or ASM). |
| Supplier |
|
| Location | The location of the inventory item. |
| Unit | An abbreviation describing the item's Unit. |
| Date | The date on which the item was first created as an inventory item (inventory checkbox checked and a location added on the Inventory tab). |
| Min Qty | The Minimum Quantity that was filled in on the inventory item's Inventory (tab). The number is highlighted if the current quantity of stock is less than the minimum quantity that should be in stock. |
| Reorder | The Reorder Quantity that was filled in on the inventory item's Inventory (tab). |
| Bin No | The inventory item's Bin Number. |
| In Stock | The quantity currently in stock. This field appears and cannot be hidden using the Field Chooser (*). |
| On Order | The quantity that is on order. This field appears and cannot be hidden using the Field Chooser (*). |
| Reserve | The quantity that is reserved for orders. This field appears and cannot be hidden using the Field Chooser (*). |
| Available | The quantity that is available (see Stock Quantities). This field appears and cannot be hidden using the Field Chooser (*). |
| Unit Price | The Unit Price of the inventory item. |
| Value | The value of the inventory on hand (unit price x quantity). |
| Reference | The item's reference. |
| Code | The item's code. |
Context Menu
Info
Click the last row or right-click any entry. This menu is named Actions on the Field Chooser (*).
- Create Stock Check: Creates a stock check record with a Pending status.
- Open Stock Checks: Opens any stock check transactions created for that item.
- Open Item: Opens the item's setup page.
- View Item Summary: Displays a summary of the item's activity.
- View Serial Numbers: Opens a display showing the item's Serial Numbers.