Contents for the Manage Asset Location Exceptions Screen
Use the fields and options to configure the Manage Asset Locations Exceptions screen.
Table Window
You cannot add new lines, insert lines, or repeat lines in this table window. You can, however, delete and/or undelete rows, edit data, and select or place rows on hold in the table window.
Rows display in this table window until they are corrected and uploaded from the Import Asset Locations screen OR until you manually delete them. Each time you run the process from the Import Asset Locations screen, additional exceptions, as applicable, are inserted into the table and display on this screen.
| Field | Description |
|---|---|
| Process Status |
The system automatically inserts data that fails validation(s) into this screen during the Import Asset Locations screen import process. Each row on this screen initially displays a status code of On Hold. You can change the status code to Selected when you have corrected all errors to signify that the row is ready to be processed from the Import Asset Locations screen, using the Exceptions Table as the input file. When you run the process from the Import Asset Locations screen, you can import only rows with a Selected status code from the Exceptions Table. |
| Entry Date/Time |
This non-editable column displays the date and time that the row was inserted into the Exceptions Table when you ran the process from the Import Asset Locations screen using a file as the input source. This field does not display the date of the bar code label scan. |
| User ID |
This non-editable column displays the ID of the user who ran the process from the Import Asset Locations screen using a file as the input source. The user ID in this column is not necessarily the ID of the user who performed the bar code label scan. |
| Input Line Number |
When you import a file containing scanned data via the Import Asset Locations screen, the system automatically assigns a "behind-the-scenes" sequential line number for each line of data for reference purposes. The system-assigned input line number automatically displays in this column and cannot be edited. Note: For each new file import from the Import Asset Locations screen, the system assigns a new series of input line numbers, beginning at line
1. As a result, if you have not resolved and uploaded all corrected exceptions from previous scans from this table window, you may find that duplicate input line numbers display in this table window. The date and time (and possibly the user ID) can help you differentiate between these records.
|
| Company ID |
This required editable column displays the company ID of logon used in the scan. |
| Asset No |
When you ran the process from the Import Asset Locations screen using an input file, you were required to select whether to read the input file by asset/item number or by tag number. Your selection was based on whether you had coded the asset number or the tag number, if different, onto the printed bar code label. You must assign each Asset Master record a unique asset/item number before you save it, but tag number data is optional for each Asset Master record and may be missing or duplicated among different Asset Master records. If you enter data in the file by asset/item number on the Import Asset Locations screen, the system validates each asset number scanned before upload. The validation must also include the item number, but if a bar code label contains the asset number and no item number, the input file must supply the related item number. Note: If you are using an Intermec 2400 series scanner and the bar code label contains the asset number but no item number, the scan automatically assumes that the item number is
00001 unless you overwrite it manually in the scanning hardware during the bar code scan process.
If the system cannot validate both the asset number and the associated item number from a scanned record, it will reject the record from the upload, write it to the Exceptions table, and display it in this table window. You should refer to the Columns In Which Data Errors Exist column to determine whether the Asset No column displays as an error condition. You can save a row with error conditions as long as its status is On Hold. You must correct all error conditions before you can successfully save a row with a Selected) status (for subsequent upload from the Exceptions table). The
Asset No column may be blank as a result of a data error. If this happens, you must enter, or click
This type of error could occur if you enter the file by tag number in the Import Asset Locations screen and the system cannot find the associated asset number in the Asset Master table. If you enter the file by tag number on the Import Asset Locations screen, the system must still associate the tag number with, and validate against, the related asset and item number. You must assign each Asset Master record a unique asset/item number before you save it, but tag number data is optional for each Asset Master record and may be missing or duplicated among different Asset Master records. |
| Item No |
When you ran the process from the Import Asset Locations screen using an input file, you were required to determine whether to read the input file by asset/item number or by tag number. Your selection was based on whether you had coded the asset number (and optionally the item number) or the tag number (if different) onto the printed bar code label. If the system cannot validate both the asset number and the associated item number from a scanned record, it will reject the record from the upload, write it to the Exceptions table, and display it in this table window. Refer to the Columns In Which Data Errors Exist column to determine if the Item No column displays as an error condition. You can save a row with error conditions as long as its status is On Hold. You must correct all error conditions before you can successfully save a row with a Selected status (for subsequent upload from the Exceptions table). The
Item No column may be blank as a result of a data error. If this happens, you must enter, or click
This type of error could occur if you enter the file by tag number on the Import Asset Locations screen and the system cannot find the associated asset/item number in the Asset Master table. |
| Tag No |
When you ran the process from the Import Asset Locations screen using an input file, you were required to determine whether to read the input file by asset/item number or by tag number. Your selection was based on whether you had coded the asset number (and optionally the item number) or the tag number (if different) onto the printed bar code label. If you enter data in the file by tag number on the Import Asset Locations screen, the system must still associate the tag number with, and validate against, the related asset and item number. Each Asset Master record must be assigned a unique asset/item number before you save it, but tag number data is optional for each Asset Master record and may be missing or duplicated among different Asset Master records. If the system cannot validate both the asset number and the associated item number from a scanned record, it will reject the record from the upload, write it to the Exceptions table, and display it in this table window. Refer to the Columns In Which Data Errors Exist column to determine if the Tag No column displays as an error condition. You can save a row with error conditions as long as its status is On Hold. You must correct all error conditions before you can successfully save a row with a Selected status (for subsequent upload from the Exceptions table). |
| Location Group Code |
If you have used the location group code as part of your bar code label, the label may display an invalid location group code. This could occur if you made a typographical error when printing the bar code label or inadvertently printed an invalid location group code on the bar code label. The location group code may not have been included in the bar code data printed on the property label, and there is no system requirement for one. Location group code data is always optional in an Asset Master record but, if entered, the location group code must have been previously entered on the Manage Location Groups screen. If there is a location group code and it cannot be validated, however, the system will reject the record from the upload, write it to the Exceptions table, and display it in this table window. This screen automatically displays ALL data scanned for the row, whether the data is valid or invalid. Refer to the Columns In Which Data Errors Exist column to determine whether the Location Group Code column displays as an error condition. You can save a row with error conditions as long as its status is On Hold. You must correct all error conditions before you can successfully save a row with a Selected status (for subsequent upload from the Exceptions table). To correct the error condition, enter, or click
|
| Location 1 (or your label) |
If you have used Location Code 1 as part of your bar code label, the label may display an invalid location code. This could occur if you made a typographical error when printing the bar code label or inadvertently printed an invalid location 1 code on the bar code label. The location code may not have been included in the bar code data printed on the property label, and there is no system requirement for one. Location code data is always optional in an Asset Master record, but if entered, the location code must have been previously entered on the Manage Location 1 Codes screen. If there is a location code and it cannot be validated, however, the system will reject the record from the upload, write it to the Exceptions table, and display it in this table window. This screen automatically displays ALL data scanned for the row, whether the data is valid or invalid. Refer to the Columns In Which Data Errors Exist column to determine whether the Location 1 column displays as an error condition. You can save a row with error conditions as long as its status is On Hold. You must correct all error conditions before you can successfully save a row with an Selected status (for subsequent upload from the Exceptions table). To correct the error condition, enter, or click
Note: If you have designated a label for this location in the
Location Labels for Asset Master group box of the Manage Asset Master Field Labels screen, your label description automatically displays as the header for this column.
You are not required to establish a label for this field. If you have not set up location code labels, the system-default label automatically displays as the header label for this column. |
| Location 2 (or your label) |
If you have used Location Code 2 as part of your bar code label, the label may display an invalid location code. This could occur if you made a typographical error when printing the bar code label or inadvertently printed an invalid location 2 code on the bar code label. The location code may not have been included in the bar code data printed on the property label, and there is no system requirement for one. Location code data is always optional in an Asset Master record, but if entered, the location code must have been previously entered on the Manage Location 2 Codes screen. If there is a location code and it cannot be validated, however, the system will reject the record from the upload, write it to the Exceptions table, and display it in this table window. This screen automatically displays ALL data scanned for the row, whether the data is valid or invalid. Refer to the Columns In Which Data Errors Exist column to determine whether the Location 2 column displays as an error condition. You can save a row with error conditions as long as its status is On Hold. You must correct all error conditions before you can successfully save a row with a Selected status (for subsequent upload from the Exceptions table). To correct the error condition, enter, or click
Note: If you have designated a label for this location in the
Location Labels for Asset Master group box of the Manage Asset Master Field Labels screen, your label description automatically displays as the header for this column.
You are not required to establish a label for this field. If you have not set up location code labels, the system-default label automatically displays as the header label for this column. |
| Location 3 (or your label) |
If you have used Location Code 3 as part of your bar code label, the label may display an invalid location code. This could occur if you made a typographical error when printing the bar code label or inadvertently printed an invalid location 3 code on the bar code label. The location code may not have been included in the bar code data printed on the property label, and there is no system requirement for one. Location code data is always optional in an Asset Master record, but if entered, the location code must have been previously entered on the Manage Location 3 Codes screen. If there is a location code and it cannot be validated, however, the system will reject the record from the upload, write it to the Exceptions table, and display it in this table window. This screen automatically displays ALL data scanned for the row, whether the data is valid or invalid. Refer to the Columns In Which Data Errors Exist column to determine whether the Location 3 column displays as an error condition. You can save a row with error conditions as long as its status is On Hold. You must correct all error conditions before you can successfully save a row with a Selected status (for subsequent upload from the Exceptions table). To correct the error condition, enter, or click
Note: If you have designated a label for this location in the
Location Labels for Asset Master group box of the Manage Asset Master Field Labels screen, your label description automatically displays as the header for this column.
You are not required to establish a label for this field. If you have not set up location code labels, the system-default label automatically displays as the header label for this column. |
| Columns In Which Data Errors Exist |
This non-editable column displays the name of each column in which data errors exist. Because the system displays ALL data scanned for the row, whether the data is valid or invalid, the purpose of this column is to list the data error conditions. Note: The system does not update the display of error conditions in this column on a real-time basis as you make corrections. This column will always display the original error condition(s), even after corrections are saved, unless you make manual edits to the displayed error conditions in this column.
Once you have corrected the error condition(s), placed the record on Selected status, and attempted to save the table window, the system will automatically perform validations for each data column in the row before saving. You cannot save if any error condition exists for the row. |
| Scan By |
This editable column displays a "Scan By" option code that you selected when you logged into your Intermec bar code scanner (prior to the actual bar code scan). These codes determine how the location validation rules are applied during the update portion of the Import Asset Locations routine. The following six option codes are available:
|
to select, a valid asset number. Because this is a standard Lookup to the ASSET table, you may find that you have selected asset/item numbers that are inappropriate for the scanned data.