Count Reports

Asset Count Worksheet Report

Overview

This report displays Asset Items related to an Asset Count Request. This report is used when the physical inventory stock is being processed. It contains information of each Asset Item such as ID, Short Description, Brand, Model, Serial Number, Bar Code, etc.

NOTE: Some columns in this report are blank to that stock counts can be manually noted in the field.

 

Navigation

Assets ► Assets Reports ► Count Report Asset Count Worksheet

 

Asset Count Worksheet screen Fields

Field

Description

Report Date

Date of report generation automatically generated by system.  The date format is defined using a general parameter of the system.

Report Time

Time of report generation automatically generated by system.

User

User who generates the report

Page

Page Number

Filter Criteria

Filter Criteria as entered under asset class

Sort By

Used to sort the report by class (alphabetical) and Warehouse ID (upward).

Class Item

A class item must belong to a class which will define its basic characteristics and determine exactly what type of asset is. A computer may be an asset class but can also be a parent class for a Desktop or Laptop computer class.

Warehouse ID

A warehouse is a physical space used specifically for the storage of inventory and fixed assets. The warehouse can storage new and used fixed assets, including usable and unusable damaged or broken assets. Damaged or broken assets should be retired from a warehouse until a disposal transaction has been issued.  It is allowed to perform transfers of Assets or Inventory items between warehouses. Warehouse ID is a unique identifier of a Warehouse.

Asset Item ID

A unique asset item identifier. 

Short Description

Brief description of the Asset Item

Brand and Model

A collection of the different models represented by a particular brand E.g. Dell (Brand), Inspiron (Model)

Serial Number

A system generated identification code that is tagged with the asset item. 

Bar Code

Contains the code recognized by the bar code reader

Quantity

Default value is 1, this attribute can be used to group identical assets (e.g. Software Licenses) but if any of the units is retired or disposed the current cost gets prorated based on the number of units left generating a new value change transaction

Quantity Found

It represents the quantity found during the physical inventory.Warehouse ID Found: It represents the Warehouse ID found.

Remarks

Additional information regarding the Asset Item about its condition, advice to take a decision on an asset item withdrawal, reason for differences, etc.

Reason for Difference

Catalogue of reasons that supports the Asset Item in Count or Asset Item in Count Component Status (whenever there is overage and/or shortage). It is used for reporting and statistics.

 

Asset Count Variances Report

Overview

This report shows Asset Items pertaining to an Asset Count Request, which have quantity and amount variances. This report is used during the physical inventory stock take process. It contains information of each Asset Item such as ID, Short Description, Brand, Model, Serial Number, Bar Code, Quantity, Quantity Found, etc.

 

Navigation 

Assets ► Asset Reports ► Count Reports ► Asset Count Variances Report

 

Asset Count Variances Report screen Fields and Tab

Field

Description

Asset Count Request

The Asset Count Request is selected as a filter criteria for the report.

Institution

The Institution is  selected as a filter criteria for the report

Institution Warehouse

The Institution Warehouse is selected as a filter criteria for the report.

Asset Class

The Asset Class is selected as a filter criteria for the report

Asset Item

The Asset Item is selected as a filter criteria for the report

Report Date

Date of report generation automatically generated by the system

Report Time

Time of report generation automatically generated by the system

User

User who generates the report

Page

Page Number

Asset Count Request

The number describing which request is taking place

Filter Criteria

Filter Criteria as entered under the Asset Count Variances Report

Sort By

Used to sort the report by Class (alphabetical) and Warehouse ID (upward) criteria

Institution

The user's institution (e.g. Ministry of Finance)

Class

The class of asset described

Level

Level of class asset

Number of Items

Number of items specified for the asset class

Warehouse ID

The identification number of the warehouse

Asset Item ID

The identification number of the asset item

Short Description

Brief description of the asset item

Brand and Model

Model number and company brand of the asset item

Serial Number

The serial number of the asset item

Bar Code

The bar code number of the asset item

Quantity

The quantity that is  on hand

Quantity Found

The actual quantity that is on hand

Warehouse ID Found

The identification number found for the warehouse

Reason for Difference

Description for why a difference occurred

Status

Status of the difference (e.g. Shortage, Overage, etc.)

Quantity Difference

Difference between Quantity and Quantity Found

Value Difference

The difference in surplus or deficit amounts based on the difference between Quantity and Quantity Found

Total Shortage

The monetary shortage value of all shortage values added together

Total Overage

The monetary overage value of all overage values added together

 

Conflicts in Count Warehouse/Employee Report

Overview

This report displays Asset Items which have conflict with their Institution, Warehouse Institution, or Employee—that is to say, this report display's Asset Items that are inconsistently listed in relation to Institutions, Warehouses, etc. This report is used during the physical inventory stock take process. It contains information of each Asset Item such as ID, Short Description, Brand, Model, Serial Number, Bar Code, Warehouse ID, Employee ID, Institution ID Found, Warehouse ID Found, Employee ID Found, etc.

 

Navigation 

Assets ► Asset Reports ► Count Reports ► Conflicts in Count Warehouse/Employee Report

 

Conflicts in Count Warehouse/Employee Report screen fields and Tab

FieldDescription
InstitutionThe Institution is selected as a filter criteria for the report
Warehouse IDThe Warehouse ID is selected as a filter criteria for the report
Asset Count RequestThe Asset Count Request is selected as a filter criteria for the report.
Asset Item IDThe Asset Item ID is selected as a filter criteria for the report
Employee IDThe Employee ID that is selected as a filter criteria for the report.
ClassThe Class that isselected as a filter criteria for the report
Report DateDate of report generation automatically generated by the system
Report TimeTime of report generation automatically generated by the system
UserUser who generates the report
PagePage Number
InstitutionThe user's institution (e.g. Ministry of Finance)
Filter CriteriaFilter Criteria as entered under the Asset Count Warehouse/Employee Conflict Report
Sort ByUsed to sort the report by Class (alphabetical) and Warehouse ID (upward) criteria
ClassThe class description of the catalogue asset item listed in the report
LevelThe level of functions associated and attached to a hierarchy of connected items
Number of Items

The number of catalogue asset items listed in a specific report

Warehouse IDThe identification number of the warehouse
Employee IDThe identification number of the employee
Asset Item IDThe identification number of the asset item
Short DescriptionBrief description of the asset item listed in the report
Brand and ModelModel number and company brand of the asset item listed in the report
Serial NumberThe serial number of the asset item listed in the report
Bar CodeThe bar code number of the asset item listed in the report
QtyThe actual quantity that should be present in the warehouse
Qty FoundThe quantity of asset items found in the warehouse
Institution ID FoundThe identification number of the institution that the asset item is found at.
Warehouse ID FoundThe identification number of the warehouse that the asset item is found at.
Employee ID Found

The identification number of the employee that found the asset item

StatusStatus of the asset item (Shortage, Overage, Found).