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 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 form.

Important: The Inventory Subitems check box has been removed from the Enable/Disable Features 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 form.

Important: The Inventory Subitems check box has been removed from the Enable/Disable Features 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 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 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.