Inventory transaction history (IN405000)
You use this inquiry window to view detailed information about inventory transactions posted within a selected period. You can set up criteria to view only particular 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 to display information about how the selected stock item is allocated at the specified warehouse. |
| Element | Description |
|---|---|
| Item ID | The stock item for which you want to view transaction information. |
| Warehouse | The warehouse for which you want to view transaction information. 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 transaction information. Note This field is only displayed if the Multiple warehouse locations functionality in the Enable/disable functionalities (CS100000) window is enabled. |
| Lot/serial no. | The lot or serial number for which you want to view inventory transactions (if the stock item has 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. |
| 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 the summary information for each day in the table. Clear this check box to display detailed information for each day within the selected period. |
| Include unreleased | A check box that you select to display the non-released transactions along with released transactions in the table. |
| Include landed cost in unit cost | A check box that you select to include the landed cost in unit cost. |
The table
In this area, you can view the details of the transactions that meet the criteria you have specified in the top part.
| Column | Description |
|---|---|
| Date | The transaction date. |
| 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 Multiple warehouse locations 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. |
| Released | A check box that indicates (if selected) that the transaction has been released. |
| Beginning qty. | The quantity of the selected stock item available at this warehouse before the inventory transaction was made. |
| Qty. in | The quantity of the selected stock item that were received at this warehouse as the result of the inventory transaction. |
| Qty. out | The quantity of the selected stock item that were issued from this warehouse as the result of the inventory transaction. |
| Ending qty. | The quantity of the selected stock item that were available at this warehouse after the inventory transaction was made. |
| Unit cost | The unit of measure used for the stock item. |
| Sales order type | The type of the sales order involved. |
| Sales order no. | The reference number of the sales order. |
| Purchase order receipt no. | The reference number of the purchase order. |
| Created by | The person who created the inventory transaction. |
| Doc. type | The type of the document |
| Grid line no. | The number of the grid line. |
| Item ID | The stock item of the inventory transaction. |
| Period | The financial period to which the transaction was posted. |
| Transaction period | The financial period when the transaction was created. |