Inventory Lot/Serial History

Form ID: (IN407000)

Note: This form appears only if the Lot and Serial Tracking feature is enabled on the Enable/Disable Features (CS100000) form.

On this inquiry form, you can view detailed information about inventory stocked at the warehouses. You can locate a particular unit of the inventory item by its lot or serial number.

Form Toolbar

The form toolbar includes only standard buttons. For the list of standard buttons, see Form Toolbar and More Menu.

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
Company/Branch	The company, branch, or company group for which you want to view information. By default, the current company or branch is selected. You can select another branch, company, or company group to which you have access. This setting is required if the Multiple Base Currencies feature is enabled on the Enable/Disable Features (CS100000) form.
Lot/Serial Nbr.	The lot or serial number for which you want to view transaction information.
Warehouse	The warehouse for which you want to view transaction information. 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 transaction information. 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 transaction information.
Subitem	The subitem of the inventory item for which want to view transaction information. 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.
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.
Include Landed Cost in Unit Cost	A check box that indicates (if selected) that the system displays in the Unit Cost column the sum of item unit cost and landed cost which is taken from a purchase receipt (if any) associated with the item.

Table

This area displays the details of the transactions that meet the criteria you specified in the Selection area.

Table 1. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Summary	Opens the Inventory Summary (IN401000) form as a pop-up to display the availability data of the inventory item.
Allocation Details	Opens the Inventory Allocation Details (IN402000) form as a pop-up to display information about how the selected inventory item is allocated at the specified warehouse.

Table 2. Table Columns
Column	Description
Inventory ID	The inventory item involved in the transaction.
Tran. Date	The transaction date.
Tran. Type	The inventory transaction type, which can be one of the following: Receipt, Issue, Transfer, or Adjustment, for transactions originating in the Inventory module; or Invoice, Credit Memo, or Return, for transactions originating in another system module.
Reference Nbr.	The reference number of the document.
Subitem	The subitem of the inventory item involved in the transaction. 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 where the inventory transaction was performed. This column appears only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
Location	The location where the inventory transaction was performed. This column appears only if the Multiple Warehouse Locations feature is enabled on the Enable/Disable Features (CS100000) form.
Lot/Serial Number	The lot or serial number assigned to the unit or units with the specified combination of inventory ID and subitem code.
Expiration Date	The expiration date of the specified unit or units under the same lot or serial number.
UOM	The unit of measure used for the inventory item.
Quantity	The quantity of the item in the specified UOM.
Unit Cost	The cost of the item for the specified UOM.
Order Type	The type of the order that the inventory transaction is based on.
Order Nbr.	The reference number of the order that the transaction is based on.
Customer ID	The ID of the customer on the sales order that the transaction is based on.
Customer Name	The name of the customer on the sales order that the transaction is based on.
Receipt Type	The type of the receipt the inventory transaction is based on.
Receipt Nbr.	The reference number of the receipt the inventory transaction is based on.
Vendor ID	The ID of the vendor on the purchase receipt the inventory transaction is based on.
Vendor Name	The name of the vendor on the purchase receipt the inventory transaction is based on.
Released	A check box that, if selected, indicates that the inventory document has been released.
Description	The description of the transaction.