Reconciliation of inventory

This page allows you to reconcile the inventory result recorded in the sheet for the inventory. Tell me more.

Select the “Reconcile Inventory” link at the bottom of the “Select Inventory Sheet” page.

The “Reconcile Inventory” page appears.

The system displays the following in the group-box:

Inventory Sheet No.	The number identifying the inventory sheet.
Sheet Description	A textual description pertaining to the inventory sheet.
Status	The status of the inventory sheet.
Sheet Date	The date on which the inventory sheet is created.

Enter the following fields in the group box to search for the assets which has to be added to be reconciled:

Asset Location Code	A number identifying the asset location (Alphanumeric, 20). Mandatory. Enter the code in full or partially using the * character. The system displays all the assets whose code is similar to the value entered here.
	This number must be defined in the “Create Asset Location” activity of “Asset Location” business component.
	Help facility available.
Asset Class Code	Use the drop-down list box to specify the code identifying the class to which the asset belongs. All the asset class defined in the “Create Asset Class” activity of the “Asset Type Definition” business components are displayed in the drop-down list box. The system leaves the fields blank by default.
Asset Group Code	A number identifying the group to which the asset belongs (Alphanumeric, 25). The system retrieves all the assets, which belongs to group specified here.
	Help facility available.
Asset No.	The number identifying the asset (Alphanumeric, 18).
	Help facility available.
Asset Description	The textual description pertaining to the description (Alphanumeric, 40). Enter the description in full or specify it partially using the * characters. The system retrieves all the sheets whose asset description is similar to the value entered here.
Inventory Result	Use the drop-down list box to specify the result of the inventory. The various inventory results available are
	Damaged - If the assets are found in the location but are damaged or not in working condition, then it is in the damaged condition.
	Missing – If the assets are in the list but not found in the location.
	Not Used – If the assets are in the list but not been used.
	OK - If the assets are same both in the location and in the list. These assets are not taken up for reconciliation.
	Extra - If the assets are extra.
	No Used - If the assets are in the list but not been used.
	The system displays “Ok” by default.
Tag No.	A number identifying the asset tag (Integer).
	Help facility available.
Tag Description	A textual description pertaining to the tag (Alphanumeric, 40). Enter the description in full or specify it partially using the * characters. The system retrieves all the inventory sheet whose tag description is similar to the text entered here.
Reconciliation Status	Use the drop-down list box to specify the default reconciliation status. The system displays the status in the multiline by default. The various reconciliation statuses are
	Ok – Indicates that the assets need no reconciliation
	Marked for Retirement – Indicates that the assets are marked for retirement.
	Marked for Transfer – Indicates that the assets are transferred from one location to another.
	Marked for Insurance – Indicates that the assets are marked for claiming insurance.
Inventoried Date From	The starting date in the range of dates from which the asset tags are verified (Date Format). The system lists all the asset tags that are verified raised later than this date.
	If this field is left blank and the “To” field is entered, then the system retrieves the asset tags of the inventory sheet starting from the first asset in the database till the asset tags, which is verified on the date specified in the “To” field. The date specified here must be less than the date entered in the “To” field.
To	The ending date in the range of dates until which the asset tags are verified (Date Format). The system lists all the asset tags of that inventory sheet that are verified earlier than this date.
	If this field is left blank and “Sheet Date From” field is entered, then the system retrieves the asset tags verified on the date specified in the “Sheet Date From” field till the last asset tag in the database.

Click the “Get Details” pushbutton to retrieve the inventory details in the multiline.
Enter the following field to default the reconciliation status in the multiline:

Default Reconciliation Status	Use the drop-down list box to specify the default reconciliation status. The system displays the status in the multiline by default. The various reconciliation statuses are
	Ok – Indicates that the assets need no reconciliation
	Marked for Retirement – Indicates that the assets are marked for retirement.
	Marked for Transfer – Indicates that the assets are transferred from one location to another.
	Marked for Insurance – Indicates that the assets are marked for claiming insurance.

The system displays the fields in the “Inventory Details” multiline:

Asset No.	The number identifying the asset.
Asset Description	The textual description pertaining to the asset.
Tag No.	The number identifying the asset tag.
Tag Description	The textual description pertaining to the asset tag.
Inventoried Date	The date on which the asset tags are verified.
Inventory Status	The status of the inventory sheet.

Enter the following fields:

Reconciliation Status	Use the drop-down list box to specify the reconciliation status. The system displays the status entered in the “Default Reconciliation Status” field by default. The various reconciliation statuses are
	Ok – Indicates that the assets need no reconciliation
	Marked for Retirement – Indicates that the assets are marked for retirement.
	Marked for Transfer – Indicates that the assets are transferred from one location to another.
	Marked for Insurance – Indicates that the assets are marked for claiming insurance.

Note: If the inventory results is "Not Working" or “Damaged”, then Reconciliation status can be "Ok", “Marked for Retirement" or "Marked for Insurance".

If the inventory result is " Missing", then Reconciliation status can be "Ok", "Marked for retirement" or "Marked for Transfer”.

If the inventory result is “Not Used”, then the reconciliation can be "Ok", "Marked for retirement", "Marked for Transfer” or “Marked for Insurance”. +

If the inventory result is "Extra", then the reconciliation status can be “Ok", "Marked for Transfer".

Remarks

Any remarks pertaining to the reconciliation of the asset (Alphanumeric, 255).

The system displays the following fields:

Asset Location Code	The code identifying the location in which the account exists.
Asset Class Code	The code identifying the class to which the asset belongs.
Asset Group Code	The code identifying the group to which the asset belongs.

Check the box in the “Select” column of the multiline to mark the asset for reconciliation.
Click the “Reconcile” pushbutton to reconcile the asset

The system updates the status of the tag to “Reconciled” in the sheet.

The system updates the status of the sheet to “Reconciled” if the tag status of all the assets in the sheet is reconciled.

Click the “Complete” pushbutton to complete the reconciliation process.

The system updates the status of the tag to “Completed” in the sheet.

The system updates the status of the sheet to “Completed” if the tag status of all the assets in the sheets is completed.

The system updates the reconciliation status of the asset.

The system updates the tag status in the “Asset Capitalization” business component to the reconciliation status.

Reconciliation of inventory – An overview

You can search for the assets using the location in which the asset exists, class to which the asset belongs, group to which the asset belongs, asset and tag details, inventory result, reconciliation status and the date on which the assets are verified. The system retrieves all the asset tags based on the search criteria specified. You can modify the reconciliation status of the asset tags. You can also specify the comments for reconciling.

The system updates the reconciliation status to “Marked for Retirement”, “Marked for Transfer” or “Marked for Insurance”. The same reconciliation status is reflected to the tags in the “Asset Capitalization” business component.

The system updates the status of the asset tags to “Reconciled” in the sheet. If all the assets in the sheet are reconciled, then the system updates the status of the sheet to “Reconciled”. You can also complete the assets, which are reconciled. The system updates the status of the asset tags to “Completed”. The system stores the login ID of the user along with the modification history.

What you can do in this page

Select assets of any inventory result for reconciliation

Default reconciliation status in the multiline

Update the reconciliation status for the asset

Select assets of any inventory result for reconciliation

Any discrepant assets can be taken up for reconciliation.

Set the “Inventory Result” field to “Damaged” to take up the assets, which are damaged for reconciliation.
Set the “Inventory Result” field to “Missing” to take up the assets, which are not found in the location for reconciliation.
Set the “Inventory Result” field to “Not Working” to take up the assets, which are not functioning for reconciliation.
Set the “Inventory Result” field to “All” to take up all the assets for reconciliation.
Select the reconciliation status accordingly and reconcile them.

Default reconciliation status in the multiline

You can specify the reconciliation status to be defaulted in the multiline for all the assets. This will ease your data entry.

Specify the “Default Reconciliation Status” in the group box.

Update the reconciliation status for the asset

You can reconcile the assets, which are discrepant.

Set the “Reconciliation Status” to “Ok” in case you don’t need to reconcile the discrepant assets.
Set the “Reconciliation Status” to “Marked for Retirement” in case you want to retire the assets.
Set the “Reconciliation Status” to “Marked for Transfer” in case you want to transfer assets from one location to another.
Set the “Reconciliation Status” to “Marked for Insurance” in case you want to claim insurance for the damaged asset.

The system updates the reconciliation status for the asset.