Inventory Transaction Summary
You use this form to check the inventory balance for the selected financial period and to view summary information about inventory transactions posted within this period. You can use selection criteria to display only particular data.
Form Toolbar
The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.
Button | Description |
---|---|
Transaction Details | Navigates to the Inventory Transaction Details (IN404000) form, where you can view summary information about the inventory transaction. |
Inventory Summary | Navigates to the Inventory Summary (IN401000) form, where you can view the availability data of the inventory item. |
Allocation Details | Navigates to the Inventory Allocation Details (IN402000) form, where you can view how the inventory item from the inventory transaction is distributed among warehouses and warehouse locations. |
Selection Area
By using the elements in this area, you can view in the table the data that is most relevant to your information needs.
Element | Description |
---|---|
Period | The financial period for which you want to view data. This is a required element. |
By Financial Period | A check box that you select to group the inventory transactions in the table by financial period. |
Warehouse |
The warehouse for which you want to view data. This box appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form. |
Location |
The location for which you want to view data. This box appears only if the Multiple Warehouses and Multiple Warehouse Locations features are enabled on the Enable/Disable Features (CS100000) form. |
Inventory ID | The inventory item for which you want to view data. |
Subitem |
The subitem for which you want to view data. This box is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form. Important:
The Inventory
Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality
associated with the Inventory Subitems feature will be phased out. If you have
this feature enabled in your system, the associated functionality remains available. To
disable the feature, contact your MYOB support provider. |
Show Items Without Movement | A check box that you select to display information on inventory items for which no inventory transactions were made within the selected period. |
Element | Description |
---|---|
Subitem Details | A check box that you select to display the inventory subitem data in a single row of the table. Clear this check box to aggregate data and show the item summary information. |
Warehouse Details | A check box that you select to display the warehouse data in a single row of the table shown below. Clear this check box to show the summary information for all warehouses. |
Location Details | A check box that you select to display the location data in a single row of the table shown below. Clear this check box to show the summary data for all locations. |
Table
This table displays the transaction summary data by using the criteria you have specified in the Selection area.
Button | Description |
---|---|
Inventory Item | Navigates to the Stock Items (IN202500) form to display information about the selected inventory item. |
Summary | Navigates to the Inventory Summary (IN401000) form to display the availability data of the inventory item. |
Allocation Details | Navigates to the Inventory Allocation Details (IN402000) form to display information about the allocation of the selected inventory item at the specific warehouse. |
Inventory Transaction Details | Navigates to the Inventory Transaction Details (IN404000) form to display detailed transaction data for the selected inventory item. |
Column | Description |
---|---|
Fin. Period ID | The financial period of the transaction summary data. |
Inventory ID | The inventory item for which the transaction summary data is displayed. |
Subitem |
The subitem for which the transaction summary data is displayed; this column is shown only if the Subitem Details check box is selected. This column is available only if the Inventory Subitems feature is enabled on the Enable/Disable Features (CS100000) form. Important:
The Inventory
Subitems check box has been removed from the Enable/Disable Features (CS100000) form because the functionality
associated with the Inventory Subitems feature will be phased out. If you have
this feature enabled in your system, the associated functionality remains available. To
disable the feature, contact your MYOB support provider. |
Warehouse |
The warehouse for which the transaction summary data is displayed; this column is shown only if the Warehouse Details check box is selected. This column appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form. |
Location |
The location for which the transaction summary data is displayed. This column appears only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features (CS100000) form and you've selected the Location Details check box. |
Beginning Qty. | The beginning quantity of the inventory item (at the start of the selected period). |
Issued |
The issued quantity for the selected period calculated as the sum of the quantities of an inventory item in issue documents and the negative quantities in adjustment documents. |
Received |
The received quantity for the selected period calculated as the sum of the quantities of an inventory item in receipt documents and the positive quantities in adjustment documents. |
Sales | The quantity of the inventory item in sales operations for the selected period. |
Credit Memos | The quantity of the inventory item on credit memo documents for the selected period. |
Drop Ship Sales |
The quantity of the inventory item included in the drop ship orders within the selected period. This column appears only if the Drop Shipments feature is enabled on the Enable/Disable Features (CS100000) form. |
Transfer In | The quantity of the inventory item transferred into the warehouse within the selected period. |
Transfer Out | The quantity of the inventory item transferred out of the warehouse within the selected period. |
Assembly In |
The quantity of the inventory item required for assembling the kits if the item is a component of a kit. This column is available only if the Kit Assembly feature is enabled on the Enable/Disable Features (CS100000) form. |
Assembly Out |
The quantity of the inventory item added as the result of kit assembling if the item is a kit. This column is available only if the Kit Assembly feature is enabled on the Enable/Disable Features (CS100000) form. |
Ending Qty. | The quantity of the inventory item at the end of the selected period. |
Description | The description of the item. |