3.7.11.�Detailed Inventory History

3.7.11.1. Detailed Inventory History by Location
3.7.11.2. Detailed Inventory History by Lot/Serial #

Detailed Inventory history Reports section.

3.7.11.1.� Detailed Inventory History by Location

To view detailed Inventory history by Location, select the "Detailed Inventory History by Location" option. The following screen will appear:

Detailed Inventory History by Location

Note

The display will only list Inventory history for Multiple Location Control Items. Items without Multiple Location Control turned on will not be listed in the display. Multiple Location Control is set in the Item Site record.

When displaying detailed Inventory history by Location, you are presented with the following options:

Location

Specify the Location whose detailed Inventory History you want to display. Displays detailed Inventory history for selected Location.

Netable

Indicates whether the Location is Netable or not.

Restricted

Indicates whether the Location is Restricted or not.

Trans. Types

Select one of the available transaction types:

All Transactions: Displays all Inventory transactions.
Receipts: Displays receipts into Inventory from Manufacturing, purchases, or miscellaneous receipts.
Issues: Displays issues from Inventory to Manufacturing.
Shipments: Displays shipments to customers.
Adjustments and Counts: Displays Inventory adjustments and counts.
Transfers: Displays Inter-Warehouse Transfers and Location and Lot/Serial Number reassignments.
Scraps: Displays Scrap removed from Inventory.

Note

The system prefixes Order Numbers with letters indicating the Order type. For example, Work Orders are prefixed with "WO", Purchase Orders with "PO", and Sales Orders with "SO". These letters are for display purposes only and are not considered part of the Order Number.

All Warehouses: Select to display detailed Inventory history by Location for all Warehouses.
Selected: Specify Warehouse whose detailed Inventory history by Location you want to display.
Start Date: Inventory transactions conducted on and after this date will be displayed. Start date and end date must be entered for calculation to proceed.
End Date: Inventory transactions conducted on and before this date will be displayed. Start date and end date must be entered for calculation to proceed.
Inventory History: Display lists detailed Inventory history by Location, using the specified parameters.

To the far right of the screen, the following buttons are available:

CLOSE: Closes the screen, returning you to the application desktop.
QUERY: Select to generate the display, using the specified parameters. Start date and end date must be entered for calculation to proceed. Results will be displayed in the "Inventory History" list.
PRINT: Runs the report associated with this screen.

3.7.11.2.�Detailed Inventory History by Lot/Serial #

To view detailed Inventory history by Lot/Serial Number, select the "Detailed Inventory History by Lot/Serial #" option. The following screen will appear:

Detailed Inventory History by Lot/Serial Number

When displaying detailed Inventory history by Lot/Serial Number, you are presented with the following options:

Lot/Serial #: Enter the Lot/Serial Number of the Inventory whose detailed Inventory history you want to display. This field supports regular expressions.

Tip

The "Lot/Serial #" field supports pattern matching with Regular Expressions. For more information on matching patterns using Regular Expressions, see Section�1.2.9, “Topic: Pattern Matching with Regular Expressions”.

Trans. Types

Select one of the following transaction types from the drop-down menu.

All Transactions: Displays all Inventory transactions.
Receipts: Displays receipts into Inventory from Manufacturing, purchases, or miscellaneous receipts.
Issues: Displays issues from Inventory to Manufacturing.
Shipments: Displays shipments to customers.
Adjustments and Counts: Displays Inventory adjustments and counts.
Transfers: Displays Inter-Warehouse Transfers and Location and Lot/Serial Number reassignments.
Scraps: Displays Scrap transfer from Inventory.

Start Date

Inventory transactions conducted on and after this date will be displayed. Start date and end date must be entered for calculation to proceed.

End Date

Inventory transactions conducted on and before this date will be displayed. Start date and end date must be entered for calculation to proceed.

Inventory History

Display lists detailed Inventory history by Lot/Serial Number, using the specified parameters.

Note

To the far right of the screen, the following buttons are available:

CLOSE: Closes the screen, returning you to the application desktop.
QUERY: Select to generate the display, using the specified parameters. Start date and end date must be entered for calculation to proceed. Results will be displayed in the "Inventory History" list.
PRINT: Runs the report associated with this screen.

Right-clicking on a transaction without an assigned Order number in the Inventory History list enables you to select from the following menu options:

View Pending Inventory History: Select to view Inventory transactions for the Item Site since the date the specified Count Tag was created.
Export Contents: Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.