Assets Report
Asset Reports are used to monitor and manage the processes involved with the assets which have been purchased, sold, and currently being stored in the inventory at the warehouse.
Asset Reports can perform these functions:
- Classifies assets by user-designated groups, with subtotaling and totaling of an overall value
- Identifies each item for which depreciation is to be taken including cost, life and depreciation schedule
- Records depreciation for external reporting
- Provides standard governmental reporting: i.e., it should not include information such as investment tax credit data or basis costs
- Tracks all transactions affecting the value of an asset by original source document number and date, and the module and application in which the transaction originated
- Maintains accountability and reporting of fixed assets that have actually been granted to, or owned by, another screen
- Displays or print subsidiary ledgers of fixed asset balances
- Produces a transaction register audit trail of all acquisitions, transfers, changes, retirements, and disposals during a user-defined time period by asset type, department, transaction date, funding source, or purchase amount
- Provides a money total of fixed asset purchases by their funding source and department/organization
- Reports assets due for disposition, based on the scheduled disposal date
- Provides a vendor/PO listing of assets by vendor or in purchase order number sequence
- Produces a deletion report showing items by asset type which have physically been disposed of but still remain on file for information purposes
- Produces a listing of all inactive/idle or retired assets by location and asset category
- Produces a listing of all disposed assets showing any gains or losses and the associated account coding
- Produces a listing of all disposed assets showing any gains or losses and the associated account coding
- Produces a forecast of assets scheduled for replacement, based on user-specified criteria, such as useful life, scheduled disposition date, or odometer readings
- Allows reporting and inquiry of replacement cost by department or organization unit and by asset type
- Produces depreciation reports by cost-center
- Produces a depreciation report by balance sheet category, such as buildings and equipment
- Produces a report of assets by: Asset Type, Fund, Division,
- Prints reports to support taking of physical inventory by division and/or location
Below you will find a list of all Asset Reports used during the Asset Management Process.
Asset Contract Report
Overview
The Asset Contract Report displays the list of Contracts related to an Asset Item such as Leasing, Maintenance, and Support Contracts.
Navigation
Assets ► Asset Reports ► Asset Contract Report
Asset Contract Report screen Field
Field | Description |
Asset Item | The asset item to be used as filter criteria for the asset contract report. |
Asset Catalogue Report
Overview
This report displays the complete repository of Assets. It contains information of each Asset Item such as ID, Short Description, Brand, Model, Type (Capitalized, Expensed, CIP, etc.), Serial Number, Bar Code, etc.It includes the General List of Items, Items by Class, Items by Group, Items by Institution, and Items by Region.
Navigation
Assets ► Asset Reports► Asset Catalogue
Asset Catalogue Report Screen Fields
Field | Description |
Group By | Used to group the report by Asset Class |
Filter Criteria | Filter Criteria as entered under the Asset Catalogue Report |
Asset Group | The Asset Group that may be selected as filter criteria for the report |
Asset Type | The Asset Type that may be selected as filter criteria for the report |
Ownership Type | The Ownership Type that may be selected as filter criteria for the report. |
Physical Condition | The Physical Condition that may be selected as filter criteria for the report. |
Operational Status | The Operational Status that may be selected as filter criteria for the report. |
Asset Item Status | The Asset Item Status that may be selected as filter criteria for the report. |
Asset Class | The Asset Class that may be selected as filter criteria for the report |
Brand | The Brand that may be selected as filter criteria for the report |
Institution | The Institution that may be selected as filter criteria for the report |
Region | The Region that may be selected as filter criteria for the report. |
| Employee | The Custody Employee that may be selected as filter criteria for the report. |
| Goods Receive Return Note | The GRN id that may be selected as filter criteria for the report. |
| Item | Catalogue Item Reference that may be selected as filter criteria for the report. |
| Project Associated | The Project associated that may be selected as filter criteria for the report. |
| Specific Source | The Project source that may be selected as filter criteria for the report. |
Asset Detailed Information Report
Overview
The Asset Detailed Information Report displays the detailed information for an asset, such as Class, Ownership Type, Manufacturer, etc.
Navigation
Assets ► Asset Reports► Asset Detailed Information
Asset Detailed Information Report Screen fields
Field | Description |
Item Id | Filter option to generate the report for a specific Item Id. |
| Asset Class | Filter option to select type of class. |
| Original value From | Range of original value. |
| Original value To | Range of original value. |
| Employee | The Custody Employee that may be selected as filter criteria for the report. |
| Item | Catalogue Item Reference that may be selected as filter criteria for the report. |
| Project Associated | The Project associated that may be selected as filter criteria for the report. |
| Specific Source | The Project source that may be selected as filter criteria for the report. |
| Asset Item Origin | Drop down to select origin of asset item. |
| Current value From | Range of current value. |
| Current value To | Range of current value. |
Assignments By Employee Report
Overview
The Asset Assignments by Employee Report displays the List of Assets assigned to an Employee.
Navigation
Assets ► Asset Reports► Assignments by Employee
Assignments By Employee Report screen Fields
Field | Description |
Employee | Filter option to generate report for a specific Employee. |
Assignments By Vendor Report
Overview
This report shows the List of Assets provided by a Vendor.
Navigation
Assets ► Asset Reports ► Assignments By Vendor Report
Assignments By Vendor Report screen Fields
Field | Description |
Comparison Id | Filter option to generate report for a specific Comparison Id. |
Acquisition Analysis Reports
Overview
This report displays the acquisitions by comparing purchased versus leased options. The report displays the cost values for the both options such as Purchase Payments, Leasing Payments, Maintenance Costs, Insurance Costs, Depreciation, Total Costs, and NPV (Net Present Value) Total Costs.
Navigation
Assets ► Asset Reports ► Acquisition Analysis
Acquisition Analysis Reports screen Fields
Field | Description |
Comparison Id | Filter option to generate report for a specific Comparison Id. |
Assets by Operational Status Report
Overview
This report displays a List of Assets by Operational Status (in stock, in use, disposed, etc.). It contains the following information for each Asset: ID, Short Description, Catalogue Item ID, Operational Status, Date of Change of Operational Status, and Transaction ID.
Navigation
Assets ► Asset Reports ► Assets by Operational Status
Assets by Operational Status screen fields
Field | Description |
Item Group | The Item Group that may be selected as filter criteria for the report. |
Item Physical Condition | The Item Physical Condition that may be selected as filter criteria for the report. |
Operational Status | The Operational Status that may be selected as filter criteria for the report. |
Item Ownership Type | The Item Ownership Type that may be selected as filter criteria for the report. |
Item Type | The Item Type that may be selected as filter criteria for the report. |
Item Status | The Item Status that may be selected as filter criteria for the report. |
Class | The Class that may be selected as filter criteria for the report. |
Brand | The Brand that may be selected as filter criteria for the report. |
Region | The Region that may be selected as filter criteria for the report. |
Institution | The Institution that may be selected as filter criteria for the report. |
Transactions Per Asset Report
Overview
This report displays information related to the transaction history of an Asset for audit trail purposes.
Navigation
Assets ► Asset Reports ► Transactions per Asset
Transactions Per Asset Report screen Fields
Field | Description |
Item Id | Filter option to generate report for a specific Item Id |
Credit Account | The Credit Account that may be selected as filter criteria for the report. |
Debit Account | The Debit Account that may be selected as filter criteria for the report. |
Origin | The Origin that may be selected as filter criteria for the report. |
Status | The Status that may be selected as filter criteria for the report. |
Transfers Per Asset Report
Overview
This report displays information related with the transfer’s history of an Asset. These transfers refer to when Assets are physically moved to another Warehouse Institution, or when Coding Blocks for any of accounts associated to the Assets needs to be changed.
Navigation
Assets ► Asset Reports ► Transfers per Asset
Transfer by Asset Report screen fields
Field | Description |
Item ID | Filter option to generate report for a specific Item Id. |
Transfer Type | The type of transfer that is occurring for the asset, to be selected from the list and used as filter criteria. |
Custodies Per Asset Report
Overview
This report displays information related to the custodies history of an Asset. Custody occurs with the association of an Asset Item to an Employee. This is distinct from the ‘Assignments by Employee Report’, which highlights assets that are actively assigned to employees. On the contrary, this report presents the history of an asset’s custody. As such, this report can be filtered to show anyone who has ever owned a given asset.
Navigation
Assets ► Asset Reports ► Custodies per Asset
Custodies per Asset Report screen Fields
Field | Description |
Item Id | Filter option to generate report for a specific Item Id. |
Custody Type | The type of custody that is occurring for the asset, to be selected from the list and used as filter criteria. |
Warehouse Asset Transfers Report
Overview
This report displays the Assets Transfers between different Warehouses. The report displays the following information: Asset ID, Asset Short Description, Asset Coding Block, Units, Transfer ID, Transfer Date, Source Warehouse, and Destination Warehouse.
Navigation
Assets ► Asset Reports ► Warehouse Asset Transfers
Warehouse Asset Transfer Report screen Fields
Field | Description |
Institution | The Institution that may be selected as filter criteria for the report. |
Asset ID | The Asset ID that may be selected as filter criteria for the report. |
Transfer ID | The Transfer ID that may be selected as filter criteria for the report. |
Source Warehouse ID | The Source Warehouse ID that may be selected as filter criteria for the report |
Destination Warehouse ID | The Destination Warehouse ID that may be selected as filter criteria for the report |
Asset Transactions Report
Overview
This report displays information on all of the Transactions related to an Asset. Each transaction displays basic information such as Date, ID, Asset Item ID, Asset Short Description, Transaction Status, Amount, etc.
Navigation
Assets ► Asset Reports ► Asset Transactions Report
Asset Transactions Report screen Fields
Field | Description |
Transaction Origin | The Transaction Origin that may be selected as filter criteria for the report. |
Transaction Status | The Transaction Status that may be selected as filter criteria for the report.The Transaction Status that may be selected as filter criteria for the report. |
Asset Item Type | The Asset Item Type that may be selected as filter criteria for the report. |
Asset Item Group | The Asset Item Group that may be selected as filter criteria for the report. |
Asset Item | The Asset Item that may be selected as filter criteria for the report. |
Institution | The Institution that may be selected as filter criteria for the report. |
Region | The Region that may be selected as filter criteria for the report. |
Asset Class | The Asset Class that may be selected as filter criteria for the report. |
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
| Field | Description |
| Institution | The Institution is selected as a filter criteria for the report |
| Warehouse ID | The Warehouse ID is selected as a filter criteria for the report |
| Asset Count Request | The Asset Count Request is selected as a filter criteria for the report. |
| Asset Item ID | The Asset Item ID is selected as a filter criteria for the report |
| Employee ID | The Employee ID that is selected as a filter criteria for the report. |
| Class | The Class that isselected 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 |
| Institution | The user's institution (e.g. Ministry of Finance) |
| Filter Criteria | Filter Criteria as entered under the Asset Count Warehouse/Employee Conflict Report |
| Sort By | Used to sort the report by Class (alphabetical) and Warehouse ID (upward) criteria |
| Class | The class description of the catalogue asset item listed in the report |
| Level | The 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 ID | The identification number of the warehouse |
| Employee ID | The identification number of the employee |
| Asset Item ID | The identification number of the asset item |
| Short Description | Brief description of the asset item listed in the report |
| Brand and Model | Model number and company brand of the asset item listed in the report |
| Serial Number | The serial number of the asset item listed in the report |
| Bar Code | The bar code number of the asset item listed in the report |
| Qty | The actual quantity that should be present in the warehouse |
| Qty Found | The quantity of asset items found in the warehouse |
| Institution ID Found | The identification number of the institution that the asset item is found at. |
| Warehouse ID Found | The 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 |
| Status | Status of the asset item (Shortage, Overage, Found). |
Valuation Reports
Asset Valuation Report
Overview
This report displays information related to the Valuation of an Asset.
Navigation
Assets ► Asset Reports ► Valuation Reports ► Asset Valuation Report
Asset Valuation Report screen fields
Field | Description |
Item ID | The Item ID that may be selected as filter criteria for the report. |
Transaction Origin | The Transaction Origin that may be selected as filter criteria for the report. |
Transaction Status | The Transaction Status that may be selected as filter criteria for the report. |
Transaction Date From | The Transaction Date From that may be selected as filter criteria for the report. |
Transaction Date To | The Transaction Date To that may be selected as filter criteria for the report. |
Sort By | Transaction Date sort by option to arrange report according to transaction date. |
Transaction Type Tab | Transaction Type tab allows to lookup and insert the value of Asset Transaction Type to generate the transaction type wise report. |
Assets Valuation By Asset Class And Institution Report
Overview
The valuation of an asset item can be done in terms of asset class as well as institution. This is the role of this report. The report shows the following fields mentioned mandatorily Original Value, Value Change, Disposal, etc.
Navigation
Assets ► Asset Reports ► Valuation Reports ► Assets Valuation By Asset Class And Institution
Assets Valuation by Asset Class and Institution Filter Definitions
Field | Description |
Asset Class | The Asset Class that may be selected as filter criteria for the report. |
Fiscal Year | The Fiscal Year that may be selected as filter criteria for the report. |
Fiscal Period | The Fiscal Period that may be selected as filter criteria for the report. |
Effective date from | The Effective Date that may be selected as filter criteria for the report. |
Effective date to | The Effective Date that may be selected as filter criteria for the report. |
Original Value from | The Original Value From that may be selected as filter criteria for the report. |
Original value to | The Original Value To that may be selected as filter criteria for the report. |
Group individual Institutions | The Group Individual Institutions that may be selected as filter criteria for the report. |
Group by Institution type | The Group By Institution Type that may be selected as filter criteria for the report. |
Institution | The institution responsible for filing the report. |
Sort by | Order of which the items are sorted by |
Asset Item physical condition | Select Asset Item from the available Physical condition options. |
Current Valuation Report
Overview
This report shows valuation information generated in terms of asset grouping by asset class, asset group, region, and by warehouse institution. This valuation is based on the sum of Current Values of each asset inside each institution or warehouse.
Navigation
Assets ► Asset Reports ► Valuation Reports ► Current Valuation Report
Current Valuation Report output screen fields
Field | Description |
Report Type | The Item ID as a filter criteria for the report. |
Asset Class | The Asset Class selected as afilter criteria for the report |
Asset Group | The Asset Group selected as a filter criteria for the report. |
Brand | The Brand selected as a filter criteria for the report |
Group By | Used to group the report by Asset Class |
Group Individual Institutions | Grouping of Institutions individually |
Group By Institution Type | Grouping facility by type of the institution |
Region Tab | Describes about Region |
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 |
Filter Criteria | Filter Criteria as entered under the Assets Current Valuation By Coding Block. |
Sort By | Used to sort the report by Institution ID (upward). |
Group By | Used to group the report by Asset Class |
ID | Unique identification number for a particular asset item |
Asset Class Name | Short Description or name of the type of asset class. |
Current Value | The value after depreciation changes have occurred |
Original Value | This is the value paid for the asset, depending on the acquisition information, this could be an estimated price or fair cost if the asset has been obtained by a donation, bequest or sequestration.This value cannot be modified once the first depreciation period has occurred for this item. |
Depreciation | The reduced value amount from the Original Value |
Book Value | Reflects the cost of the Asset from the accounting perspective. The book value differs from the original cost depending on the value change transactions that affected the asset. |
General Assets Detailed Per Institution Report
Overview
Detailed information for each asset item in form of a report is presented here. It shows the asset item grouped in terms of its institution. Thus the report can be filtered in accordance to the different institution as per choice of the users. By default the report is sort by Asset Institution Name (Institution group) ascending and then by Asset Item ID.
Navigation
Assets ► Asset Reports ► Valuation Reports ► General Assets Detailed Per Institution Report
General Assets Detailed Per Institution Filter Definitions
Field | Description |
Comments | The Comments that may be selected as filter criteria for the report |
Group individual Institutions | The Group Individual Institutions that may be selected as filter criteria for the report. |
Group By Institution Type | The Group by Institution Type that may be selected as filter criteria for the report |
Historical Valuation Report
Overview
This report shows the Assets Historical Valuation (specific point in time) grouped by Asset Classes, Asset Groups within an Institution. The report shows the following Amounts: Original Value, Value Change, Depreciation, Disposal, and Book Value
Navigation
Assets ► Asset Reports ► Valuation Reports ► Historical Valuation Report
Historical Valuation Report screen fields and Tab
Field | Description |
Report Type | Type of the Report. i.e. Summary or Detailed |
Asset Class | The Asset Class that may be selected as filter criteria for the report |
Effective date from | The Effective Date that may be selected as filter criteria for the report. |
Effective date to | The Effective Date that may be selected as filter criteria for the report. |
Fiscal Year | The Fiscal Year that may be selected as filter criteria for the report |
Fiscal Period | The Fiscal Period that may be selected as filter criteria for the report. |
Group by | Used to group the report by Asset Class |
Group by Institution type | The Group By Institution Type that may be selected as filter criteria for the report. |
Group individual Institutions | The Group Individual Institutions that may be selected as filter criteria for the report. |
Institution | The institution responsible for filing the report |
Sort by | Order of which the items are sorted by |
Asset Item physical condition | Users need to select available asset item physical condition to generate the report. |
Act Auction of Assets
Overview
This report allows us to make the generation of the minutes of the selected auction, showing the goods were awarded.
Navigation
Assets ► Asset Reports ► Act Auction of Assets
Act Auction of Assets Report screen Field
| Field | Description |
| Instution | Institution used as a filter criteria for this report. |
| Mode Auction | Mode Auction used as a filter criteria for this report. |
| Register Of Auction | Register Of Auction used as a filter criteria for this report. |
Act Of Asset Item On Custody Report
Overview
Shows the list of assets assigned to an employee. The report contains basic information of each Asset such as ID, Short Description, Brand, Type (Capitalized, Expensed, CIP, etc), Bar Code, etc.
Navigation
Assets ► Asset Reports ► Act Of Asset Item On Custody Report
Act Of Asset Item On Custody Report screen Field
| Fields | Description |
| Employee | Lookup to select Employee as filter criteria for this report. |
| Institution | Filter to select Institution hierarchy for this report. |
Asset Transaction per Asset Detailed
Overview
This report shows information related with the transactions history of an Asset.
Navigation
Assets ► Asset Reports ► Asset Transaction per Asset Detailed
Asset Transaction per Asset Detailed screen Fields
| Fields | Description |
| Transaction Origin | The Transaction Origin that may be selected as filter criteria for the report. |
| Transaction Status | The Transaction Status that may be selected as filter criteria for the report. |
| Asset Origin ID | Asset Origin ID that may be selected as filter criteria for the report. |
| From Date | From Date that may be selected as filter criteria for the report |
| To Date | To Date that may be selected as filter criteria for the report. |
| Asset Type | The Asset Item Type that may be selected as filter criteria for the report. |
| Asset Institution | The Institution that may be selected as filter criteria for the report. |
| Asset Warehouse Institution | Asset Warehouse Institution that may be selected as filter criteria for the report. |
| Asset Region | The Region that may be selected as filter criteria for the report. |
| Asset Class | The Asset Class that may be selected as filter criteria for the report |
| Asset Transaction ID | Asset Transaction ID that may be selected as filter criteria for the report |
| Asset Item | Lookup to select one or more asset items as filter criteria |
| Transaction Type | The report of Asset Transaction per Asset Detailed by asset transaction type may be sorted/narrowed down by selecting Vendor(s) as a filter criteria, limiting the output data. |
Barcode File Report
Overview
Download bar code corresponding to the Asset Item in a text format (.txt) document.
Navigation
Assets ► Asset Reports ► Barcode File Report
Barcode File Report screen Fields
| Fields | Description |
| Institution | Lookup to select Institution as filter criteria for the report. |
| Warehouse | Lookup to select Warehouse as filter criteria for the report. |
| Employee | Lookup to select Employee as filter criteria for the report. |
| Asset CLass | Lookup to select Asset Class as filter criteria for the report. |
| Item | Lookup to select Item as filter criteria for the report. |
| Barcode | Barcode that may be selected as filter criteria for the report. |
| Region | Lookup to select Region as filter criteria for the report. |
| Asset Item Tag | Asset Item Tag From and To filter criteria for the report. |
INJUPEMP Reports
Inventory Sheet Report
Overview
| Fields | Description |
| Employee | Look up button, Allows user to select employee. |
Other Reports
Catalogue Item Classification List Report
Overview
This report shows the Classification List of the Catalogue Item. It can be by Category or Class because the system has these two types of classification. The report contains the following information of each Classification Item: ID, Name, and Level. The report can be filtered by Level, this allows to the user to choose until what level he/she wants to include in the report.
An example of the report is shown below.
Navigation 
Definition of Report Fields
The Catalogue Item Classification List Report includes the following fields:
| Report Fields | Description |
| 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 |
| Type | The type that the Catalogue Item Classification List Report is designated to. For example, this report is defined by category |
| Sort By | Used to sort the report by Category ID (upward) |
| Category ID | The identification number of the category |
| Category Short Description | The description of the assets in the inventory category |
| Level | The level of functions associated and attached to a hierarchy of connected items |
Generation of the Report
The Catalogue Item Classification List Report shows the Classification List of the Catalogue Item.
To GENERATE this report, follow the steps below:
Navigation
The Catalogue Item Classification List Report includes the following filter criteria available for the report:
- Group By: Select a Group By value from the drop-down menu
- Level: The level of functions associated and attached to a hierarchy of connected items
- Sort By - Click the
, 
,
, 
icons to add and remove filter criteria to / from the selected list and click the 
, 
, 
, 
icons to move the items in the selected list up and down to put them in the desired order of appearance - Sort the Catalogue ID by the preferred ascending and descending order using the red arrow icon.
If all filter criteria are left blank, all Levels will be included in the Report.
The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the 
, 
, 
, 
, and 
icons.
Catalogue Item By Priority Report
Overview
This report shows a list of the Catalogue Items grouped by Priority (High, Medium, Low). It contains the following information of each Catalogue Item: Catalogue Item ID, Item Short Description, Item Type (Good or Service), Unit of Measure – UOM, Stock Item (Yes or No), Item Class, and Default Account. The following filters are available: Priority, Item Type, Stock Item, and Item Class.
An example of the report is shown below.
Navigation 
Definition of Report Fields
The Catalogue Item By Priority Report includes the following fields:
| Report Fields | Description |
| 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 |
| Filter Criteria | Filter Criteria as entered under the Catalogue Item By Priority Report |
| Sort By | Used to sort the report by Priority (downward) and Catalogue ID (upward) |
| Priority | The level of importance of a specific report |
| Number of Items | The number of asset items listed in a specific report |
| Cat. Item ID | The identification number of the category item |
| Short Description | The description of the asset item |
| Type | The type of inventory item. For example, a good or a service |
| UOM | The classification for measurement of the catalogue item |
| Stock | Defines whether an inventory item is or is not in stock (Yes if in stock, No if not in stock) |
| Item Class | Defines basic characteristics of the inventory item |
| Default Account | If an element is defined in the object segment of the chart of accounts, this code will be used as part of the coding block when issuing a purchase order or purchase requisition that includes this particular item |
Generation of the Report
The Catalogue Item By Priority Report shows a list of the Catalogue Items grouped by Priority (High, Medium, Low).
To GENERATE this report, follow the steps below:
Navigation
The Catalogue Item By Priority Report includes the following filter criteria available for the report:
- Priority - Click the
, ,
, icons to add and remove priority definitions to / from the selected list. - Stock - Click the stock checkmark to define whether the catalogue item is in stock or not in stock.
- Item Type - Select an Item Type from the drop-down menu.
- Item Class - Item Class unit (optional parameter) that can be selected using the Lookup icon
, and Find icon 
to retrieve the Item Class unit. If selected, the report will include the selected Item Class unit and all Item Class units below the selected unit. Refer to Item Class for more information. - Sort By - Click the , ,, icons to add and remove filter criteria to / from the selected list and click the , , , icons to move the items in the selected list up and down to put them in the desired order of appearance
- Sort the Cat. Item ID, Short Description, Item Type, UOM, Stock, Item Class, and Default Account by the preferred ascending and descending order using the red arrow icon.
If all filter criteria are left blank, all Stocks, Item Types, and Item Classes will be included in the Report, as well as the Item Classes allowed by the report user security profile.
The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.
Material Dispatch Report
Overview
This report displays a list of the Material Items (Inventory Items) dispatched by Warehouse Suppliers to Institution Units. It contains information of each Dispatched Item such as Dispatch Order ID, Catalogue Item ID, Item Short Description, Quantity, Total Cost, Dispatch Order Status, Issue Date, Warehouse Supplier, and Institution Unit to Deliver
Navigation
Inventories ► Reports ► Other Reports ► Material Dispatches
Material Dispatches Report Filter Fields
Field | Description |
Warehouse Supplier | Users can lookup and select a Warehouse Supplier as filter criteria for the Material Dispatches Report. |
Institution Unit to Deliver | Users can lookup and select an Institution Unit to Deliver as filter criteria for the Material Dispatches Report. |
Catalogue Item | Users can lookup and select a Catalogue Item as filter criteria for the Material Dispatches Report. |
Dispatch Order | Users can lookup and select a Dispatch Order as filter criteria for the Material Dispatches Report. |
Delivery Responsible Employee | Users can lookup and select a Delivery Responsible Employee as filter criteria for the Material Dispatches Report. |
Employee who Received | Users can lookup and select an Employee who Received as filter criteria for the Material Dispatches Report. |
Request ID | Users can lookup and select a Request ID as filter criteria for the Material Dispatches Report. |
Dispatch Order Status | Filter Criteria to filter the report by the Dispatch Order status of the items. |
Issue Date | Users can use begging and end date that the Inventory issue was made. |
Sort By | Click the “Move Selected Item”, “Move All Item”, “Remove Selected Item”, “Remove All Item” icons to add and remove filter criteria to / from the selected list and click the “Move Selected Item to Top of List”, “Move Selected Item up one in List”, “Move Selected Item down one in List”, “Move Selected Item to Down of List” icons to move the items in the selected list up and down to put them in the desired order of appearance. |
Dispatch Order | By the preferred ascending and descending order using the Red Arrow icons. |
Material Requests Status Report
Overview
This report shows the status of the Material Requested to a Supplier Warehouse. It contains information of each Request such as Request ID, Status, Issue Date, Priority, Quantity of Items Required, Quantity of Items Fully Supplied, Quantity of Items Not Fully Supplied, Institution Unit that requires, etc.
Some filters are available such as Request ID, Status (Delivered, In Supply Process, etc), Issue Dates Range, Priority, Institution Unit that requires, etc.
This report is oriented to the Warehouse Responsible or Warehouse Supervisors.
An example of the report is shown below.
Navigation 
Definition of Report Fields
The Status Material Requested includes the following fields:
| 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 |
| Filter Criteria | Filter Criteria as entered under the stAtus material requested. |
| Sort by | Used to sort the report by Request ID (downward) |
| Request ID | Identification number of the request made. |
| Replenishment | Enables the responsible warehouse to automatically generate the G/S request from Inventory Items. |
| Status | A selectable list is available for required statuses. |
| Issue Date | Date the request is issued. |
| Max Required Date | The maximum required date to receive the goods/services. |
| Priority | A selectable list is available which includes three priorities: Low, Medium and High |
| Quantity of Item | Quantity of Required, Fully Supplied and Not Fully Supplied requested materials |
| Required Institution Unit | This is the institution unit that requires the goods/services. |
| Page | Page number of report. |
Generation of the Report
This report shows the status of the Material Requested to a Supplier Warehouse.
To GENERATE, follow the steps below:
Navigation
The Asset Count Variances Report includes the following filter criteria available for the report:
- Replenishment: If checked, the responsible warehouse automatically generates the G/S request from Inventory Items.
- Issue Date From: The date the generation report is being issued from (optional) can be selected from the Calendar icon
. - Issue Date To: The date the generation report is being issued to (optional) can be selected from the Calendar icon.
- Max Req Date From: The maximum required date from (optional) can be selected from the Calendar icon.
- Max Req Date To: The maximum required date to (optional) can be selected from the Calendar icon.
- Request ID: The request ID (optional) can be selected using the Lookup icon , and Find icon to retrieve the request ID. Refer to Goods/Services Request for more information.
- Supplier Warehouse: The supplier warehouse (optional) can be selected using the Lookup icon , and Find icon to retrieve the supplier warehouse. Refer to Institution for more information.
- Institution Unit: The institution unit (optional) can be selected using the Lookup icon , and Find icon to retrieve the institution unit. Refer to Institution for more information.
- Priority: can be selected from the Drop Down Menu.
- Status: can be selected from the Drop Down Menu.
- Sort By - Click the , ,, icons to add and remove filter criteria to / from the selected list and click the , , , icons to move the items in the selected list up and down to put them in the desired order of appearance
- Sort the different Levels by the preferred ascending and descending order using the Red Arrow icons
.
If all filter criteria are left blank, all Levels will be included in the Report.
The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the , , , , and icons.
Philippines Reports
Asset Disposal Summary Report
Overview
This report shows summary of disposed asset.
Navigation
Assets ► Asset Reports ► Philippines Reports ► Asset Disposal Summary Report
Asset Disposal Summary Report Screen fields
| Fields | Description |
| Fiscal Year | Users selects Fiscal Year to filter transaction period. This filter parameter is mandatory. |
| From Date | From date filter, specifies the starting date of transactions to filter. |
| To Date | To date filter, specifies the end date of transactions to filter. |
| Organization | Allows selection of concept in the "Organization" segment of CoA and element code for the concept selected, mandatory filter criteria. |
| Transaction Class | Fixed filter value, users can not change the filter parameter. |
| Asset Item Tab | Lookup function for Multiple asset item bar code selection. Non mandatory filter. |
| Asset Transaction Type Tab | Lookup function for Multiple asset transaction type selection. Non mandatory filter. |
Asset Item Custody Transfer Log Report
Overview
This report shows custody transfer of an asset to number custodian over a particular period of time.
Navigation
Assets ► Asset Reports ► Philippines Reports ► Asset Item Custody Transfer Log Report
Asset Item Custody Transfer Log Report Screen fields
| Fields | Description |
| Fiscal Year | Users select Fiscal Year as filter criteria for the transfer transactions. |
| From Date | From date filter, specifies the starting date of transfers to filter. |
| To Date | To date filter, specifies the end date of transfers to filter. |
| Organization | Allows selection of concept in the "Organization" segment of CoA and element code for the concept selected. |
| Transaction Class | Fixed filter criteria, users can not change the value of this filter. |
| Asset Item Tab | Multiple selection of asset items to take into consideration, non mandatory filter. |
| Asset Transaction Type Tab | Multiple selection of asst transaction types (Bar code of the assets), non mandatory filter. |
Asset Item Disposal Log
Overview
This report shows asset item dispossal report log.
Navigation
Assets ► Asset Reports ► Philippines Reports ► Asset Item Disposal Log
Asset Item Disposal Log Report Screen fields
| Fields | Description |
| Fiscal Year | User selects Fiscal Year. This parameter is mandatory and display only. |
| From Date | From date filter |
| To Date | To date filter |
| Comment | Any comment to add in the output report. |
| Organization | Mandatory - Allow Selection of concept in the "Organization" Segment of COA and element code for the concept selected. |
| Transaction Class | Fixed filter, user can not change. |
| Asset Item Tab | Non-Mandatory Multiple selection |
| Asset Transaction Type Tab | Non-Mandatory Multiple selection (Bar code of the assets) |
Biological Assets Property Card Report
Overview
Record and monitor biological asset/s on a quarterly basis by the Biological Asset/s Caretaker or Officer in-charge for each type of biological asset.
Navigation
Assets ► Asset Reports ► Philippines Reports ► Biological Assets Property Card Report
Biological Assets Property Card Report screen Fields
| Fields | Description |
| Fiscal Year | By default filter presents current year, users are allowed to select perivous years from the dropdown. |
| Fiscal Period | Default current Period. Allows users to select previous Periods from dropdown. |
| Institution | Allow users to filter asset items that belong to a particular RESP_CENTER, including roll ups to its parent institution unit, agency, and department. Mandatory and single selection filter criteria. |
| Asset Class | Asset Class that may be used as filter criteria for this report. |
| Asset Item Status | Asset Item Status that may be used as filter criteria for this report. |
Construction In Progress Ledger Card Report
Overview
Details of the Asset being constructed maintained by the Property Custodian to view the record of the construction cost and other information about the asset.
Navigation
Property Plant and Equipment ► Asset Reports ► Philippines Reports ► Construction In Progress Ledger Card Report
Construction In Progress Ledger Card Report Screen Fields
| Fields | Description |
| Institution | Look up. Mandatory - Allow the user to filter Asset item that belongs to a particular RESP_CENTER |
| Asset Class | Look up. Mandatory - Allow user to select the Asset Class. |
| Purchase Order | Mandatory - Allow the user to select all Purchase Order realated to Generic Sub-ledger. |
| Generic Subledger Register | Mandatory - Allow the user to select from Generic Sub-ledger |
| Fund Cluster | Look up. Mandatory - Concept Fund Cluster of the segment Finding Source. |
FIXED ASSET/ ITEM ACCOUNTABILITIES REPORT
Overview
This report shows Details of all the asset by assignment to a division or employee.
Navigation
Assets ► Asset Reports ► Philippines Reports ► Fixed Asset or Item Accountabilities
Fixed Asset or Item Accountabilities Report screen Field
| Fields | Description |
| Fiscal Year | Default value is current Fiscal Year. Allows users to select previous Fiscal Years from dropdown. Mandatory filter parameter. |
| Responsibility Center | Responsibility Center used as filter criteria for this report. |
| Comment | User comments related to report. These are include din the comment section of the report. |
| Employee | To select one or more asset employees as filter criteria. |
Inventory And Inspection Report Of Unserviceable Property
Overview
The IIRUP is a report prepared by the Supply and/or Property Unit as basis to record dropping from the books the unserviceable properties carried in the PPE accounts.
Navigation
Property Plant and Equipment ► Asset Reports ► Philippines Reports ► Inventory And Inspection Report Of Unserviceable Property
Registry of Heritage Asset Report Screen Fields
| Fields | Description |
| Fiscal year | Default current Year. Allow user to select previous Year from dropdown. Mandatory |
| Entity Name | Allow the user to filter Asset item that belongs to a particular RESP_CENTER including roll ups to its parent institution Unit, Agency, and Department. Mandatory. Single selection |
| Fund Cluster | From Concept Fund Cluster of the segment Finding Source of the UACS. Single Selection |
| Comment | User comments related to report. |
Property Acknowledgement Receipt Issuance Control Report
Overview
To show the details of issuance of PAR to the Employees.
Navigation
Property Plant and Equipment ► Asset Reports ► Philippines Reports ► Property Acknowledgement Receipt Issuance Control Report
Property Acknowledgement Receipt Issuance Control Report Screen Fields
| Fields | Description |
| Fiscal Year | Default current Year. Allow user to select previous Year from dropdown. Mandatory |
| From Date | From date filter |
| To Date | To Date Filter |
| Entity Name | Allow the user to filter Asset item that belongs to a particular RESP_CENTER including roll ups to its parent institution Unit, Agency, and Department. Mandatory. Single selection |
| Comment | User comments related to report. |
| Custody Transaction | To select one or more Custody Transaction as filter criteria. |
Quarterly Report On Biological Assets Report
Overview
The purpose of this report
1. To report the biological asset/s on a quarterly basis by the Biological Asset's Caretaker or Officer in-charge for each type of biological asset.
2. It shall be prepared quarterly by fund cluster.
Navigation
Property Plant and Equipment ► Asset Reports ► Philippines Reports ► Quarterly Report On Biological Assets Report
Quarterly Report On Biological Assets Report Screen Fields
| Fields | Description |
| Fiscal Year | Current Fiscal Year when the asset item is created. Default value is the current year. |
| Fiscal Period | Current Fiscal Period when the asset item is created. Default value is the current period. |
| Entity Name | Display the Institution Description of the institution from Employee profile |
| Asset Class | Allows user to select Asset class from the look up functionality. |
| Date | Date selection. (Only for report display, no relation with asset item) |
| Quarter | 1st Quarter, 2nd Quarter, 3rd Quarter, and 4th Quarter- dropdown Selection. |
| FUND CLUSTER | Allow user to select from Employee entity with employees having the institution same with the employee profile of the user generating the report. |
Registry of Heritage Asset - Summary Report
Overview
Monthly report to summarize the cost of specific Heritage Assets.
Navigation
Property Plant and Equipment ► Asset Reports ► Philippines Reports ► Registry of Heritage Asset - Summary Report
Registry of Heritage Asset - Summary Report Screen Fields
| Fields | Description |
| Fiscal Year | Default current Year. Allow user to select previous Year from dropdown. Mandatory |
| Fiscal Period | Default current Period. Allow user to select previous Periods from dropdown. Mandatory |
| Entity Name | Allow the user to filter Asset item that belongs to a particular RESP_CENTER including roll ups to its parent institution Unit, Agency, and Department. Mandatory. Single selection |
| Fund Cluster | From Concept Fund Cluster of the segment Finding Source of the UACS. Single Selection |
| Comment | User comments related to report. |
Registry of Heritage Asset Report
Overview
The purpose of this report is to Record and monitor heritage assets owned by the agency/entity.
Navigation
Property Plant and Equipment ► Asset Reports ► Philippines Reports ► Registry of Heritage Asset Report
Registry of Heritage Asset Report Screen Fields
| Fields | Description |
| Fiscal year | Default current Year. Allow user to select previous Year from dropdown. Mandatory |
| Fiscal Period | Default current Period. Allow user to select previous Periods from dropdown. Mandatory |
| Institution | Allow the user to filter Asset item that belongs to a particular RESP_CENTER including roll ups to its parent institution Unit, Agency, and Department. Mandatory. Single selection |
| Fund Cluster | From Concept Fund Cluster of the segment Finding Source of the UACS. Single Selection |
| Nature Of Heritage Asset | Allow user to select the subobject from concept GL |
Report on the Physical Count of Property, Plant and Equipment
Overview
Presents the physical count of PPE by type; such as land, land improvements, infrastructure, building and other structures, machinery and equipment, transportation equipment, furniture, fixtures and books, etc. which meet the filtered criteria.
Navigation
Property Plant and Equipment ► Asset Reports ► Philippines Reports ► Report on the Physical Count of Property, Plant and Equipment
Report on the Physical Count of Property, Plant and Equipment Screen Fields
| Fields | Description |
| Fiscal Year | Users selects Fiscal Year, this parameter is mandatory. |
| Asset Class | Asset Class filter. Mandatory single selection filter. |
| Asset Count Request | Asset Count request filter. Mandatory single selection filter. |
| Fund Element | Non mandatory single selection filter. |
| Comment | User edited comment to be included in the report. |
Waste Material Report
Overview
The Waste Material Report is used by the Supply and/or Property Custodian to report all waste materials previously taken up in the books of accounts as assets or in custody.
Navigation
Property Plant and Equipment ► Asset Reports ► Philippines Reports ► Waste Material Report
Waste Material Report Screen Fields
| Fields | Description |
| Fiscal Year | User selects Fiscal Year. This parameter is mandatory. |
| From Date | Start date of records to filter. |
| To Date | End date of records to filter. |
| Organization | Allows selection of concept in the "Organization" Segment of CoA and element code for the concept selected. Mandatory filter criteria. |
| Multi Fund Concept | Allows selection from concept "Fund Cluster" from "Fund" Segment of CoA. Mandatory multiple selection filter. |
Recapitulation Reports
Overview
The Recapitulation reports are used to summarize the main points of the evolutionary process of assets during their growth and (if applicable) regression.
Navigation
Assets ► Asset Reports ► Recapitulation Report
Recapitulation Report screen fields and Tabs
Field | Description |
Asset Class | The Asset Class selected as a filter criteria for the report. |
Existing Before | The Existing before Date selected as a filter criteria for the report. |
From Date | The From Date selected as a filter criteria for the report |
To Date | The To Date selected as a filter criteria for the report. |
Comments | Comments that may be entered with the report |
Sort By | Filter criteria for the report |
No | Serial Number |
Institution | The Institution that may be selected as filter criteria for the report |
Description Item | Name of the Asset Class. |
Existing Before | The total number of assets for a certain asset class before the defined date. |
Existing Between | The total number of assets for a certain asset class between the defined dates. |
Total | Total number of Assets. |
Condition | Total number of assets for the selected Asset Physical condition and they are: In use, In Stock, Disposed, and Being Repaired and for sale. |
Planning to purchase in | Quantity of assets planned to purchase in a given year |
Receipt Of Adjudication Report
Overview
Monthly report to summarize the cost of specific Heritage Assets.
Navigation
Assert ► Asset Reports ► Receipt Of Adjudication Report
Receipt Of Adjudication Report Screen Fields
| Fields | Description |
| Institution | Lookup function to select Institution related to receipts as filter criteria. |
| Register Of Auction | Lookup function to select Register Of Auction as filter criteria. |
| Mode Auction | Dropdown list allows users to select a Mode Auction as filter criteria. |
| Customer | Lookup function to select a Customer related to the receipt as filter criteria. |
| Asset Item | Lookup function to select Asset Item as filter criteria. |
| Catalogue Item | Lookup function to select Catalogue Item as filter criteria. |
| From Date | Start date of the receipts to filter. |
| To Date | End date of the receipts to filter. |
| Registration of Bid | Lookup function to select Registration of Bid as filter criteria. |
Sales Act Report
Overview
The purpose of this report is to give a support of the sale process to the customer,
Navigation
Asset ► Asset Reports ► Sales Act Report
Sales Act Report Screen Fields
| Fields | Description |
| Institution | It shows the institution ID for filtering. |
| Register Of Auction | This feature keeps track of the auction to be recorded within institution. |
| Asset Item | Asset item used as filter criteria. |
| Catalogue Item Id | This feature keeps track of the auction to be recorded within institution. |
| Customer | It shows the customer related to the report filter. |
| Vendor | The report of sales act by vendor may be sorted/narrowed down by selecting Vendor(s) as a filter criteria, limiting the output data. |
| Mode Auction | It shows the Mode Auction related to the report filter. |
| From Date | The Date From that may be selected as filter criteria for the report. |
| To Date | The Date To that may be selected as filter criteria for the report. |
| Asset Transaction | The report of sales act by asset transaction may be sorted/narrowed down by selecting Vendor(s) as a filter criteria, limiting the output data. |
SriLanka Reports
Asset Class Mandatory Additional Fields Check Up Report
Overview
Allow the Data Import Client assigned users to check asset item additional fields
Navigation
Assets ► Asset Reports ►SriLanka Reports ► Asset Class Mandatory Additional Fields Check Up Report
Asset Class Mandatory Additional Fields Check Up Report screen Field
| Fields | Description |
| Fiscal Year | Fiscal year used as filter criteria for this report. |
| Fiscal Period From | Fiscal Period From used as filter criteria for this report. |
| Fiscal Period To | Fiscal Period To used as filter criteria for this report. |
| Institution | Institution used as filter criteria for this report. |
| Additional Fields | Check box to filter additional fields. |
| Asset Class | Tab to seletone or more asset class as filter. |
Board Of Survey Recommendations Report
Overview
The Chief Accounting Officer in constitution with Heads of Departments will appoint one or more verification boards to carry out verifications on Fixed Assets. Board of Survey should submit this report to the Chief Accounting Officer as soon after closure of the financial year indicating the existence and condition of each asset item under different classes of assets summary of which should be submitted along with the Annual Appropriation Account.
Navigation
Assets ► Asset Reports ►SriLanka Reports ► Board Of Survey Recommendations Report
Board Of Survey Recommendations Report screen Field
| Fields | Description |
| Asset Item | Asset item id used as filter criteria for this report. |
| Institution | Institution used as filter criteria for this report. |
Work In Progress Status Report
Overview
This report shows the details of all projects which is in progress. Users can use report filters to generate the report as per their requirements.
A screenshot of the Work In Progress Status Report is available here. Image is shown as reference material; position and names for labels, fields and buttons are subject to the parameter, rendering control configuration and the installed revision.
Users access Work In Progress Status Report from within the menu through this navigation path: Assets ► Assets report ► Sri Lanka Reports ► Work In Progress Status Report.
Filters
The following table lists and describe all filter fields for the Work In Progress Status Report in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.
| Field | Description |
|---|---|
| Fiscal Year | It lists the fiscal year and allows users to select it as a report filter. This is a mandatory field for the report. The current fiscal year is set as the default value. |
| Fiscal Period | It lists the fiscal period and allows users to select it as a report filter. This is a mandatory field for the report. The January is set as the default value. |
| Coding Block | The lookup button lists all the coding block and allows to choose a coding block as a filter. User can enter it manually. |
Visible Fields
A sample of the report is available here.The following table lists and describes all visible fields for the Work In Progress Status Report, in their default order. Note that some fields depend on Filters selection and the language of the report depends on the configuration of the system.
| Field | Description |
|---|---|
| No. | The sequential number of the report items. |
| JV Reference | Journal voucher ID of the related asset items. |
| Asset Item Id | Asset item ID. |
| Work Completed Coding Block | Coding block for work completed. |
| Work Completed Description | Description for work completed. |
| Transferred to Fix Assets Coding Block | Coding block for the transferred to fixed assets. |
| Transferred to Fix Assets Description | Description for the transferred to fixed assets. |
| Amount | Debit domestic amount from the related Journal Voucher. |
| Total work completed and transferred to fixed assets | Grand total amount. |
Buttons
The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Work In Progress Status Report feature.
| Button Image | Description |
|---|---|
 | The pdf button allows users to generate the report in the pdf format. |
 | The Excel button allows users to generate the report in the excel format. This format is compatible with Microsoft Office 97-2003 or higher version. |
 | The Excel button allows users to generate the report in the excel format. This format is compatible with Microsoft Office 2003 or higher version software. |
 | This ODS button allows users to generate the report in ODS format. This format is compatible with spreadsheet software such as Microsoft Office, Open Office or Libre Office. |
 | This RTF button allows users to generate the report in RTF format. |
 | The Word button allows the users to generate the report in word format. This format is compatible with Microsoft Office 97-2003 or higher version. |
 | This ODT button allows users to generate the report in ODT format. This format is compatible with word processing software such as Microsoft Office, Open Office or Libre Office. |
 | The Lookup tool allows users to browse and select existing items. |
Statement Of Non Current Assets Report
Overview
Information on non-current assets are listed, sorted and generated as per filter criteria set in this screen. All relevant information can be generated in this report specific for non-current assets.
Navigation
Assets ► Asset Reports ► Statement Of Non Current Assets Report
Statement Of Non Current Assets Report screen Fields
Field | Description |
Asset Class | Asset Class selected from lookup option. |
Effective Date From | Starting Effective Date selected from calendar button. |
Effective Date To | End Effective Date selected from calendar button. |
Original value From | Starting range of Original value from is entered in this field. |
Original value To | End range of Original value from is entered in this field. |
Book value From | Starting range of book value is entered in this field. |
Book value To | End range of book value is entered in this field. |
Region | Region to be selected from lookup option. |
Physical Condition | Physical Condition selected from drop down box. |
Group Individual Institutions | Whether Individual Institutions is grouped, is mentioned by checking this field. |
Group By Institution Type | Whether Institution Type is grouped, is mentioned by checking this field. |
Institution | Institution is selected for filtering records. |
Asset Item Group | Asset Item Group is selected for filtering Item Group. |
Tag Barcodes Of Asset Items Report
Overview
Reports on Tag barcode of Asset Items are generated through this screen.
Navigation
Assets ► Asset Reports ► Tag Barcodes Of Asset Items Report
Tag Barcodes Of Asset Items Report screen Fields
Field | Description |
Type Of Barcode | Type of Barcode is selected from drop down box. |
Unit | Unit of measurement is selected from drop down box. |
Width | Width of Tag Barcode is entered in this field. |
Height | Height of Tag Barcode is entered in this field. |
Warehouse | Warehouse where the Asset item is located is selected from lookup button. |
Asset Class | Asset Class to which the Asset Item belongs is selected from lookup button. |
Catalogue Item | Relevant Catalogue Item is selected from lookup button. |
Item Category | Item Category to which Asset Item belongs is selected from lookup button. |
Bar Code | Bar Code of Asset Item is entered in this field. |
Serial Number | Serial Number of Asset Item is entered in this field. |
Region | Region of Asset Item is selected from lookup button. |
Start Date In Use: From Date | Initial date of Start Date In Use is selected from calendar button. |
Start Date In Use: To Date | End date of Start Date In Use is selected from calendar button. |
Last Count Date: From Date | Intial date of Last Count Date is selected from calendar button. |
Last Count Date: To Date | End date of Last Count Date is selected from calendar button. |
Tag Barcodes Sheets Of Asset Items Report
Overview
Tag barcode sheets for Asset Items are generated through this screen.
Navigation
Assets ► Asset Reports ► Tag Barcodes Sheets Of Inventory Items Report
Tag Barcodes Sheets Of Asset Items Report screen Fields
Field | Description |
Type Of Barcode | Type of Barcode is selected from drop down box. |
Unit | Unit of measurement is selected from drop down box. |
Warehouse | Warehouse to which the Asset Item belongs is selected from lookup button. |
Asset Class | Asset Class to which the Asset Item belongs is selected from lookup button. |
Catalogue Item | Catalogue Item is selected from lookup button. |
Item Category | Item Category is selected from lookup button available for this field. |
Bar Code | Bar Code is entered in this field for report generation purpose. |
Serial Number | Serial number is mentioned in this field. |
Region | Region is selected from lookup option available for this field. |
Start Date in Use: From Date | Intial date of Start Date In Use is selected from calendar button. |
Start Date in Use: To Date | End date of Start Date In Use is selected from calendar button. |
Last Count Date: From Date | Intial date of Last Count Date is selected from calendar button. |
Last Count Date: To Date | End date of Last Count Date is selected from calendar button. |
Tag Barcodes Sheets Of Inventory Items Report
Overview
Tag barcode sheets for Inventory Items are generated through this screen.
Navigation
Assets ► Asset Reports ► Tag Barcodes Sheets Of Inventory Items Report
Tag Barcodes Sheets Of Inventory Items Report screen Fields
Field | Description |
Type Of Barcode | Type of Barcode is selected from drop down box. |
Warehouse | Warehouse to which the Inventory Item belongs is selected from lookup button. |
Item Class | Inventory Item Class to which the Inventory Item belongs is selected from lookup button. |
Catalogue Item | Catalogue Item is selected from lookup button. |
Catalogue Item Category | Item Category is selected from lookup button available for this field. |
Bar Code | Bar Code is entered in this field for report generation purpose. |
Requires Lot Management | Whether Lot manangement is required, is entered in this field by marking the check box. |
Last Acquisition Date- From Date | Intial date of Last Acquisition Date is selected from calendar button. |
Last Acquisition Date- To Date | End date of Last Acquisition Date is selected from calendar button. |
Last Count Date: From Date | Intial date of Last Count Date is selected from calendar button. |
Last Count Date: To Date | End date of Last Count Date is selected from calendar button. |
Tag Barcodes Sheets Of Storage Bins Report
Overview
Navigation
Assets ► Assets Reports ► Tag Barcodes Sheets Of Storage Bins Report
Tag Barcodes Sheets Of Storage Bins Report screen Fields
Field | Description |
Type Of Barcode | Type of Barcode to be selected from dropd down box for filtering records. |
Warehouse | Warehouse to which the stores/ inventory relates, to be selected from lookup button. |
Row | Row where the stores/ inventory is located. |
Stack | Stack where the inventory/ stores is located. |
Level | Level of stores. |
Bar Code | Bar Code of the iventory item. |
Storage Bin Type | Storage Bin Type to be selected from drop down box. |
Storage Unit Type | Storage Unit Type to be selected from drop down box. |
Storage Section | Storage section to be selected from lookup button. |