Asset Inventory Report

The Asset Inventory report gives all the details of the inventory sheet. This page generates two types of reports. Tell me more

Select the “Asset Inventory Report” link under “Reports – Fixed Assets Management”.

The “Asset Inventory Report” page appears.

Enter the following fields:

Inventory Sheet No. From

The starting number in the range of numbers identifying from which inventory sheet number you want to select to view the asset inventory report (Integer). The inventory sheet numbers must be defined in the “Asset Inventory Component”.

Note: The number entered in this field must be before the value entered in the “To” field.

To	The ending number in the range of numbers identifying to which inventory sheet number you want to select to view the asset inventory report (Integer). The inventory sheet numbers must be defined in the “Asset Inventory Component”.

Note: The number entered in this field must be equal to or greater than the number entered in the “Inventory Sheet No. From” field.

Sheet Status	Use the drop-down list box to select the status of the inventory sheet. You can select from “Fresh”, “Verified”, “Confirmed”, “Reconciled” and “Completed”.
	Fresh – indicates the inventory sheet is “Fresh” at the time of creation.
	Verified – indicates when all the assets in the sheet are verified and recorded. The sheet is verified in the “Record Inventory” activity of the “Asset Inventory” component.
	Confirmed – indicates when all the assets in the sheet are verified and confirmed. The sheet is confirmed in the “Record Inventory” activity of the “Asset Inventory” component.
	Reconciled – indicates when all the asset tags in the sheet are reconciled. The sheets are reconciled in the “Reconcile Inventory” activity of the “Asset Inventory” component.
	Completed – indicates when all the asset tags in the sheet are reconciled and have completed the inventory verification. The sheets are reconciled completely in the “Reconcile Inventory” activity of the “Asset Inventory” component.
Sheet Date From	The date in the range of dates identifying from which sheet date you want to select to view the inventory report (Date Format). The sheet date must fall within the open financial period.

Note: The date entered in this field must be less than or equal to the date entered in the “To” field.

To	The date in the range of dates identifying to which sheet date you want to select to view the inventory report (Date Format). The sheet date must fall within the open financial period.

Note: The date entered in this field must be greater than or equal to the date entered in the “Sheet Date From” field.

Asset Location Code	A unique code identifying the asset location for which you want to view the asset inventory report (Alphanumeric, 20). The code must be defined in the “Create Asset Location” activity of “Asset Location Component”.
	Help facility available.
Child Location	Check the box if you want to retrieve all the child locations mapped to the parent asset location. The child location for the asset location must have been defined in “Create Asset Location” activity of “Asset Location Component”.
Asset Class Code	Use the drop-down list box to select the code identifying the asset class for which you want to view the asset inventory report. All the values that have been deployed in the “Asset Type Definition Component” will be available for selection. The system displays “All” by default on the launch of the page.
Asset Group Code	Use the drop-down list box to select the code identifying the asset group for which you want to view the asset inventory report. All the values that have been deployed in the “Asset Type Definition Component” will be available for selection. The system displays “All” by default on the launch of the page.
	Help facility available
Child Group	Check the box if you want to retrieve all the child groups mapped to the parent asset group. The child group for the asset group must have been defined in “Asset Type Component”.
Finance Book	Use the drop-down list box to select the finance book for which you want to view the asset inventory report. All the finance books that have been deployed in the login organization unit of the company will be available for selection. The system displays “All” by default on the launch of the page.
Asset No.	A unique number identifying the number of the asset for which you want to view the asset inventory report (Integer). The asset numbers must be defined in the “Asset Inventory Component”.
	Help facility available
Asset Description	A textual description of the asset (Alphanumeric, 250).
Cost Center	A code identifying the cost center of the asset for which you want to view the asset inventory report (Alphanumeric, 10). The cost center codes must be defined in the “Cost Center Setup Component”.
	Help facility available
Asset Cost From	The starting amount in the range of amounts of the asset cost for which you want to view the asset inventory report (Decimal). The system retrieves all the assets whose cost is greater than the amount entered here. The amount entered here must be lesser than the amount entered in the “To” field.
	If this field is left blank and the “To” field is entered, then the system retrieves all the assets from the first assets in the database till the asset whose cost is the lesser than the value entered in the “To” field.
To	The ending amount in the range of amounts of the asset cost for which you want to view the asset inventory report (Decimal). The system retrieves all the assets whose asset cost is less than the value entered here.
	If this field is left blank and the “Asset Cost From” field is entered, then the system retrieves all the assets whose asset cost is greater than the value entered in the asset cost from field.
Tag status	Use the drop-down list box to select the status of the tag. You can select from “OK”, “Frozen”, “Marked for Transfer”, “Marked for Insurance” and “Marked for Retirement”. The system displays “All” by default on the launch of the page.
Inventoried Date From	The date in the range of dates identifying from which inventory date you want to select to view the asset inventory report (Date Format). The inventoried date must fall within the open financial period.

Note: The date entered in this field must be less than or equal to the date entered in the “To” field.

To	The date in the range of dates identifying to which inventory date you want to select to view the asset inventory report (Date Format). The inventoried date must fall within the open financial period.

Note: The date entered in this field must be greater than or equal to the date entered in the “Inventoried Date From” field.

Inventory Cycle	Use the drop-down list box to select the frequency cycle in which the inventories have to be verified. You can select from “Monthly”, “Quarterly”, “Half Yearly” and “Yearly” or “Not Required”. The system displays “All” by default on the launch of the page.
Inventory Due Date	The date in the range of dates identifying from which inventory due date you want to select to view the asset inventory report (Date Format). The inventory due date must fall within the open financial period.

Note: The date entered in this field must be less than or equal to the date entered in the “To” field.

To	The date in the range of dates identifying to which inventory due date you want to select to view the asset inventory report (Date Format). The inventory due date must fall within the open financial period.

Note: The date entered in this field must be greater than or equal to the date entered in the “Inventory Due Date From” field.

Asset Category	Use the drop-down list box to select the category to which the asset belongs. The various asset categories available for selection are
	Newly Acquired – Indicates that the asset tags are newly acquired and are not yet been inventoried.
	Newly Transferred – Indicates that the asset tags are in transit. The date on which the assets are received is greater than the last inventoried date.
	Overdue Assets – Indicates the asset tags whose inventory due date is greater than the inventory sheet date.

The system displays “All” by default on the launch of the page.

Click the “Inventory Sheet” pushbutton to view the inventory sheet report.

The system allows you to view the Inventory sheet report for the values entered. The report displays the inventory sheet number, the sheet date description and status. The report also displays the name of the user who created and modified the report. You can also view the asset number of the sheet, the tag details of the inventory and the inventoried date, the inventory results, and the remarks of the inventory results. The report also displays the reconciliation status and remarks of the inventory sheet, the asset location and description and the tag description of the inventory sheet.

Click the “Asset Inventory Schedule” pushbutton to view the physical assets inventory schedule report.

The system allows you to view the physical asset of the inventory in the inventory schedule report. You can view the details for the values entered. The report allows you to view the physical asset by displaying the asset number, the tag number and status and the asset location in the inventory. You can view the last inventoried date of the inventory and the inventory due date. You can also view the type of the inventory cycle and a brief description of the asset and the tag in the inventory.

Asset Inventory Report – An overview

You can view the inventory sheet report and the physical assets inventory schedule report. This page generates the inventory sheet report without entering any values in the page. The report by default takes all the values available. You can view all the physical assets and the location of the assets in the asset inventory schedule report. You can specify a range of numbers and dates and also select the sheet status to identify the inventory sheet. You can specify the asset location code and check the box if you want to view the child location of the asset location. You can also select the asset group code of the inventory. You can specify the asset group code and check the box if you want to view the child group of the asset group. You can select the finance book for the inventory. You can specify the asset number, the textual description of the asset and the cost center of the asset. You can also specify the value of the asset cost. You can select the tag status, specify a range of dates of the inventory date and inventory due dates to identify the inventory. You can also select the type of the inventory cycle and the asset category.