Sub Ledgers

Accountable Advances

Overview

This entity describes the list of accountable advances given by the Organization. It keeps track of the outstanding balance of the advance by tracking all payments (debits) and recoveries (credits).

Navigation

General Ledger ► Sub Ledgers ► Accountable Advances► Accountable Advance

Accountable Advances Screen Fields

Fields	Description
Code	Unique identification code. System generated or manually entered by the user depending on the system parameter.
Workflow Status	The Workflow Process Status of the voucher automatically generated and updated.
Currency	Indicates the transaction currency for the Advance.
Exchange Rate	The exchange rate for the chosen currency.
Advance Type	Indicates the Advance Type for the Accountable Advance.
Coding Block	Coding Block for the Accountable Advance.
Accounting Office	Accounting Office Code By default use current employee institution
Purchase Order	Only enabled if Advance Type is linked to Purchase Order and will allow the user to select respective Purchase Order.
PO Advance Limit Percentage	Only enabled if Purchase Order is selected. This field is to define advance limit, means the percentage of the PO Total Amount that can be provided as an Advance to the Supplier.
Advance Status	Indicates if the Advance is Open and transactions can be posted against it, or it is closed and no transactions ca be posted against it.
Holder	Refers to the Vendor to whom the advance will be issued.
Domestic Advance Limit Amount	This is to define the maximum limit of money to be advanced. If the advance is linked to a PO, this amount must be less than the PO amount.
Pay Advance In Single Installement	If Advance Type is True, then this attribute is true and is disabled (user cannot change). If Advance Type is False, then this attribute is enabled (user can change it), default value is False.
Domestic Paid Amount	This is the running total of the amount that has been advance to the holder. System calculated, sum of GL debit entries against the sub-ledger.
Domestic Recovered Amount	This is the running total of the recovered amount of the advance. System calculated, sum of GL credit entries against the sub-ledger.
Domestic OutStanding Balance Amount	Calculated/Updated Display Only Field
Created By	System will automatically populate this attribute.
Creation Date	The Accountable Advance created on. This is auto populated by the system.
Approved By	System will automatically populate this attribute.
Approved Date	Timestamp of approval
Language	The language used to enter the description.
Name	Name of the Advance.
Description	Description for the advance.

Advance Transaction Schedule Tab

Advance Transaction Schedule Tab Screen Fields

Fields	Description
Sequence Number	Sequential number of the Advance Schedule.
Transaction Type	Indicates the type of the transaction. Possible values are Payment and Recovery.
Forecast Transaction Date	Non-mandatory. To define the expected transaction date.
Forecast Transaction Amount Domestic	This is the expected transaction amount in domestic currency.
Forecast Transaction Amount Foreign	This is the expected transaction amount. Enabled if Accountable Advance currency = Foreign.
Actual Transaction Date	Indicates the actual transaction date. This is auto populated by the system from the processes.
Actual Transaction Amount Domestic	Indicates the actual transaction domestic amount. This is auto populated by the system from the processes.
Actual Transaction Amount Foreign	Indicates the actual transaction foreign amount. Applicable when the Accountable Advance is in foreign currency. This is auto populated by the system from the processes.
Is Executed	This is auto populated by the system from the processes.

Advance Type

Overview

This Entity defines the types of advances available for the Advance Register. The advance type entity will be used to describe the different types of advances available in the system.

Navigation

General Ledger ► Sub Ledgers ► Accountable Advances► Advance Type

Advance Type screen Fields and Tab

Fields	Description
ID	System generated unique identification code.
Active	This field defines if the Advance Type is active and can be used.
Is Linked to PO	Default is False. If Advance Type is linked to PO, the system will request a PO number when the Advance is posted.
Is Standing Advance	If True the Advance Limit will be validated against the net amount of payments minus recoveries
Advances To Be Process In Single Payment	Default is False. If True the Advance Limit will be validated against the net amount of payments minus recoveries
Name	Indicates the name of the Advance Type.
Description	Long description of the Advance Type.
Advance Offsetting Accounts	Only available if Is Linked to PO is False. List of expressions representing a set of Coding Blocks that can be used to post recoveries of Accountable Advances of this type.

Advance Type offset Accounts Tab

Advance Type offset Accounts Tab Screen Fields

Fields	Description
Serial Number	Unique identifier.
Rule Expression	user can enter different type of rules: List of values, wildcards and range of values.
Description	Short description of the Advance Type

Reports

Sri Lanka Reports

Stores and Commercial Advances Detail Report

Overview

This report shows the original amount for advance, required recovery and balance. Users can use report filters to generate the report as per their requirement.

A screenshot of the Stores and Commercial Advances Detail 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 Stores and Commercial Advances Detail Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Accountable Advances ► Reports ► Sri Lanka Reports ► Stores and Commercial Advances Detail Report.

Filters

The following table lists and describe all filter fields for the Stores and Commercial Advances Detail 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 years and allows users to select a fiscal year as a report filter. The current fiscal year is set as the default value. It is a mandatory field.
Period From	It lists the fiscal periods and allows users to select a fiscal period as a report filter. It is a mandatory field.
Period To	It lists the fiscal periods and allows users to select a fiscal period as a report filter. It is a mandatory field.
Workflow Status	It lists the workflow status and allows users to select it as a report filter. The values are restricted to: Approved Approval Requested Cancelled Created
Advance Status	It lists and allows users to select the advance status from the list as a report filter. It has two value open and close.
Holder Name	It allows to browse and select the holder name using the lookup button.
Accounting Office	It allows to browse and select the accounting office using the lookup button.

Visible Fields

A sample of the report is available here.The following table lists and describes all visible fields for the Stores and Commercial Advances Detail 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
Accountable Advance
Code	Based on the filter criteria the accountable advance id shows in the report.
Holder Name	The account holder name to whom the advance has been issued.
Workflow	Workflow stage of the accountable advance.
Status	The advance status either open or close.
Amount	Domestic advance limit amount.
Advance Payments
Voucher Date	Date of the voucher.
Advance Payments	Advance amount payment detail.
Status	The advance payment status.
Amount	The total domestic amount from expense voucher.
Total expenses against advances
Voucher Date	Voucher date.
Total Expense against Advances	The total expense against the advance.
Amount	The total domestic credit amount.
Unutilized Advance Amount	The actual unutilized advance 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 Stores And Commercial Advances Detail 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.

Travel And Fuel Advances Details Report

Overview

It allows users to generate the detail report of the travel and fuel advance. Users can use report filters to generate the report as per their requirements.

A screenshot of the Travel And Fuel Advances Details 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 Travel And Fuel Advances Details Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Accountable Advances ► Reports ► Sri Lanka Reports ► Travel And Fuel Advances Details Report.

Filters

The following table lists and describe all filter fields for the Travel And Fuel Advances Details 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 years and allows users to select a fiscal year as a report filter.
From Date	The date picker allows users to pick the initial date range for the report as a filter.
To Date	The date picker allows users to pick final date of the range as report filter. it should be within the selected fiscal year and greater than from date.
Advance Type	It lists the advance type and allows users to select it as a report filter. The type should be travel advance & fuel advance.
Workflow Status	Lists the workflow status of the advance and allows users to select it as report filter.The values are restricted to: Approved Approval Requested Cancelled Created
Advance Status	It lists and allows users to select the advance status from the list as a report filter. It has two value open and close.
Holder Name	It allows to browse and select the holder name using the lookup button.
Accounting Office	It allows to browse and select the accounting office using the lookup button.

Visible Fields

A sample of the report is available here.The following table lists and describes all visible fields for the Travel And Fuel Advances Details 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
Accountable Advance
Code	Based on the filter criteria the accountable advance id shows in the report.
Holder Name	The account holder name to whom the advance has been issued.
Workflow	Workflow stage of the accountable advance.
Status	The advance status either open or close.
Amount	Domestic advance limit amount.
Advance Payment
Voucher Date	Date of the voucher.
Advance Payments	Advance payment amount detail.
Status	The advance payment status.
Amount	The total domestic amount from expense voucher.
Total expenses against advances
Voucher Date	It fetches voucher date.
Total Expense Against Advances	Total expense occurred against the allotted advance.
Amount	Total domestic debit amount.
Settlement of Advances
Voucher Date	The date of the voucher.
Settlement of Advances	The calculated settlement amount of advance.
Status	The status of the advance settlement.
Amount	Total domestic credit amount.
Advance To Be Recovered	Grand total amount after calculation.

Buttons

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.
	Allows user to select a date.

Debt Register

BTMS Philippines Reports

Debt Servicing Requirements Report

Overview

This report shows debt servicing requirements for the month, quarter, year at aggregate level or at donor or executing agency level by debt instrument type, based on the debt servicing requirements data. It provides different filters which help users to generate the report as per their requirements.

A screenshot of the Debt Servicing Requirements 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 Debt Servicing Requirements Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► BTMS Philippines Reports ► Debt Servicing Requirements Report.

Filters

The following table lists and describe all filter fields for the Debt Servicing Requirements 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
Report Type	It lists the report type for selecting as a report filter.
Fiscal Year	It lists the fiscal year to select them as report filter. A value for this field is mandatory. The current fiscal year is set as a default filter.
Fiscal Period From	The current fiscal period is set as the initial range by default. Based on the requirement user can select another fiscal period from the list.
Fiscal Period To	The current fiscal period is set as the end range by default. Based on the requirement user can select another fiscal period from the list.
Debt Type	It lists the debt type for selecting as a report filter for the report.
Creditor Agency	It allows selecting the creditor agency using lookup feature as a report filter.
Executing Agency	It allows selecting the executing agency using lookup feature as a report filter.

Visible Fields

The following table lists and describes all visible fields for the Debt Servicing Requirements 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.

Field	Description
Code	Instrument ID.
Description	Description of the Debt Instrument.
Debt Instrument Type	The debt instrument type.
Maturity Date	The date of maturity.
Amount	The total amount as per the filter selection in instrument type.
Forecast Principal Expected Transaction Date	Expected transaction date for principal.
Forecast Principal Amount	Forecast principal amount.
Forecast Interest Expected Transaction Date	Expected transaction date for interest as per debt transaction forecast.
Forecast Interest Amount	Forecast interest amount depends on the debt transaction forecast filter selection.
Total Forecast	The total of forecast principal amount and forecast interest amount.
Actuals Principal Transaction Date	The actuals principal transaction date.
Actuals Principal Amount	The actual principal amount.
Actuals Interest Transaction Date	The actuals interest transaction date.
Actuals Interest Amount	The actuals interest amount.
Total Actuals	The total of actuals principal amount and actuals interest amount.
Total Forecast Principal Amount	The total forecast principal amount.
Total Forecast Interest Amount	The total forecast interest amount.
Grand Total Forecast	The total amount after adding the total forecast principal amount and total forecast interest amount.
Total Actuals Principal Amount	The total actuals principal amount.
Total Actuals Interest Amount	The actuals total interest amount.
Grand Total Actuals	The total amount after adding the total actuals principal and actuals total interest amount.

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 Debt Servicing Requirements 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.
	Lookup allows user to select existing item from the list as a filter.

Debt Instrument

Overview

This entity stores the register of debt instruments.

Navigation

General Ledger ► Sub Ledgers ► Debt Register ► Debt Instrument

Debt Instrument Screen Fields

Fields	Description
Code	Unique Identification code of the Debt Instrument.
Instrument Type	Refers to the instrument type entity in order to classify the debt instrument.
Currency	Currency of the Debt Instrument.
Debt Instrument Status	Indicates if the Advance is Open and transactions can be posted against it or it is closed and no transactions ca be posted against it. Default is Open.
Maturity Date	Indicates the Instrument maturity date.
Creation Date	Indicates the Instrument creation date. System populated current system date.
Instrument Issuance Date	Issuance date of the debt instrument.
Terms Of Bond	Calculated/Display only amount
Exchange Rate	The exchange rate for the chosen currency.
Principal Coding Block	Debt Instrument principal coding block.
Principal Coding Block Cash Inflow Account	Only FULL Coding Block allowed
Principal Coding Block Cash Outflow Account	Only FULL Coding Block allowed
Interest Coding Block	Debt Instrument principal coding block.
Creditor Agency	Associated with vendor
Interest Rate	Rate of interest applies to the instrument.
Principal Domestic Opening Balance	Principal Opening Balance of the Debt Instrument in domestic currency.
Principal Foreign Opening Balance	Principal Opening Balance of the Debt Instrument in foreign currency. Applicable only when the instrument is in foreign currency.
Principal Domestic Transaction Balance	This is a system calculated display only field. Shows the principal transaction balance.
Principal Foreign Transaction Balance	This is a system calculated display only field. Shows the principal transaction balance in foreign currency.
Principal Outstanding Domestic Balance	This is a system calculated display only field. Shows the outstanding principal amount of the instrument.
Principal Outstanding Foreign Balance	This is a system calculated display only field. Shows the outstanding principal amount of the instrument if it is in foreign currency.
Language	Country specific language used to register the description.
Name	Name of the Debt Instrument
Description	Description of the Debt Instrument.
Created By	System will automatically populate this attribute.
Debt Transaction Forecast Tab	Collection of 0 to N forecasts for the debt instrument.
Debt Transaction Actual Tab	Collection of 0 to N transaction actuals. This is a display only tab, automatically populated by the system through process.

Attachment Tab

Attachment Tab Screen Fields

Fields	Description
Id	Consecutive number auto generated by the system. It will be unique within the system.
Language	The system will suggest the default language; however the user can change such language. It represents the language of the document.
Title	Title of the document
Description	User defined. Description of the Attachment.
Attachment	Complete reference to the file attached
Date Time	Date and Time of the last operation performed on the attachment document. Visible for the user. Automatically assigned by the system.
Date	It will be used as a reference for Reports and Forms
User	Last user who uploaded or updated the document. Visible for the user. Automatically assigned by the system.

Debt Transaction Forecast Tab

Debt Transaction Forecast Tab Screen Fields

Fields	Description
Id	Refers to Debt Instrument code.
Serial Number	Auto generated item serial number starts with 1 for every new Debt Instrument.
Type of Transaction	Type of transaction. Possible values are Principal/Interest. Default is Principal.
Expected Transaction Date	Expected date for the transaction.
Currency	Currency of the Debt Instrument
Exchange Rate	Shows the latest active exchange rate for the selected currency.
Domestic Debit Amount	Transaction Debit Amount in domestic currency.
Foreign Debit Amount	Transaction Debit Amount in foreign currency.
Domestic Credit Amount	Transaction Credit Amount in domestic currency.
Foreign Credit Amount	Transaction Credit in foreign currency.

Generate Journal Entries For Debt Securities

Overview

This feature allows users to generate interest accrual or amortization of premium/discount for debt securities.

Navigation

General Ledger ► Sub Ledgers ► Debt Register ► Generate Journal Entries For Debt Securities

Generate Journal Entries For Debt Securities Screen Fields

Fields	Description
Fiscal Year	Default value is current fiscal year, applicable fiscal years where status of fiscal year must be Open and fiscal year is open for budget execution are presented.
Fiscal Period	Default value is current fiscal period .Only fiscal periods with status Open are available.
Debt Instrument	Optional attribute to run the process for a single debt instrument. Only open instrument with category “Securities” or “Zero Coupon Securities” are displayed.
Generate JV For Interest Accrual	Default is ‘Null’. If it is 'True' then it will consider only 'REGULAR_SECURITY','ZERO_COUPON_SECURITY' as Debt Instrument Category
Generate JV For Amortization Of Premium Or Discount	Default is ‘Null’. If it is 'True' it will consider only 'REGULAR_SECURITY' as Debt Instrument Category.

Guarantee Annual Ceiling

Overview

This entity should have a normal CRUD and should be subject to Audit Trail.

Navigation

General Ledger ► Sub Ledgers ► Debt Register ► Guarantee Annual Ceiling

Guarantee Annual Ceiling Screen Fields

Fields	Description
Code	Unique identifier. System generated
Active	Default is True
Fiscal Year	Fiscal Year of the Annual Ceiling
Ceiling Amount	Default Zero
Reserved Amount	Display only, dummy field. Calculated amount, Default Zero
Approved Amount	Display only, dummy field. Calculated amount, Default Zero
Unreserved Ceiling Amount	Display only, dummy field. Calculated amount, Default Zero
Issued Amount	Display only, dummy field. Calculated amount, Default Zero
Language	Country specific language
Description	Full description of the Annual Ceiling.

Sri Lanka Reports

Debt Service Payment Report

Overview

This report retrieves information about all the loan instruments that have securities or loans. It displays data from the annual provision, expenditure and balance provision, etc. It allows users to create reports based on their requirements.

A screenshot of the Debt Service Payment 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 Debt Service Payment Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► SriLanka Reports ► Debt Service Payment Report.

Filters

The following table lists describe all visible fields for the Debt Service Payment 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 shows a list of the fiscal years that allow users to select it as a report filter. The current fiscal year is set as a default report filter.
Fiscal Period	It shows a list of the fiscal period that allow users to select it as a report filter. The current fiscal period is set as a default report filter.
Comment	Allows users to add a custom comment to the generated report.

Visible Field

The following table lists and describe all visible fields for the Debt Service Payment 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.

Field	Description
Loan Repayments - Domestic	It is a report label.
Loan Repayments - Domestic Codes	It shows the item coding block for the loan repayment.
Loan Repayments - Domestic (Annual Provision)	It shows the current budget for the loan repayment.
Loan Repayments - Domestic (Expenditure Up to Previous Month)	It shows the expenditure loan repayment up to the previous month.
Loan Repayments - Domestic (Expenditure Up to This Month)	It shows the expenditure loan repayment up to this month.
Loan Repayments - Domestic Total	Empty space, manually filled after generating the report.
Loan Repayments - Domestic Balance Provision	Empty space, manually filled after generating the report.
Loan Repayments - Foreign	This is kept as a row lable for the report.
Loan Repayments - Foreign Codes	It shows the item coding block for the loan repayment.
Loan Repayments - Foreign (Annual Provision)	It shows the current budget for the loan repayment.
Loan Repayments - Foreign (Expenditure Up to Previous Month)	It shows the expenditure loan repayment up to the previous month.
Loan Repayments - Foreign (Expenditure Up to This Month)	It shows the expenditure loan repayment up to this month.
Total Capital Expenditure	This is kept as a row lable for the report.
Total Capital Expenditure Annual Provision	It shows the total annual previous capital expenditures.
Total Capital Expenditure Up To Previos Month	It shows the total capital expenditures up to the previous month.
Total Capital Expenditure Up To This Month	It shows the total capital expenditures up to current month.
Total Capital Expenditure - Total	It shows the total expenditure up to the previous month and total expenditure up to the current month.
Total Capital Expenditure - Balance Provision	It shows the total capital expenditures balance.
Interest Payment on Domestic Loans	This is kept as a row lable for the report.
Interest Payment on Domestic Loans - Codes	It shows the interest payment on domestic loan.
Interest Payment on Domestic Loans (Annual Provision)	The current budget for interest payment on domestic loans.
Interest Payment on Domestic Loans (Expenditure Up to Previous Month)	It shows the interest payment on domestic loans up to the previous month expenditure.
Interest Payment on Domestic Loans (Expenditure Up to This Month)	It shows the interest payment on domestic loans up to this month expenditure.
Interest Payment on Domestic Loans Total	Empty space, manually filled after generating the report.
Interest Payment on Domestic Loans Balance Provision	Empty space, manually filled after generating the report.
Interest Payment on Foreign Loans	This is kept as a row lable for the report.
Interest Payment on Foreign Loans - Codes	The interest payment on foreign loans code.
Interest Payment on Foreign Loans (Annual Provision)	The current budget for interest payment on foreign loans.
Interest Payment on Foreign Loans (Expenditure Up to Previous Month)	The interest payment on foreign loans it includes expenditure upto the previous month.
Interest Payment on Foreign Loans (Expenditure Up to This Month)	The interest payment on foreign loans it includes expenditure upto this month.
Interest Payment on Foreign Loans Total	Empty space, manually filled after generating the report.
Interest Payment on Foreign Loans Balance Provision	Empty space, manually filled after generating the report.
Total Interest Payment	This is kept as a row lable for the report.
Discount Amortization	This is kept as a row lable for the report.
Discount Amortization - Codes	The amortization discount code for item code 21603.
Discount Amortization (Annual Provision)	The current budget for discount amortization.
Discount Amortization (Expenditure Up to Previous Month)	Sum of the discount amortization up to the previous month expenditure.
Discount Amortization (Expenditure Up to This Month)	Sum of the discount amortization up to this month expenditure.
Discount Amortization Total	Empty space, manually filled after generating the report.
Discount Amortization Balance Position	Empty space, manually filled after generating the report.
Loan Flotation Expenditure	This is kept as a row lable for the report.
Loan Flotation Expenditure - Codes	The loan flotation expenditure code for item code 21701.
Loan Flotation Expenditure (Annual Provision)	The current budget for loan flotation expenditure.
Loan Flotation Expenditure (Expenditure Up to Previous Month)	The loan flotation expenditure up to the previous month.
Loan Flotation Expenditure (Expenditure Up to This Month)	The loan flotation expenditure up to this month.
Loan Flotation Expenditure Total	Empty space, manually filled after generating the report.
Loan Flotation Expenditure Balance Provision	Empty space, manually filled after generating the report.
Total Recurrent Expenditures	This is kept as a row lable for the report.
Total Recurrent Expenditures Annual Provision	It is the sum of the interest payment on domestic loans (expenditure up to previous month), interest payment on foreign loans (expenditure up to previous month), discount amortization (expenditure up to previous month) and loan flotation expenditure upto previous month.
Total Recurrent Expenditures Up to Previous Month	It is sum of all interest payment, discount amortization and loan flotation expenditure up to previous month.
Total Recurrent Expenditures Up to This Month	It is sum of all interest payment, discount amortization and loan flotation expenditure up to this month.
Total Recurrent Expenditures Total	It is the sum of the total recurrent expenditures up to previous month and total recurrent expenditures this month.
Total Recurrent Expenditures Balance Provision	It is the total balance amount of recurrent expenditure provision.
Total Debt Service Payments	This is kept as row lable for the report.
Total Debt Service Payments Annual Annual Provision	It is sum of total capital expenditure annual provision and total recurrent expenditures annual provision.
Total Debt Service Payments Up to Previous Month	It is sum of the total capital expenditure up to previous month and total recurrent expenditures up to previous month.
Total Debt Service Payments Up to This Month	It is sum of the total capital expenditure up to this month and total recurrent expenditures up to this month.
Total Debt Service Payments Total	It is sum of the total capital expenditure and total recurrent expenditures total.
Total Debt Service Payments Balance Provision	It is total debt service pament balance provison of all expenditures.

Buttons

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

Guarantee Ceiling Report

Overview

This report shows status of the guarantees issued by the government as of the current date.

A screenshot of the Guarantee Ceiling 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 Guarantee Ceiling Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantee Ceiling Information Report.

Visible Fields

The following table lists and describes all visible fields for the Guarantee Ceiling Report, in their default order. The language of the report depends on the configuration of the system.

Field	Description
Report Date	The current system date.
Report Time	The current system date.
User Code	Information of the user who has generates the report.
Current Date	The current date, up to when the report is generated.
Guarantee Ceiling	It shows the guarantee ceiling amount.
Guarantees Issues Previous Fiscal Year	It is the sum of the previous fiscal year domestic guarantee issued amount.
Guarantees Issues Current Fiscal Year	It is the sum of the current fiscal year domestic guarantee issued amount.
Letter of Comfort Issued	It is the sum of domestic guarantee issued amount for the instrument.
Total of Guarantees Issued & Letter of Comfort Issued	It is the grand total amount of all letter of comfort issued, previous year and current year guarantees issued.
Balance Available	It shows the calculated balance amount.
Guarantees Approved - To be Issued	It shows the creditor agency with project name.
Foreign Amount	It displays the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency.
Domestic Amount	The domestic amount.
Total Sum	The total sum of domestic amount.
Guarantees Approved - Tranches to be Issued	It shows the creditor agency with project name.
Foreign Amount	It shows the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency.
Domestic Amount	The domestic amount.
Total Sum	The total sum of domestic amount.
Treasury Guarantees - Pending Cabinet Approval	It shows the creditor agency with project name, where cabinet decision on status is pending.
Foreign Amount	It display the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency.
Domestic Amount	The domestic amount.
Total Sum	The total sum of domestic amount.
Sovereign Guarantees - Pending Cabinet Approval	It shows the creditor agency with project name, where cabinet decision on status is pending.
Foreign Amount	It shows the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency.
Domestic Amount	The domestic amount.
Total Sum	The total sum of domestic amount.
Reserved Balance	The grand total amount.
Total Guarantees Issued & Reserved	The sum of the reserved balance and total of guarantees issued & letter of comfort issued.
Balance Available for New Issues	The available balance amount for new issues.
Percentage of Total Guarantees Issued & Reserved	Percentage of total guarantees issued and reserved.
CBSL Exchange Rates as at (Current Date)	All the exchange rates used to convert the external guarantees from foreign currency to domestic currency.

Buttons

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.

Guarantee Type Report

Overview

The report shows the total guarantee issued by debt types and the issued amount as a % of the total guarantees issued.

A screenshot of the Guarantees Type Report feature 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 installed the revision.

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

Filters

The following table lists and describes all filter for the Guarantees Type Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Field	Description
Creditor Agency	It refers to the creditor agencies of the Debt Instrument. Users may select creditor agency to filter the report.
Status	It is a mandatory field. It refers the status open or close of the guarantees.
Issue Date	Refers to the issue date of the guarantees.
Expiry Date	Refers to the expiry date of the guarantees.

Visible Fields

A sample of the Guarantee Type Report output is available here. The following table lists and describes all visible fields for the Guarantees Type 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
No.	Indicates serial numbers.
Name of Institution	Creditor Agency names of the guarantees.
Treasury Guarantees	Amount for the domestic guarantees issued.
Sovereign Guarantees	Amount for the foreign guarantees issued.
Total (Column)	This is a calculated field, shows sum of domestic and foreign guarantees.
Issued %	Ths is percentage of total guarantees issues for the institution over the total gurantees issued.
Total (Row)	This is calculated field, shows the sum of columns.
CBSL Exchange Rates as at (Current Date)	This show a table with all the exchange rates used to convert the external guarantees from foreign currency to domestic currency.

Buttons

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.
	This button allows users to generate the report in ODT format.
	This button allows users to generate the report in ODS format.

Guarantees Issued Bank Wise Report

Overview

This report generates the list of guarantees issued by the general treasury. It provides different filter option to generate the report.

A screenshot of the Guarantees Issued Bank Wise 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 Issued Bank Wise Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees Issued Bank Wise Report.

Filters

The following table lists and describe all filter fields for the Guarantees Issued Bank Wise 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
Financial Institution	It allows users to select the financial institution as a filter by using the lookup feature.
Status	It lists the status and allows users to select it as report filter.
From Issuance Date	The date picker allows users to put the 'issuance date from' as a filter for the report.
To Expire Date	The date picker allows users to put the 'to expire date' as a filter for the report.
Comment	Users can enter a relevent comment, added to the generated report.
Sort By	It provide sorting filter for the report.

Visible Fields

The following table lists and describes all visible fields for the Guarantees Issued Bank Wise 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.

Field	Description
S.No	Sequence number.
Name of the Bank or Institution	Name of the bank/institution receiving the guarantee.
Name of Institution	Name of the financial institute.
Rs. Mn.	Guarantee issued domestic amount in millions.
Total per Name of the Bank or Institution	Total amount grouped as per the name of the bank or institution.
Grand Total Rs. Mn.	Sum of the Rs. Mn.
Grand Total	Grand total amount.

Buttons

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.
	Allow to select a calendar date.

Guarantees Summary Report

Overview

The report shows the total guarantee issued to institutions or creditor agencies by banks or financial institutions.

A screenshot of the Guarantees Summary Report feature 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 installed the revision.

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

Filters

The following table lists and describes all filter for the Guarantees Summary Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.

Field	Description
Creditor Agency	It refers to the creditor agencies of the Debt Instrument. Users may select creditor agency to filter the report.
Status	It is a mandatory field. It refers the status open or close of the guarantees.
Issue Date	Refers to the issue date of the guarantees.
Expiry Date	Refers to the expiry date of the guarantees.
Comment	Allows users to add a custom comment to the generated report.

Visible Fields

A sample of the Guarantees Summary Report output is available here. The following table lists and describes all visible fields for the Guarantees Summary 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
No.	Indicates serial numbers.
Name of Institution	Creditor Agency names of the guarantees.
Name of the Bank or Financial Institution	This refers to the financial institutions or banks that issues the guarantees.
Total (Column)	This is a calculated field, displaying the sum of all the bank or financial institutions for the Creditor agency.
Total (Row)	This is a calculated field, displaying the sum of all the creditor agencies for the bank or financial institution.
CBSL Exchange Rates as at (Current Date)	This show a table with all the exchange rates used to convert the external guarantees from foreign currency to domestic currency.

Buttons

Button Image	Description
	This button allows users to generate the report as PDF.
	This button allows users to generate the report as MS Excel.
	This button allows users to generate the report as MS Excel (XLSX format).
	This button allows users to generate the report as RTF.
	This button allows users to generate the report as MS Word.
	This button allows users to generate the report in ODT format.
	This button allows users to generate the report in ODS format.

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.

Field	Description
Creditor Agency	It allows users to select the creditor agency using the lookup feature.
Status	It 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 Date	It allows to enter the guarantees issue date using the date picker.
Expiry Date	It allows to enter the guarantees expiry date using the date picker.
Comment	Users can enter a comment for the report.
Sort By	It 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.

Field	Description
Report Date	The current system date appears on the report.
Report Time	The current system time appears on the report.
User Code	The user code who generates the report.
Issue Date	The issue date.
Fiscal Year	Fiscal year from filter criteria.
Sequence Number	Sequential row number.
Creditor Agency (SOE)	The creditor agency name.
Name of Bank/Institution	The 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. Amount	It is sum of all Rs. Mn.

Buttons

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.

Recurrent Expenditure On Borrowings Report

Sector Wise Guarantees Issued And Reserved Report

Support Entities

Debt Instrument Type

Overview

This entity lists all the different types of debt instruments.

Navigation

General Ledger ► Sub Ledgers ► Debt Register ► Support Entities ► Debt Instrument Type

Debt Instrument Type Screen Fields

Fields	Description
Code	Unique Identification code of the Debt Instrument Type.
Active	Indicates if the Instrument Type is “active” True = Active, False = Inactive.
Debt Type	Defines the Type of Debt. Possible values are, External and Domestic. Default is External.
Type of Financial Operation Type	Indicates the financial operation type for the instrument type. Possible Values are Loan, Regular Security, Zero Coupon Security and Guarantee.
Currency	Indicates the Currency of the Instrument Type. Default is domestic currency.
Name	Name of the Instrument Type.
Description	Description of the Instrument Type.

Generic Sub Ledgers

Generic Sub Ledger Register

Overview

This entity stores all entries in the generic subledger. A subledger item must first exist in this table before it can be used in any transaction.

Navigation

General Ledger ► Sub Ledgers ► Generic Sub Ledgers ► Generic Sub Ledger Register

Generic Sub Ledger Register Screen Fields

Fields	Description
Code	Unique Identification code of the Generic SubLedger Type.
Active	Indicates if the Generic Sub Ledger is “active” True = Active, False = Inactive.
Domestic Debit Transaction Balance	Calculated/Updated Display Only Field Default is Zero
Domestic Credit Transaction Balance	Calculated/Updated Display Only Field Default is Zero
Created By	System will automatically populate this attribute.
Created Date	Timestamp at creation date-time
Last Updated User	System will automatically populate this attribute when this record is updated
Last Updated Date	Timestamp at update
Language	Country specific language used to register the description.
Name	Name of the Generic Sub Ledger.
Description	Description of the Generic Sub Ledger
Beneficiary	Refers to the Beneficiary/Vendor for the Sub Ledger.
Generic Sub Ledger Type	Indicates the Generic Sub Ledger Type for the Generic Sub Ledger.
Generic Subledger Transaction Forecast Tab	Contains the information about Sub Ledger Transaction forecast.
Generic Subledger Transaction Actuals Tab	This is a read only tab; the information will be populated from processes.

Generic Subledger Transaction Forecast Tab

Generic Subledger Transaction Forecast Tab Screen Fields

Fields	Description
Sequence	Sequential number of the Generic Subledger Transaction Forecast.
Expected Transaction Date	To define the expected transaction date.
Currency	Read-only, calculated attribute.
Exchange Rate	Will show the latest active exchange rate for the selected currency, users can change the rate if allowed in the Currency parameters, otherwise this field will be ‘Display only’ and updated only by the system when the currency is selected.
Domestic Debit Amount	Transaction Debit Amount in domestic currency.
Foreign Credit Amount	Transaction Credit in foreign currency

Generic SubLedger Type

Overview

This entity keeps track of all generic subledger types.

Navigation

General Ledger ► Sub Ledgers ► Generic Sub Ledgers ► Generic SubLedger Type

Generic SubLedger Type Screen Fields

Fields	Description
Code	Unique Identification code of the Generic SubLedger Type.
Active	Indicates if the Generic SubLedger Type is active and used. Default is true.
Is Activate Sub Type	If true the Sub Type get activated.
Is Use Vendor	Indicates if Generic SubLedger Type will use Vendor.
Name	Name of the Generic SubLedger Type.
Description	Description of the Generic SubLedger Type.
Sub Type	To define sub types for the Generic SubLedger Type.

SubType Tab

SubType Tab Screen Fields

Fields	Description
Language	Country specific language used for Sub Type information.
Name	Name of the Sub Type.
Description	Description of the Sub Type.
Active	Indicates if the subtype is “active” True = Active, False = Inactive.

Investment Register

Investment

Overview

Main entity Investment, that stores information of the Government's investments.

Navigation

General Ledger ► Sub Ledgers ► Investment Register ► Investment

Investment screen Fields and Tabs

Field	Description
Code	Unique identifier. Setup parameter to determine if entered by user or system generated. When system generated, it will be left-padded with zeros.
Investment Type	Reference to the investment type entity in order to classify the entered investments.
Investment Status	To indicate if the Advance is Open and transactions can be posted against it or it is closed and no transactions ca be posted against it
Origin	Allows to select origin from the drop down list
Principal Coding Block	Only FULL Coding Block allowed
Return On Investment Coding Block	The Object element should be in Sub-Ledger Entity and linked to the Investment Register
Issuing Agency	Agency who issues the investment
Purchased/Issuance Date	Date when the investment was issued. Default is System Date
Currency	Currency that is used for the investment.
Estimated Investment Amount Domestic	Default is Zero. Disabled if Currency is NOT Domestic Currency
Estimated Investment Amount Foreign	Default is Zero. Disabled if Currency is Domestic Currency
Number Of Shares Sold	Calculated/Updated Display Only Field
Principal Domestic Opening Balance	Calculated/Updated Display Only Field. Default is NULL.
Principal Domestic Transaction Balance	Calculated/Updated Display Only Field. Default is zero
Principal Domestic Outstanding Balance	Calculated/Updated Display Only Field. Default is zero
Principal Foreign Opening Balance	Calculated/Updated Display Only Field. Default is NULL.
Principal Foreign Transaction Balance	Calculated/Updated Display Only Field. Default is zero
Principal Foreign Outstanding Balance	Calculated/Updated Display Only Field. Default is zero
Domestic Total ROI To Date	Calculated/Updated Display Only Field. Default is zero
Foreign Total ROITo Date	Calculated/Updated Display Only Field. Default is zero
Created By	System will automatically populate this attribute.
Created Date	Timestamp at creation date-time.
Last Updated User	System will automatically populate this attribute when this record is updated
Last Updated Date	Timestamp at update
Name	Name given to the investment
Description	Description of the investment
Attachment Tab	Collection of 0 to many attachments. Use a tab for this attribute.
Investment Transaction Forecast Tab	Defines the forecast transaction for the investment. Collection of 0 to many. Use a tab for this attribute.

Forecast Transaction

Overview

This entity stores the different transactions associated with investments..

Forecast Transaction screen Fields

Name	Description
Investment Transaction type	Reference to the transaction type entity. Dropdown list. List only the transactions types.
Fiscal year	Current Fiscal Year for Budget Execution
Fiscal Period	Current Fiscal Period for Budget Execution
Description	Transaction description.

Investment Reports

On Lending Summary Report

Overview

The main purpose is to list the actual Investment of sub-type On Lending and it's details.

Navigation

General Ledger ► Sub Ledgers ► Investment Register ► Investment Reports ► On Lending Summary Report

On Lending Summary Report Filter Fields

Fields	Description
Vendor	Filter by Vendor code. This attribute implemented as look-up.
Fiscal year	Year part of the creation date of the actual investments

Share Holding Summary Report

Overview

Summary report on Share holding from Investment Register is extracted from through this screen by selecting the Investment Type as filtering criteria.

Navigation

General Ledger ► Sub Ledger ► Investment Register ► Investment Reports ► Share Holding Summary Report

Share Holding Summary Report screen Fields

Field	Description
Investment Type	Type of Investment is selected from drop down box for filtering records.
Vendor	Vendor Code
Fiscal Period	Fiscal period of the report. Single Selection
As at	Current system date

SriLanka Reports

Debt Payment Forecast Report

Overview

This report retrieves information on all debt instruments that have been securities or loans. The report contains the Treasury bond, treasury bills, rupee loan, SLDB, and FCBU details breakup in domestic and foreign currencies. In addition, these also provide important information requires in the formulation of fiscal policy, such as forecasts of drawdown and debt servicing liabilities and debt implications of different fiscal and deficit financing policies.

A screenshot of the Debt Payment Forecast 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 Debt Payment Forecast Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Investment Register ► Investment Reports ► SriLanka Reports ► Debt Payment Forecast Report.

Filters

The following table describes all filter fields for the Debt Payment Forecast 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.

Filter	Description
Fiscal Year	It shows a list of the fiscal years that allow users to select it as a report filter. The current fiscal year is set as a default report filter.
Fiscal Period From	The current fiscal period is set as the initial range by default. Based on the requirement user can select another fiscal period from the list.
Fiscal Period To	The current fiscal period is set as the end range by default. Based on the requirement user can select another fiscal period from the list.
Type	It allows users to select the report type from the list. A value for this field is mandatory.

Visible Field

The following table lists and describe all visible fields for the Debt Payment Forecast 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.

Field	Description
Report Headers	It shows the report headers i.e. country logo, report time, report date, report name, etc.
Treasury Bond (FV) Capital	This shows the domestic debit amount for treasury bond capital transactions.
Treasury Bond (FV) Interest	This shows the domestic debit amount for treasury bond interest transactions.
Treasury Bills Capital	This shows the domestic debit amount for treasury bond capital transactions.
Treasury Bills Interest	This shows the domestic debit amount for treasury bond interest transactions.
Rupee Loan Capital	This shows domestic debit amount for treasury bond capital transactions.
Rupee Loan Interest	This shows domestic debit amount for treasury bond interest transactions.
SLDB Capital	This shows domestic debit amount for treasury bond capital transactions.
SLDB Interest	This shows domestic debit amount for treasury bond interest transactions.
FCBU Capital	This shows domestic debit amount for treasury bond capital transactions.
FCBU Interest	This shows domestic debit amount for treasury bond interest transactions.
ISB Capital	This shows domestic debit amount for treasury bond capital transactions.
ISB Interest	This shows domestic debit amount for treasury bond interest transactions.
Project Program Loans Capital	This shows domestic debit amount for treasury bond capital transactions.
Project Program Loans Interest	This shows domestic debit amount for treasury bond interest transactions.
Term Loan Capital	This shows domestic debit amount for treasury bond capital transactions.
Term Loan Interest	This shows domestic debit amount for treasury bond interest transactions.
Total Capital	It is the total amount of all capital transactions.
Total Interest	It is the total amount of all Interest transactions.

Buttons

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.

Debt Stock Report

Overview

This report retrieves information on all debt instruments that have been securities or loans. Users can generate the report in different available formats that are PDF, Word, Excel, RTF, ODS, ODT, etc.

A screenshot of the Debt Stock 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 Debt Stock Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Investment Register ► Investment Reports ► Sri Lanka Reports ► Debt Stock Report.

Filters

The following table lists describe all filters fields for the Debt Stock 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 to select as report filter. The current fiscal year is set as default value.
Fiscal Period	It lists the fiscal period to select as report filter. The current fiscal period is set as default value.

Visible Field

The following table lists and describes all visible fields for the Debt Stock 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.

Fields	Description
Opening Balance Rupee Loan Face Value	The calculated opening balance rupee loan face value amount from general ledger where coding block object code is 42103003.
Opening Treasury Bills Book Value	The calculated opening treasury bills book value amount from general ledger where coding block object code is 14102001.
Opening Treasury Bills Face Value	The calculated opening treasury bills face value amount from general ledger where coding block object code is 42103001.
Opening Treasury Bonds Book Value	The calculated opening treasury bonds book value amount from general ledger where coding block object code is 14102002.
Opening Treasury Bonds Face Value	The calculated opening treasury bonds face value amount from general ledger where coding block object code is 14102002.
Opening SLDB	The calculated opening SLDB amount from general ledger where coding block object code is 42103004.
Opening FCBU	The calculated opening FCBU amount from general ledger where coding block object code is 42104002.
Opening Project and Program Loans	It shows the calculated opening project and program loan amount from general ledger where coding block object code has item 42202.
Opening Term Loan	It shows the calculated opening term loan amount from general ledger where coding block object code has item 42201.
Opening ISB	It shows the calculated opening ISB amount from general ledger where coding block object code has item 42203.
Add: Borrowings	It is report label for borrowings.
Month Name Borrows	It shows all month's name of the selected fiscal year.
Borrowing Rupee Loan Face Value	It shows the total borrowing rupee loan face value amount from approved journal voucher line items where coding block object code is 42103003.
Borrowing Treasury Bills Book Value	It shows the calculated balance amount month wise in report from approved journal voucher line items where coding block object code is 14102001.
Borrowing Treasury Bills Face Value	It shows month wise total domestic credit amount in borrowing treasury bills face value from approved journal voucher line items where coding block object code is 42103001.
Borrowing Treasury Bonds Book Value	It shows the month wise calculated amount in borrowing treasury bonds book value from approved journal voucher line items where coding block object code is 14102002.
Borrowing Treasury Bonds Face Value	It shows month wise total domestic credit amount in borrowing treasury bonds face value from approved journal voucher line items where coding block object code is 14102002.
Borrowing SLDB	It shows month wise total domestic credit amount in borrowing SLDB from approved journal voucher line items where coding block object code is 42103004.
Borrowing FCBU	It shows month wise total domestic credit amount in borrowing FCBU from approved journal voucher line items where coding block object code is 42104002.
Borrowing Project and Program Loans	It shows month wise total domestic credit amount in borrowing project and program loans from approved journal voucher line items where coding block object code is 42202.
Borrowing Term Loan	It shows month wise total domestic credit amount in borrowing term loan from approved journal voucher line items where coding block object code is 42201.
Borrowing ISB	It shows month wise total domestic credit amount in borrowing ISB from approved journal voucher line items where coding block object code is 42203.
Total Borrowing Rupee Loan Face Value	It shows the summation amount of all months borrowing rupee loan face values.
Total Borrowing Treasury Bills Book Value	It shows the summation amount of all months borrowing treasury bills book value.
Total Borrowing Treasury Bills Face Value	It shows the summation amount of all months borrowing treasury bills face value.
Total Borrowing Treasury Bonds Book Value	It shows the summation amount of all months borrowing treasury bond book value.
Total Borrowing Treasury Bonds Face Value	It shows the summation amount of all months borrowing treasury bond face value.
Total Borrowing SLDB	It shows the summation amount of all months borrowing SLDB.
Total Borrowing FCBU	It shows the summation amount of all months borrowing FCBU.
Total Borrowing Project and Program Loans	It shows the summation of all months for borrowing project and program loans.
Total Borrowing Term Loan	It shows the summation of all months for borrowing term loan.
Total Borrowing ISB	It shows the summation of all months for borrowing ISB.
Less: Repayments (Capital)	It is report label for repayments.
Month Name Repayments	It shows all months name for the selected fiscal year.
Repayments Rupee Loan Face Value	It shows month wise total domestic debit amount in repayment rupee loan face value from approved journal voucher line items where coding block object code is 42103003.
Repayments Treasury Bills Book Value	It shows month wise balance amount in repayment treasury bills book value from approved journal voucher line items where coding block object code is 23301001.
Repayments Treasury Bills Face Value	It shows month wise balance amount in repayment treasury bills face value from approved journal voucher line items where coding block object code is 42103001.
Repayments Treasury Bonds Book Value	It shows month wise balance amount in repayment treasury bonds book value from approved journal voucher line items where coding block object code is 23301002.
Repayments Treasury Bonds Face Value	It shows month wise balance amount in repayment treasury bonds face value from approved journal voucher line items where coding block object code is 42103002.
Repayments SLDB	It shows month wise balance amount in repayment SLDB from approved journal voucher line items where coding block object code is 42103004.
Repayments FCBU	It shows month wise balance amount in repayment FCBU from approved journal voucher line items where coding block object code is 42103004.
Repayments Project and Program Loans	It shows month wise balance amount in repayment project and program loan from approved journal voucher line items where coding block has item 42202.
Repayments Term Loan	It shows month wise balance amount in repayment term loan from approved journal voucher line items where coding block has item 42201.
Repayments ISB	It shows month wise balance amount in repayment term loan from approved journal voucher line items where coding block has item 42203.
Total Repayments	It is report label for total repayment.
Total Repayments Rupee Loan Face Value	Summation of repayments rupee loan face value amount for all months.
Total Repayments Treasury Bills Book Value	Summation of repayments treasury bill book value amount for all months.
Total Repayments Treasury Bills Face Value	Summation of repayments treasury bill face value amount for all months.
Total Repayments Treasury Bonds Book Value	Summation of repayments treasury bonds book value amount for all months.
Total Repayments Treasury Bonds Face Value	Summation of repayments treasury bonds face value amount for all months.
Total Repayments SLDB	Summation of repayments SLDB amount for all months.
Total Repayments FCBU	Summation of repayments FCBU amount for all months.
Total Repayments Project and Program Loans	Summation of repayments project and program Loans amount for all months.
Total Repayments Term Loan	Summation of repayments term Loans amount for all months.
Total Repayments ISB	Summation of repayments ISB amount for all months.
Ending Balance Rupee Loan Face Value	It shows the calculated amount for ending balance rupee loan face value.
Ending Balance Treasury Bills Book Value	It shows the calculated amount for ending balance treasury bills book value.
Ending Balance Treasury Bills Face Value	It shows the calculated amount for ending balance treasury bills face value.
Ending Balance Treasury Bonds Book Value	It shows the calculated ending balance treasury bonds book value.
Ending Balance Treasury Bonds Face Value	It shows the calculated amount for ending balance treasury bonds face value.
Ending Balance SLDB	It shows the calculated ending balance SLDB.
Ending Balance FCBU	It shows the calculated ending balance FCBU.
Ending Balance Project and Program Loans	It shows the calculated ending balance project and program loans.
Ending Balance Term Loan	It shows the calculated amount for ending balance term loan.
Ending Balance ISB	It shows the calculated amount for ending balance ISB.

Buttons

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.

On Lending Comparison Report

Share Holding Details Report

Support Entities

Investment Type

Overview

This entity holds the investment types.

Navigation

General Ledger ► Sub Ledgers ► Investment Register ► Support Entities ► Investment Type

Investment Type screen Fields and Tabs

Field	Description
Code	Unique identifier.
Name	Abbreviation of the investment type name. Localized field.
Description	Full description of the investment type. Localized field.
Active	Indicates if the investment type is “active” for registry.
Investment Category	Indicates the Investment substitute type which can be On Lending or Shares.

Loan/Advance Register

Borrower

Overview

This entity stores the distinct type of borrowers for a better classification.

Navigation

General Ledger ► Sub Ledgers ► Loan/Advance Register ► Borrower

Borrower Screen Fields

Fields	Description
Code	Unique identifier. System generated.
Is On Freebalance Payroll	False (Default)
Borrower Type	Classification of the borrower according type.
Workflow Status	Workflow status of the Borrower
Associated Institution	Institution of the Associated borrower
Borrower Status	It's a read-only field that will be manipulated through the workflow.

Generic Borrower

Overview

This entity will store information for those persons outside FB Payroll that could be applicable to obtain a Loan.

Navigation

General Ledger ► Sub Ledgers ► Loan/Advance Register ► Generic Borrower

Generic Borrower Screen Fields

Fields	Description
Code	Unique identifier. System generated.
First Name	First name of the borrower
Last Name	Last name of the borrower
Employee Code	Employee code of the generic borrower.
Personal Identification Number	Unique person Identifier
Date Of Birth	Generic borrower date of birth.
Place Of Birth	Generic borrower Place of Birth
Gender	Generic borrower Gender
Associated Institution Code	Institution code associated with Generic borrower
Designation	Designation of the borrower
Vacated Date	Vacated date of the borrower

Loan

Overview

This feature stores the general header information related to Loans.

Navigation

General Ledger ► Sub Ledgers ► Loan/Advance Register ► Loan

Loan Screen Fields

Fields	Description
Code	Manual or automatically generated, depending on paramater configuration, unique identifier.
Workflow Status	The workflow process status of the Loan, automatically generated and updated.
Loan Type	Reference to Loan Type, in order to classify the entered loans. Drop down list to select loan type.
Borrower	The employee or entity acting as the borrower, look up functionality is available to select borrower.
Language	Allows to select country specific language to apply for Purpose attribute.
Purpose	Purpose, terms and references of the current loan.
Annual Interest Rate	Interest rate applicable on the current loan.
Total Principal Amount	The total principal amount of the current loan.
Start Date	Start date of loan.
Number of Repayments	Quantity of repayments to cancel the loan.
Expected End Date	End date of loan. Calculated by the system, this is a read-only field.
Special Conditions	Special conditions of the current loan.
Outstanding Balance	Outstanding balance of the loan, not editable. Calculated and updated from transactions of the loan. Initial value = 0
Total Principal Paid Amount	Total principal amount paid. Visible, not editable. Calculated and updated from transactions of the loan. Initial value = 0
Total Interest Paid Amount	Total interest paid amount. Visible, not editable. Calculated and updated from transactions of the loan. Initial value = 0
Type of Scheduled Repayment Calculation	Used to validate the type of the calculation method for the payment schedule. Read-only, not editable field, value is taken from Loan type.
Created By	Read-only field, filled with logged in user automatically by the system
Creation Date	Read-only. System date, automatically filled in the system.
Approved By	Read-only. Automatically filled by the system with user that approves record.
Approval Date	Read-only field displays ystem date of approval of the record.
Principal Account	Principal Account of the Loan Type.
Interest Account	Interest Account of the Loan Type.
Others Account	Others Account of the Loan Type
Transaction Schedule	This contains the transactions schedule for the current loan. It is automatically generated and updated by the system.

Loan Type

Overview

This entity stores the distinct type of Loans.

Navigation

General Ledger ► Sub Ledgers ► Loan/Advance Register ► Loan Type

Loan Type Screen Fields

Fields	Description
Code	Unique identifier.
Active	Indicates if the loan type is “active” for registry of cases True = Active, False = Inactive.
Is Default Loan Type?	Indicates if the case type is the default type when creating a new instrument type entry.
Number Of Repayments	The total number of repayments for the actual type of loan
Deduction	Related deduction code for those employees on the payroll.
Calculation Method	Equal instalment (Default)
Language	Country specific language
Name	Abbreviation of the loan type name.
Description	Full description of the loan type.
Principal Account	System will list the sub-ledgers with status Active = True and of type = 'Loan Register'.
Interest Account	System will list the sub-ledgers with status Active = True and of type = 'Loan Register'.
Others Account	System will list the sub-ledgers with status Active = True and of type = 'Loan Register'.