Inventory transaction details (IN404000)
You can use this window to view summary information about inventory transactions posted within a selected financial period. You can set up criteria to display only specific data.
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 to display the availability data of the stock item. |
| Allocation details | Navigates to the Inventory allocation details (IN402000) window so you can view information about the allocation of the selected stock item at the specific warehouse. |
| Element | Description |
|---|---|
| Period | (Required) The financial period for which you want to view inventory transactions. |
| By financial period (without running values) | A check box that you select to display the inventory transactions by financial period, and to not display the running values ( Beginning quantity, Ending quantity, Beginning balance, and Ending balance ) in the table. If the check box is cleared, the inventory transactions will be selected by the date range in the specified financial period and the running values will be displayed. |
| Warehouse | The warehouse for which you want to view inventory transactions. Note This field is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location for which you want to view inventory transactions. Note This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Item ID | The stock item for which you want to view inventory transactions. |
| Lot/serial no. | The lot or serial number for which you want to view inventory transactions. A value can be selected only for stock items with lot or serial numbers. Note This field is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Sub item | The subitem of the stock item for which you want to view inventory transactions. Note This field is only displayed if the Stock sub items 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 view only summary values for each day in the specified period. Clear this check box to display detailed information for each day within the specified period. |
| Include unreleased (without costs) | A check box that you select to view unreleased transactions along with posted transactions. All types of transactions will be displayed without costs. |
| Period start date | Read only. This value shows the start date of the selected financial period. |
| Period end date | Read only. This value shows the end date of the selected financial period. |
The table
This table displays the details of inventory transactions that meet the criteria you have specified in the top part.
Values for columns marked with [*] are calculated based on the estimated per-unit cost, which depends on the valuation method selected for the stock item.
For details about valuation methods and per-unit costs, see: About the cost of inventory and About item costs and valuation methods.
| Column | Description |
|---|---|
| Date | The date when the inventory transaction was performed. |
| Trans. type | The inventory transaction type. For transactions originating in the Inventory workspace, the types can be:
For transactions originating in another workspace, the types can be:
|
| Ref. no. | The reference number of the transaction. |
| Warehouse | The warehouse where the inventory transaction was performed. Note This column is only displayed if the Multiple warehouses functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Location | The location where the inventory transaction was performed. Note This column is only displayed if the Stock sub items functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial number | The lot or serial number involved in the inventory transaction. Note This column is only displayed if the Lot and serial tracking functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Period | The financial period to which the transaction was posted. |
| Transaction period | The financial period in which the transaction was created. |
| Released | This check box (if selected) indicates that the transaction was released. |
| Beginning qty | The quantity of the stock item in the beginning of the selected period. |
| Qty. in | The quantity of the stock item accepted at the warehouse within the selected period. |
| Qty. out | The quantity of the stock item removed from the warehouse within the selected period. |
| Ending qty. | The quantity of the stock item at the end of the selected period. |
| Beginning balance [*] | The inventory balance in the beginning of the selected period. |
| Cost in [*] | The cost of the stock items accepted at the warehouse within the selected period. |
| Cost out [*] | The cost of the stock items removed from the warehouse within the selected period. |
| Ending balance [*] | The inventory balance at the end of the selected period. |
| Unit cost in/out [*] | The cost of the unit of the item of inventory involved in the inventory transactions within the selected period. |
| Sales order type | The type of the sales order involved. |
| Sales order no. | The reference number of the sales order involved. |
| Purchase order receipt no. | The reference number of the purchase order involved. |
| Doc. type | The type of the documents within the selected period. |
| Grid line no. | The number of the grid line. |
| Item ID | The ID of the selected stock item. |