Guarantees by SOE Report

Overview

This report retrieves information on all debt instruments that have been guarantees. It provides different filters which help users generate the report as per their requirements.

A screenshot of the Guarantees by SOE Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.

Users access Guarantees by SOE Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees by SOE Report.

Filters

The following table lists and describe all filter fields for the Guarantees by SOE 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.

FieldDescription
Creditor AgencyIt allows users to select the creditor agency using the lookup feature.
StatusIt lists and allows users to select the guarantee status from the list as filter. A value for this field is mandatory. Open status is set as default value.
Issue DateIt allows to enter the guarantees issue date using the date picker.
Expiry DateIt allows to enter the guarantees expiry date using the date picker.
CommentUsers can enter a comment for the report.
Sort ByIt provide sorting filter for the report.

 

Visible Fields

The following table lists and describes all visible fields for the Guarantees by SOE Report, in their default order. Note that some fields depend on Filters selection. The language of the report depends on the configuration of the system.

FieldDescription
Report DateThe current system date appears on the report.
Report TimeThe current system time appears on the report.
User CodeThe user code who generates the report.
Issue DateThe issue date.
Fiscal YearFiscal year from filter criteria.
Sequence NumberSequential row number.
Creditor Agency (SOE)The creditor agency name.
Name of Bank/InstitutionThe name of the bank/institution associated with the creditor agency.
Rs. Mn.Sum of guarantee issued amount in millions.
Total Rs. Mn.Sum of guarantee issued amount in millions. It is grouped by creditors agency.
Total Rs. Mn. AmountIt is sum of all Rs. Mn.

 

Buttons

The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Guarantees by SOE Report feature.

Button ImageDescription
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.