Inventory transactions by account (IN403000)
The top part
By using the elements in this area, you can view in the table the data that is most relevant to your information needs.
| Button | Description |
|---|---|
| Summary | Navigates to the Inventory summary (IN401000) window, from which you can view the availability data of the stock item. |
| Allocation details | Navigates to the Inventory allocation details (IN402000) window, from which you can view information about how the selected stock item is currently distributed among warehouses and locations. |
| Element | Description |
|---|---|
| Inventory account | The inventory account for which you want to view the posted inventory transactions. |
| Subaccount | The subaccount for which you want to view the posted inventory transactions. |
| Period | The financial period for which you want to view the posted inventory transactions. |
| By financial period | A check box that you select to view the inventory transactions grouped by financial period. |
| Item ID | The stock item for which data will be displayed. |
| Warehouse | The warehouse for which data will be displayed. Note This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Element | Description |
|---|---|
| Start date | The start date of the date range for the inventory transactions to be displayed. |
| End date | The end date of the date range for the inventory transactions to be displayed. |
| Summary by day | A check box that you select to display only summary values for each day in the table. Clear this check box to display detailed information for each day within the selected period. |
| Period start date | Read only. This value displays the start date of the selected financial period. |
| Period end date | Read only. This value displays the end date of the selected financial period. |
The table
| Column | Description |
|---|---|
| Account | The account used to post the inventory transaction. |
| Subaccount | The subaccount used to post the inventory transaction. |
| Trans. type | The inventory transaction type, which can be a transaction type related to an inventory operation, or a transaction type, used in another system workspace if the account was shared by both that workspace and the Inventory workspace.
|
| Ref. no. | The reference number of the transaction. |
| Item ID | The stock item used in this inventory transaction. |
| Cost sub item | The sub item of the stock item if item cost is split by sub item segment values. Note This column is only displayed if the Stocky sub items functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Warehouse | The warehouse where the transaction was performed. Note This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location (if costed) | The location where the transaction was performed. Note You can only select locations for which the Cost separately check box on the Locations table tab in the Warehouses (IN204000) window is selected. Note This column is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Cost adjustment | A read-only check box which (if selected) indicates that cost adjustment was generated for the transaction. |
| Date | The transaction date. |
| Beginning balance | The account beginning balance (before the transaction). |
| Debit | The debit amount related to the transaction. |
| Credit | The credit amount related to the transaction. |
| Ending balance | The account’s ending balance (after the transaction). |
| Period | The financial period to which the transaction was posted. |
| Transaction period | The financial period when the transaction was created. |
| Qty. | The quantity of the stock item involved in the transaction. |
| Unit cost | The unit cost of the stock item used in this transaction. |
| Description | The transaction description. |
| Sales order type | The type of order for items sold or to be sold. |
| Sales order no. | The number of the sales order for items sold or to be sold. |
| Purchase order receipt no. | The number of the purchase receipt for items purchased. |