Expenditures

The Expenditures module allows users to define and track all expenses that are incurred within particular cost center. In addition it provides a payment function which helps ensure that specified expenses are properly paid on time.

Features of the Expenditures module:

Basic Services

Basic Services Voucher

Overview

This entity contains the list of basic services voucher (header), these are the documents containing the registration and control of the management of basic services. And linkage to budgetary expenses and accounting documents.

Navigation

Expenditures ► Basic Services ► Basic Services Voucher

Basic Services Voucher Screen Fileds

Fields

Descriptions

Code

Unique ID that identifies a Basic Services Voucher.

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Fiscal Year

Fiscal Year of the Basic Services Voucher.

Fiscal Period

Fiscal Period of the Basic Services Voucher.

Execution Type

Read only attribute, value will be assigned through processes.

Voucher Date

Date and time of Voucher. Default current system date and time.

Institution

Code of Institution identified by Institutional Classifier. Unique identifier. Only one Institution can be linked.

Is Revolving Fund Execution

Execution Type. Read only attribute, value will be assigned through processes.

Source Document Number

This is the document number of the source document.

Grants Document Type

Unique code that identifies the document type. Only one Document type can be linked.

Supporting Document Number

Number of document that supports the transaction. Manually entered by the user.

Multifold Funding Source

Default is False. If ‘Multifold Funding Source’ = False then ask for a Single Source.

If ‘Multifold Funding Source’ = True then ask for Sources Details (multifold funding source). Default value is FALSE

Executes Project

Indicates if there is execution of expenses of Invoice Basic Service for Project with External Financing. Default value is False.

Currency

Code of Currency. Only one Currency can be linked.

Exchange Rate

Will show the latest active Exchange Rate Value for the selected Currency which is linked to Expenditures, users can change the Rate

Total Amount (Domestic)

The system automatically calculates the value Total Amount Domestic. Total Domestic" =  "Total Domestic Amount" - "Amount Domestic Deduction". The value must be greater than zero.

Total Amount (Foreign)

Total Amount When Currency is not Domestic. Default is Zero.

Amount Domestic Deduction

Amount Domestic value of deduction. Value default = 0

Amount Foreign Deduction

Amount Foreign value of deduction. Value default = 0

Total Domestic

The system automatically calculates the value Total Amount Domestic

Total Foreign

The system automatically calculates the value Total Amount Foreign

Vendor

Unique code that identifies the Vendor beneficiary. Only one Vendor Beneficiary can be linked.

Treasury Bank Account

Automatically load the list of values of the classifier categories of expenditure of the attribute "Treasury Bank Account" 

Payment Mode

Default value will be populated automatically from the selected vendor information if defined, if not defined in the vendor then default will populated be as defined in the Expenditures Parameter

Created By

Unique identification of user. Populated automatically by the system.

Created Date

Default current system date and time. Populated automatically by the system at creation time of the record.

Approved By

Populated automatically by the system, when the document is approved.

Approved Date

Date in which the Basic Services Voucher document turns to ‘Approved’ Status. Default current system date and time.

Language

Country Specific language

Description

Description of Voucher, describes the basic service to pay. Manually entered by the user.

 

Invoice Basic Service

Overview

This entity contains the list of invoice basic services (expenses details) that must be to pay. Details the documents (invoices) containing the registration and control of the management of basic services.

Invoice Basic Service Tab Screen Fields

Fields

Descriptions

Serial Number

Unique ID that identifies the Invoice Basic Services (Expenses Details).

Fiscal Period

Invoiced Month of basic service. Manually entered by the user. default current fiscal Period

Institution

Code of Institution identified by Institutional Classifier. Unique identifier. Only one Institution can be linked.

Institution Name

Name of Institution. This attribute is automatically entered by the system according to attribute " Institution Code"

Basic Service

Unique code that identifies of basic service type. This field will be defaulted if Basic Service ID is selected. The user can change it. Only one Basic Service can be linked.

Service Number

Number of Service according to the register of the basic service.

Basic Service Status

Indicates Status of the Basic Service hired.

Coding Block

Use the Cao Group will be the budget Execution.

Invoice Number

Invoice number delivered by the vendor beneficiary. Manually entered by the user.

Invoice Type

Indicates Type of invoice delivered by the vendor beneficiary. Manually entered by the user.

Invoice Date

Date of issue of the invoice submitted by the vendor beneficiary. ‘Invoice Date’ must be less than or equals the ‘Voucher Date’ 

Entry Date

Entry Date of voucher of basic services. Manually entered by the user.

Reference Collection Number

Number defined by the service provider for reference collection of the invoice. Manually entered by the user.

Due Date Payment

Due date payment (Deadline for payment). Expiration Date of the invoice submitted by the vendor beneficiary. Due date should be always greater than Invoice date

Date From

Start date of the period of service billed.

Date Up

End date of period of service billed.

Invoiced Days

This field should be calculated automatically by the system using attributes "Date From" and "Date Up" (if they were defined) as result of number of days based between both dates: Date Up minus Date from; Or, Otherwise both can be manually entered by the user.

Actual Reading

Actual reading of the meter.

Previous Reading

Previous reading of meter.

Billed Consumption

Billed consumption of basic service.

Average Consumption

Average monthly consumption of basic service over the past 12 months.

Merchandising Amount

Amount of Merchandising in the month.

Surcharge Arrearages Amount

Amount Late Payment Surcharge in the month.

IVA Amount

Amount by Value Added Tax in the month.

Other Amount

Amount for any other reason (or concept of recovery) in the month.

Domestic Amount

Total Amount Billed in the month When Currency is Domestic. Default value is Zero.

Foreign Amount

Total Amount Billed in the month When Currency is not Domestic. Default value is Zero.

Total Amount Owed

Total amount owed to this month.

Number Document Expense

No. Document of execution of expense. Automatically assigned by the system. When the document is "approved"

Is Reversed

“Read Only Field” will be updated automatically by the system for the process 

No. Reversed

“Read Only Field” will be updated automatically by the system for the process 

Is Refund

“Read Only Field” will be updated automatically by the system for the process 

No. Refund

“Read Only Field” will be updated automatically by the system for the process 

Is Correction

“Read Only Field” will be updated automatically by the system for the process 

No. Correction

“Read Only Field” will be updated automatically by the system for the process 

 

IBS Project Structure

Overview

This entity contains the list of project structures by invoice of basic service that must be related with details the Invoices Basic Services.

IBS Project Structure Tab Screen Fields

Fields

Description

Serial Number

Unique ID that identifies the Invoice Basic Service Project Structure (execution of expenses for project with external financing). It’s a consecutive number automatically generated by the system.

Agreement Project

Unique identifier that identifies an ID of Agreement. 

Line Project

Allows to select line project from drop down list

Counter Part

Unique identifier that identifies an ID of Counterpart

Domestic Amount

Amount value of Project Structure, When Currency is Domestic. Default value is Zero.

Foreign Amount

Amount value of Project Structure, When Currency is not Domestic. Default value is Zero.

Total Domestic YTD Actual

Default is Zero. Calculated field Display only to show actual domestic amount spent on this detail item. Will get updated automatically by the system upon the approval of the transactions (Execution type = DEV) that are linked to this item. Default is Zero

Total Foreign YTD Actual

Calculated field Display only to show actual domestic amount spent on this detail item. Will get updated automatically by the system upon the approval of the transactions (Execution type = DEV) that are linked to this item. Default is Zero

Total Domestic Balance

Read Only calculated field Display Total Domestic Balance of each Item. Default is Zero

Total Foreign Balance

Read Only calculated field Display Total Foreign Balance of each Item. Default is Zero

 

Invoice Basic Deduction Details

Overview

This entity contien the deductions details, to the record and control the Document of Basic Service Voucher.

Invoice Basic Deduction Details Tab Screen Fields

Fields

Description

Serial Number

Item Correlative Number.
Automatically generated by system (user cannot change it) for each inserted item, starts with 1 for every new document.

Deduction

Code of Deduction for the Travel Expenses voucher.
The system should present a list of values for selection by the user or search functionality.

Deduction Type

System will automatically display the Offset code 

Retention Origin

Manually entered by the user

Domestic Amount

If the attribute “Currency” is Domestic, then the value must be Manually entered by the user.

Foreign Amount

If the attribute “Currency” is Domestic, this value has zero. Else the value must be Manually entered by the user.

 

Support Entities

Basic Service

Overview

This entity contains the list of basic services hired (contracts by office).

Navigation

Expenditures ► Basic Services ► Support Entities ► Basic Service

Basic Service Screen Fields

Fields

Descriptions

Id

Unique identifier that identifies an Basic service.

Origin

Allows to select origin values from dropdown list

 Active

To indicate if the service type is Active or Restrictive.

Fiscal Year

Fiscal Year of the basic service hired.

Institution Code

Code of Institution OCE OEP identified by Institutional Classifier. Unique identifier. The system should present a list of values for selection by the user or search functionality. Only one Institution can be linked.

Vendor

Unique code that identifies of Vendor beneficiary that offers the Basic service hired. This field will be defaulted if Vendor Beneficiary ID is selected. The user can change it. Only one Vendor Beneficiary can be linked.

Customer Name

Name of who belongs or enjoys the basic service hired. Manually entered by the user.

Contract Number

Unique number that identified a Contract by basic service hired. This is fundamental to the Budget Implementation Units (PIU), may have Contract for any service. This field will be defaulted if Contract ID is selected. The user can change it.

Language

Country Specific language

Name

Description the basic service hired by office

Service Type Id

Unique code that identifies of Service Type hired. This field will be defaulted if “Service Type ID” is selected. The user can change it. Only one Service Type can be linked.

Office Type Id

Unique code that identifies of office type where basic service is hired. This field will be defaulted if Office Type ID is selected. The user can change it. Only one Office Type can be linked.

Other Feature

Any Other Feature that is used by any of the basic services. Manually entered by the user.

Contact

Contact of hired Basic Service, such as e.g. number of phone / fax, electronic mail, etc. Manually entered by the user.

Created By

Populated automatically by the system.

Created Date

Default current system date and time. Populated automatically by the system at creation time of the record.

 

 

Meter Type

Overview

This entity contains the list of types of meter for basic services.

Navigation

Expenditures ► Basic Services ► Support Entities ► Meter Type

Basic Services Screen Fields

Fields

Descriptions

Id

Unique identifier that identifies a meter type.

Active

To indicate if the meter type is Active or Restrictive.

Meter Type Origin

Allows to select origin values form dropdown list

Language

Country Specific Language

Name

Description the meter type. It can be Digital Display (LCD) or Cyclometer. Manually entered by the user.

Created By

Populated automatically by the system.

Created Date

Default current system date and time. Populated automatically by the system at creation time of the record.

 

Office Type

Overview

This entity contains the list of types of office (location) for basic services.

Navigation

Expenditures ► Basic Services ► Support Entities ► Office Type

Office Type Screen Fields

Fields

Descriptions

Id

Unique identifier that identifies an Office Type.

Origin

Allows to select origin values from dropdown list

 Active

To indicate if the service type is Active or Restrictive.

Institution

Code of Institution OCE OEP for Office Type. The system should present a list of values for selection by the user or search functionality.

Managed Contract

Number of Leasing Contract is mandatory when the office ‘Is not State', verify the number of Leasing Contract in Contract Management. Only shows Leasing Contracts of the Institution. Only one Contract Managed can be linked.

Region

Code of Region identified by Geographical Classifier. Unique identifier. Only one Region can be linked.

Language

Country Specific language

Name

This attribute is automatically entered by the system according to attribute "Unit of Measure"

Office Address

Office Address (include geographic location). Manually entered by the user.

Created By

Populated automatically by the system.

Created Date

Default current system date and time. Populated automatically by the system at creation time of the record.

 

Service Type

Overview

This entity contains the list of types of basic services which reflect State Obligations.

Navigation

Expenditures ► Basic Services ► Support Entities ► Service Type

Service Type Screen Fields

Fields

Descriptions

Id

Unique identifier that identifies a service type.

Origin

Allows to select origin values from dropdown list

 Active

To indicate if the service type is Active or Restrictive.

Is HaveMeter

To indicate if the Service Type have a meter or not. It will establish if exist a meter or not (by example: Water or Power). False by Default.

Fiscal Year

Default current Fiscal Year where ‘Current Fiscal Year Budget Execution’ is True.

Service Class

Allows to select service class from dropdown list

Unit Of Measure

This field will be defaulted if Catalogue ID is selected. The user can change it. Only one unit of measure can be linked. Can be duplicated in all Service Type entity

Object Expense Code

System will show a List of Elements restricted to definition in the Parameter where Concept Id is equal

Language

Country Specific language

Name

This attribute is automatically entered by the system according to attribute "Unit of Measure"

Created By

Populated automatically by the system.

Created Date

Default current system date and time. Populated automatically by the system at creation time of the record.

 

 

Consolidation Of Financial Statements And Budget Execution

Automatically Import Consolidation

Overview

The Automatically Import Consolidation feature allows to consolidate financial statements and budget execution aoutomatically for the selected organization.

A screenshot of the Automatically Import Consolidation feature is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to system parameters, rendering control configuration and installed revision.

Users access the report from within the menu through this navigation path: General Ledger ► Consolidation Of Financial Statements and Accounting Institutions ► Automatically Import Consolidation.

 

Visible Fields

The following table lists and describes all visible fields for the Automatically Import Consolidation feature, 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
Fiscal YearThe field allows users to select the fiscal year for the consolidation.
Fiscal PeriodThe field allows users to select the fiscal period for the consolidation.
Consolidation TypeThe consolidation type is displayed in this field.
Sector ElementIt allows users to define the CoA element code of the Sector for the process.
Organization ElementIt allows users to define the CoA element code of the Organization for the process.

 

 

 

 

 

 

 

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 expense voucher feature.

Button ImageDescription
The Lookup tool allows users to browse and select existing items. Once selected, all available information automatically populates the corresponding fields.
The Execute button allows users to start the process.

 

 

 

 

 

 

Consolidation Equivalences

Overview

Obtain and publish the execution of the budget, sum and represents the situation financial budgetary consolidated of the entire Non-Financial Public Sector.

Navigation

Expenditures ► Consolidation Of Financial Statements And Budget Execution ► Consolidation Equivalences

Consolidation Equivalences Screen Fields

Fields

Descriptions

Id

Consecutive unique number, automatically generated and assigned by the system.

Active

Default True

Consolidation Type

Allows to select consolidation type from dropdown list

Base Concept

List of concepts associated to the COA Group

 

Consolidation Equivalences Rules

Consolidation Equivalences Rules Tab Screen Fields

Fields

Descriptions

Serial Number

Consecutive unique number, automatically generated and assigned by the system.

Origin Base Concept Object

The user should be able to do roll up to the Highest level of the Concept.

Origin Concept

Select the origin concept from dropdown list.

Origin Concept Object

Lookup button. Elements from Origin Concept. The user should be able to do roll up to the Highest level of the Concept.

Origin Debit/Credit

Select the origin debit/credit from dropdown list.

Destination Base Concept Object

Lookup button. Element from Consolidation Equivalences Base Concept. The user should be able to do roll up to the Highest level of the Concept.

Destination Concept

List of concepts associated to the COA Group

Destination Concept Object

Lookup button. Elements from Destination Concept. The user should be able to do roll up to the Highest level of the Concept.

Is Amount Validation

Default False

Priority

Select the Priority from dropdown menu

 

Consolidation Master

Overview

 

Navigation

Expenditures ► Consolidation Of Financial Statements And Budget Execution ► Consolidation Master

Consolidation Master Screen Fields

Fields

Descriptions

Code

Unique identifier. Consecutive unique number, automatically generated and assigned by the system.

Fiscal Year

Default Actual Fiscal Year.

Fiscal Period

Only shows Fiscal Periods with Status ‘CLOSED’

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Consolidation Type

Select the consolidation type from dropdown menu

Sector Element

Select the sector element from lookup field

Organization Element

Select the organization element from lookup field

Created By

User who created the record.

Created Date

Date and time of creation. Default current system date and time. Populated automatically by the system at creation time of the record.

Approved By

User who approved the Cutoff Validations. Populated automatically by the system, when the Consolidation Master is approved.

Approved Date

Date and time in which the Consolidation Master turns to ‘Approved’ Status

 

Consolidation Of Financial Statements And Budget Execution Report

Overview

This report shows the final consolidated information of Statement of Financial and Budget Execution for the Current Fiscal Year and the selected Fiscal Period for all the institutions from the Non Financials Public Sector.

Navigation

Expenditures ► Consolidation Of Financial Statements And Budget Execution ► Consolidation Of Financial Statements And Budget Execution Report

Consolidation Of Financial Statements And Budget Execution Report Screen Fields

Fields

Descriptions

Fiscal Year

List of values. User select Fiscal Year.  This parameter is mandatory and shows the current fiscal year by default.

Fiscal Period From

Users can select the starting fiscal period of the current or previous Fiscal Year from which the they want to generate report.

Fiscal Period ToUsers can select the end fiscal period of the current or previous Fiscal Year from which the they want to generate report.
Budget Control TypeMandatory - User can select the required Budget Control Type from the dropdown list.

Hierarchy Rollups Coa Elements

 Allow Hierarchical Selection from Organization Segment of the CoA.

Coding Block Filter Type

Select the coding block type from dropdown menu

Coding Block

Any element (s) or range of elements of any concept of any segment included in the parameter Budget Execution COA Group for Consolidation.

SegmentUsers can be able to select the available segments as per their selection requirement.
ConceptThe user should be able to select a concept that belongs to the selected segment.

 

Import Manual Consolidation

Overview

Import manual consolidation allows the user to import the consolidation of Financial Statements through the Excel file.

Navigation

Expenditures ► Consolidation Of Financial Statements And Budget Execution ► Import Manual Consolidation

Import Manual Consolidation Screen Fields

Fields

Descriptions

Fiscal Year

Default: Actual Fiscal Year, Read Only field

Fiscal Period

Only shows Fiscal Periods with Status ‘CLOSED’

Consolidation Type

Select the Budget Execution for consolidation type

Sector Element

Select the sector element from lookup field

Organization Element

Select the organization element from lookup field

Upload File

Upload the file from the system related to this entity

 

Expenditure Classifications

Execution Type

Navigation

Expenditures ► Expenditure Classifications ► Execution Type

Execution Type Tab Screen Fields

Fields

Description

Id

Unique code that identifies the category of staff

Language

Country specific language

Description

Description the category of staff

Operation

List of one to many Sub Module Catalog assigned to this Module Catalog

 

 

Expenditure Classification

Overview

Entity that contains the types of expenditure to be incurred in the subsystem of trips and per diem.

Navigation

Expenditures ► Expenditure Classifications ► Expenditure Classification

Expenditure Classification Screen Fields

Fields

Description

Id

Unique code that identifies the category of expenditure.

Institution

ID of the Institution

Expenditure Classification Module

Allows to select the module from dropdown list

Offset Code

Offset Coding Block. COA Group with attribute 'Budget Execution' equal to 'True'. 

Treasury Bank Account

The system will allow the user to only select "Use of Treasury Bank Accounts " 

 

Operation

Navigation

Expenditures ► Expenditure Classifications ► Operation

Operation Tab Screen Fields

Fields

Description

Id

Unique code that identifies the category of staff

Language

Country specific language

Description

Description the category of staff

 

 

Expense Voucher

Objective:

The Expense Voucher function is used to record all type of expenditures of the organization. An Expense Voucher(EV) can be created manually to record non-procurement or direct expenditures or can be created automatically through other functions where expenditures are created such as Procurement, Payroll, etc. For each EV approved, the system will automatically create a corresponding debit and credit journal voucher entry. These vouchers can be viewed and verified using the Journal Vouchers function in the General Ledger module. The system will automatically update any General Ledger, Budget, Allotment and Commitment/Obligation records that are affected by the transaction.

Navigation:

Expenditures ► Expense Voucher.

Expense Voucher Screen Fields and Tabs:

FieldsDescription
Fiscal YearFiscal Year of the voucher, Default value is current (FY).
Fiscal PeriodThis allows selecting the fiscal period for the expense voucher. By default system shows the current fiscal period which is open for the transactions. 
Voucher IDA unique voucher ID which is generated by the system or the user can enter manually. It depends on the system setting.
Voucher DateIt shows the system current date automatically. The system does not allow the user to enter the future voucher date.
Expense Voucher ClassificationIt allows the user to classify the Expense Vouchers according to his needs. The user can select the voucher classification using the drop-down button.
Accounting OfficeUsers need to insert Accounting Office Code. Accounting office means division or institution. 
Workflow StatusIt shows the status of the workflow depending on the Workflow Configuration Setting. The basic stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.
Is Revolving Fund ExecutionIndicates if EV is for execution with Revolving Funds. The default value is unchecked.
Posting StatusThis field is a 'Display Only' field and will be updated by the system when the voucher is either saved (then the attribute is updated to Saved) or temp saved (then the attribute is updated to Temp Saved.
Temp NumberSerial Number generated by the system when the voucher is in Temp Saved stage.
Not Posted ReasonThe users will select a reason for not posting the voucher when the voucher is Temp Saved, the field should be cleared automatically when the voucher is (completely saved).
OriginThe origin of the expense voucher. It is used by the workflow transition.
External Source VoucherIt is Read-only field updated by the system if the Voucher Source is ‘Other External Source”.
Batch NumberThis is a read-only field that shows the Batch Number for imported EVs.
CurrencyThis field allows the users to select the Voucher Currency. The default value is Domestic currency.
Exchange RateIt shows the current foreign currency exchange rate if the expense voucher has foreign currency. It comes from the exchange rate table.
Is TemplateTo indicate if the EV can be used as a template for recurring vouchers.
Template NameFiled to mention the template name for retrieval purpose. If "Is Template" flag is true, this is a mandatory field otherwise, this is a non-mandatory field. 
Is recur next periodAn indicator to automatically duplicate the EV next period and Temp Save it upon period closing. The default is No.
Total Amount (Domestic) A calculated field that Displays the Total domestic amount of all EV Items. The default value is Zero.
Total Gross Amount (Domestic)The system displays the Total domestic amount of all EV Items.
Total Amount (Foreign)This calculated fields displays the Total foreign amount of all EV Items. The default value is Zero.
Total Gross Amount (Foreign) The system displays the Total foreign amount of all EV Items.
Is Automatic GeneratedIndicate if the Expense Voucher was Automatically Generated by the system through other function or manually created by the user, the default value is False. If the value of this attribute is True, then the system will not allow editing the Expense Voucher.
Purchase Order Related Expense VoucherExpense voucher is related to purchase order or not. If this flag is True, purchase order needs to select in the next field, called “Purchase Order”.
PO Uses Multiple Coding BlocksThe default value for this checkbox is False. It indicates that the related Purchase order has multiple coding blocks.
Revenue Refund Related Expense VoucherThis indicates the expense voucher is related to revenue refund. The default value is False.
Is Pre PaidIndicates if the voucher is related to a prepaid expenditure. The default is based on the selected Accounting Method in the GL Parameters. If Cash Basis is selected, then the default value is True and the field cannot be changed by the user. Otherwise, the default value is False.
Paid StatusIt updated automatically by the system when payment is issued against the voucher. The following are possible values: ‘No’, ‘Partially’’, ‘Yes’. If ‘Prepaid’ equals Yes then the value of ‘Paid’ equals Yes, else default value is No
VendorIn this field, the user enters the vendor code for the expense voucher. The user can select the vendor using the lookup feature.
Is Pay AgentIt indicates that the Vendor acts as a Pay Agent to other Vendors. The default value is FALSE. 
Pay AgentIt identifies if the Vendor acts as a Pay Agent to other Vendors. Default value FALSE
Invoice NumberThis input box contains the Vendor’s Invoice Number, which needs to enter manually.
Invoice DateVendor’s Invoice Date. Invoice Date must be less than or equals the Expense Voucher Date.
Invoice Receipt DateInvoice Receipt Date is the date mentioned on the invoice or invoice creation default current system date. Invoice Receipt Date must be greater than or equals the Invoice Date.
Payment LocationLocation of the payment. The default value will be populated automatically from the selected vendor information if defined, if not defined in the Vendor, it will be populated from the selected Institution, if not defined in the Institution then the default populated as defined in the Expenditures Parameter. 
Payment ModeThe default value populated automatically from the selected vendor information if defined, if not defined in the Vendor, it will be populated from the selected Institution, if not defined in the Institution then the default value populates as defined in the Expenditures Parameter.
Treasury Bank AccountThe Bank account from which the payment will be issued. Only bank accounts linked to the selected treasury bank account and having the same currency as the voucher will be allowed.
Offset CodeThis is the Accounts Payable GL offset code. Not required if the voucher is prepaid. The default value is populated automatically from the Vendor information. If not defined in the vendor it will be populated from the Institution and if not defined there, from the Expenditures Parameters.
Payment TermsThis is not required if EV is prepaid. The value will be updated from the vendor information if defined otherwise, the default will be as defined in the Expenditures Parameters.
Payment On HoldThis field indicates if the payment is on Hold and should not be included within the payment process.  The default is No.
Created ByThe user information who has created the Expense Voucher.
Created DateThe date of the Expense Voucher created.
Approved ByThe Approver user information display after final approval of the Expense Voucher.
Approved DateIt shows the approval date of the Expanse Voucher.
Is Revolving FundIndicates if EV is for execution with Revolving Funds. The default value is unchecked.
Is Executes ProjectIt indicates whether the record is the execution of externally funded projects. Default value false.
Project External FinancingA unique identifier that identifies an ID of the project. IF the EV It does not have a document Obligation associated then Displayed through List of Values.
Is Linked to DisbursementIdentifies a link a Disbursement Request Voucher. Automatically generated when the process is running.
Disbursement Request VoucherUnique ID that identifies a Disbursement Request Voucher.
Is AccountingIndicate if EV is accounting purpose. Default Value is unchecked.
Is Voucher Of CorrectionIt is updated automatically by the system if the EV was created as a result of an Annulation of EV of correction voucher. By default it is unchecked.
Is Voucher Of RefundIt is updated automatically by the system if the EV is refunded through the refund function. By default it is unchecked.
Is Pending To Move As Floating DebtIt is controlled by rendering control and the system parameter the system will recognize automatically the Floating Debt during the fiscal year closure is True. By default it is unchecked.
Is Moved As Floating DebtIt is controlled by rendering control and the system parameter the system will recognize automatically the Floating Debt during the fiscal year closure is True. By default it is unchecked.
Document TypeA unique code that identifies the document type
No. Supporting documentThe document number that supports the transaction.
Contract NumberUsed to input the Contract or PO number of EV is manually created. If EV is generated from PO this field will be disabled.
Revolving DocumentIf the source voucher is a 'Revolving Fund' Hyperlink will open a 'Read Only' screen Revolving Document
Journal Voucher Void CorrectionIt shows the ID of the JV auto-generated when the EV is void. JV ID will be populated by the system user can't change its value.
LanguageThe system allows selecting the language using the drop-down list. The default language system shows as English.
DescriptionThe description of the expense voucher in the selected language.
Expense Voucher Line Item TabWhen Expense Voucher is related to a Purchase Order, then the system automatically populates this information EV item accordingly with the values coming from GRN (amounts and quantity). The user adds the Expense voucher line items using this tab.
Payment Details TabCollection of one to many payment details. Default as per the selected Payment Terms.
Attachments TabAllows attaching files that may be relevant for the EV. Each file may have a Title, Description, Date, User, and document language (see details in document “How to Perform Common Tasks”).

 

Attachments

Overview

The system allows attaching files to support the purchasing process.

Attachments Tab screen fields:

Attachments screen includes the following fields:

FieldsDescription
IdConsecutive number auto generated by the system. It will be unique within the system.
Attachment ClassificationIt provides privilege to the user to select the document type for example pdf, Docs, etc.
LanguageThe user can select the language from the drop-down list. The default language is English.
TitleTitle of the Attachments
DescriptionDescription of the attachments
AttachmentThe system allows to select and upload supporting file. The file type can be: pdf, doc, xls, jpg, etc
Date TimeDate of attachment generated by the system.
DateThe user can select the date using the calendar feature.
UserThe user information.

 

Expense Voucher Line Item

Overview

When Expense Voucher is related to a Purchase Order, then the system automatically populates this entity EV item accordingly with the values coming from GRN (amounts and quantity).  Users cannot change values coming from PO Item and or Good Receive/Return Note Detail.

Expense Voucher Line Item screen fields and Tab:

Fields

Description

Serial Number

This is Auto-generated item serial number field. Starts at 1 for every new Expense Voucher.

Amount (Domestic)

Line Item domestic amount is mentioned here. The default value is Zero. EV line item domestic amount will be populated automatically by the system if users import obligation item. In the case of EV Related to Purchase Order, EV line item domestic amount field will be automatically filled by the system against the purchase order (after adjusting Receive or Return Note).

 Amount (Foreign)

Line Item foreign amount is mentioned here. The default value is Zero. 

Credit/Debit

Allows to select credit/Debit from the dropdown list

Tax Amount Domestic

This is display only field that shows the Domestic Tax amount calculated by the system.

Tax Amount Foreign

This is display only field that shows the Foreign Tax amount calculated by the system.

Net Amount Domestic

This field displays the only field that shows the Domestic net amount calculated by the system after including taxes. If all taxes included in the price, then net amount = amount.

Net Amount Foreign

This field displays the only field that shows the foreign net amount calculated by the system after including taxes. If all taxes included in the price, then net amount = amount.

Refund Amount DomesticIt indicates the Total amount refunded for the voucher in domestic currency. 
Refund Amount ForeignIt indicates the Total amount refunded for the voucher in foreign currency.
Is Deduction RetentionIndicate that Line Item is a Deduction. By default it is unchecked.
Sub Ledger TypeRead Only for the user, when a general parameter that sub-ledger is in use is TRUE.
Coding BlockFull Coding Block of the Expense Voucher. This is a mandatory field. Users can change the value of the coding block.
Is Advance Recovery

By default is unchecked. If the user checked it then the Advance Code, Advance Recovery Amount details should be input by the user.

Language

Users can select from the languages dropdown menu to use to register the description of the EV Line Item.

Description

Line Item Description is mentioned in this field.

 

Expense Voucher Payment Detail

Overview

The Expense Voucher Payment Details will be used to create the Payment Distribution of the invoice amount defined in the Expense Voucher. If the payment items are manually created, the first payment item amount will default with the total invoice value, the user can change the amount. When the second payment item amount is created, the payment amount will default with the remaining invoice amount, and so on.

Expense Voucher Payment Detail Screen Fields:
 

Fields

Descriptions

Serial Number

This is Auto-generated payment item serial number. Starts at 1 for every new Expense Voucher.

Payment Due Date

Default date as per Payment Terms defined in the Expense Voucher (EV) header. Users can change payment due date. This is a mandatory field.

Payment Amount (Domestic)

Default as created by the system based on payment terms specified in the EV header. Users can change their value. 

Payment Amount (Foreign)

Default as created by the system based on payment terms specified in the EV header. Users can change their value.

Paid

Indicate if the payment has been paid.

Refund

Indicate if the Payment Detail was refunded.

Is Deduction Retention

Indicate Deduction Retention if payment is associated with a Deduction that is enabled for Payments.

Interest Rate

The interest rate that will be applied if the payment exceeds the due date.

Interest Date

The date when the system will start calculating interest on the payment.

Is Interest On Original Value

If True, the interest will be calculated against the original invoice value, if False, it will be calculated against the due payment value.

 Interest Amount (Domestic)

Updated by the system after the payment is released to show the Domestic interest amount if any.

Interest Amount (Foreign)

Updated by the system after the payment is released to show the Foreign interest amount if any.

Discount Rate

The discount rate that will be applied if the payment is released before the due date.

Discount Date

The date when the system will start calculating the discount on the payment.

Is Discount On Original Value

If True, the discount will be calculated against the original invoice value, if False, it will be calculated against the due payment value.

Discount Amount (Domestic)

Updated by the system after the payment is released to show the Domestic interest amount if any.

Discount Amount (Foreign)

Updated by the system after the payment is released to show the Foreign interest amount if any.

Is Suspended Payment

To indicate if the payment has been suspended through the ‘Payment Suspension’ Process. Suspended Payments will not be processed within the Payment function and cannot be released. Extracted Payments cannot be suspended.  Default is False

Net Payment Amount (Foreign)

This is calculated, display the only field to show the Net Domestic payment (cheque) amount. Domestic Payment Amount + Interest Amount – Discount Amount.

Net Payment Amount (Domestic)

This is calculated, display the only field to show the Net Foreign payment (cheque) amount. Foreign Payment Amount + Interest Foreign Amount – Discount Foreign Amount.

Is Extracted Payment

Display the only field to indicate if the payment has been extracted into a draft payment or released. Default=No.

Payment Method

Updated automatically if defined within the vendor information, otherwise, a default will be as defined in the Expenditures Parameters.

Cheque Series

Display the only field that gets updated by the Payment function. If EV is prepaid, this field gets updated manually by the user.

Cheque Number

Display only field that gets updated by the Payment function. If EV is prepaid, this field gets updated manually by the user.

Cheque Date

Display only field that gets updated by the Payment function. If EV is prepaid, this field gets updated manually by the user.

Handling Indicator

Allows users to define their own indicators for the payment.

Language

Users can select the language for payment details tab. 

Stub Details

User-defined stub details that will be printed on the cheque stub. 

Suspension Reason

The particular scenario for which the payment detail of an expense voucher is suspended

Resume suspension reason

Activating the suspension reason again is resume suspension reason

Journal Voucher

Redistribute costs from one or more accounts to several other accounts. Correct posting errors and record and track general ledger-related transactions posted into the system

 

Expense Voucher Batch Generation

Overview

The purpose of Expense Voucher Batch Generation is to retrieve information on a batch of Expense Vouchers by creating a unique batch Id for Expense Vouchers in a batch relating to a particular Accounting Office in relation to a particular Fiscal Year.

Navigation 

Expenditures ► Expense Voucher Batch Generation.

FieldDescription
Batch IdUnique identification code of Expense Voucher Batch Generation.
Batch DateDate on which Expense Voucher Batch is created.
Created ByUsers by whom Expense Voucher Batch is generated.
OriginSource or Origin of Expense Voucher to be selected from dropdown box.
StageStage at which the Expense Voucher stands to be selected from dropdown box.
Accounting OfficeAccounting Office to which Expense Voucher relates to be selected from lookup button.
Fiscal YearFiscal Year to which Expense Vouchers relate to be selected from dropdown box.

 

Expense Voucher Target Stage

Overview

The purpose of Expense Voucher Target Stage is retrieve information on Expense Vouchers or a particular Expense Voucher at a particular stage of workflow process or in a particular status in workflow process.

Navigation

Expenditures ► Expense Voucher Target Stage. 

Expense Voucher Target Stage Screen Fields

FieldsDescription
Fiscal YearFiscal Year to which the Expense Voucher relates to be selected from dropdown box.
Fiscal PeriodFiscal Period to which the Expense Voucher relates to be selected from dropdown box.
Expense Voucher OriginOrigin of Expense Voucher is mentioned in this field for filtering purpose. It may be from Contract Management, Data Import, Manual, Payment Request, Payroll Request, Payroll and Template.
Target StageTarget Stage at which Expense Voucher stands is selected from the dropdown box. Stages of Expense Voucher are: Created, Approval Requested, Approved, Rejected and Closed.
Voucher Date FromStart Date which would be considered for filtering data on Expense Voucher.
Voucher Date ToEnd Date which would be considered for filtering data on Expense Voucher.
Vendor Vendor to which the Expense Voucher relates to be selected from lookup button.
Expense Voucher TypeType of Expense Voucher to be selected from lookup button. To take an example, EV Type 1 Payroll.
Accounting OfficeRelevant accounting office for the Expense Voucher to be selected from lookup button.
Treasury Bank AccountRelevant Treasury Bank Account for the Expense Voucher to be selected from lookup button.
Domestic Amount FromAmount of Expense Voucher from which the filter applies.
Domestic Amount ToAmount of Expense Voucher up to which the filter applies.
Purchase Order Relevant Purchase Order, if any related to Expense Voucher to be selected for filtering data.
Invoice NumberField contains Vendor’s Invoice Number, which need to enter manually.
Expense Voucher SourceSource of Expense Voucher to be selected from dropdown box. For example, it may be Assets, Contract Management, etc.
Expense Voucher ClassificationClassification to which the Expense Voucher belongs to be selected from dropdown box.
Payment LocationLocation of Payment for Expense Voucher to be selected from dropdown box.
Payment ModeMode of Payment to be selected from dropdown box.
CurrencyThis field allows the users to select the Voucher Currency. Default value is Domestic currency.
Expense Voucher RangeRange of Expense Voucher or a particular Expense Voucher for which data to be retrieved, to be selected as per requirement.

 

 

Expense Voucher Work Flow Tracking

Overview

This screen allows users to track the expense voucher workflow. Once users hit the button 'Get Results' a summary of the EVs according to filters selected and DAS of the logged in user is presented. The main screen has hyperlinks in amounts when users click on any of those hyperlinks, the system displays the EV list which comprised the summary result.

Navigation

Expenditures ► Expense Voucher Work Flow Tracking
 
Expense Voucher Work Flow Tracking Screen Fields

Fields

Descriptions

Fiscal Year

Dropdown to select Fiscal Year Filter criteria.

Fiscal Period 

Filter criteria for Fiscal Period.

Institution TypeDropdown to select Institution Type Filter.
InstitutionLookup for select Institution as filter criteria.
Workflow Stage fromFrom Workflow stage of EV that may be selected as filter criteria.
Workflow Status ToTo Workflow stage of EV that may be selected as filter criteria.
Treasury Bank AccountLookup for select Treasury Bank Account as filter criteria
VendorLookup for select Vendor as filter criteria.

 

Grants

Distribution Of Transfer

Overview

Entity containing the registration and control of the programming or planning the execution of all entities receiving grants where the commitment is programmed with quarterly periods and  the YTD Actual on a monthly basis.

Navigation

Expenditures ► Grants ► Distribution Of Transfer

Distribution Of Transfer Screen Fields

Fields

Description

Code

Unique code automatically generated by the system

Fiscal Year

Fiscal Year of the voucher, Default current FY 

Budget Office

Budget Office ID. Read only attribute in the update mode

Grantee

Unique code that identifies the Entities receiving grants

Source Of Income Specified

System will show a List of Elements (rollup) restricted to definition in the Parameter, where Concept Id is equal System String Parameter “Financing Source"

Item Code Group Expenditure

System will show a List of Elements (rollup) restricted to definition in the Parameter where Concept Id is equal System String Parameter “Expenditure Group"

ERT Programmation Ytd Actual Detail

Collection of one to many ERT programmation YTD Actual Details

 

ERT Programmation Ytd Actual Details

Overview

Entity containing the registration and control of the programming or planning the execution of all entities receiving grants where the YTD Actual is programmed with monthly periods.

ERT Programmation Ytd Actual Details Screen Fields

 

Fields

Description

 Sequence #

Auto generated, start from 1, for each ERT Programmation Obligations Details

Fiscal Period

Configuration Setting for this Entity the basic Stages are:

1. Quarter = ‘1st Quarter’ then Sequence of the Fiscal Period include 1,2,3

2. Quarter = ‘2nd Quarter’ then Sequence of the Fiscal Period include 4,5,6

3. Quarter = ‘3rd Quarter’ then Sequence of the Fiscal Period include 7,8,9

4. Quarter = ‘4th Quarter’ then Sequence of the Fiscal Period include    10,11,12 

Programmation Amount

Programming period. Value default = 0

Execution Amount

Execution period. Value default = 0

 
 
 

Document Of Budget Management ERG

Overview

This is a Management document that records the lifecycle of each transaction of the assignments or changes to the budget of each recipient institutions grants.

Navigation

Expenditures ► Grants ► Document Of Budget Management ERG

Document Of Budget Management ERG screen fields

Field

Description

Code

Unique identification code.

Fiscal Year

Fiscal Year of the voucher. Default: current Financial Year.

Fiscal Period

Fiscal Period of the voucher. Default: current period.

Workflow StatusThis field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are:‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'.The default value is 'Created'.

Voucher Date

Shows the Voucher date. By Default shows System date.

Budget Office

This field contains budget office Id.

Grants Record Type

The basic Stages are ‘Increase’, ‘Decrease’, ‘Transfer’. By default set as 'Increase'.

Grants Document Type

Unique code that identifies the document type.

No Of Supporting Document

No. of document that supports the transaction.

Legal Provision

Number that supports movement to the budget.

Legal Provision Date

Date on which the Legal Provision passes.

 

Total Value Of Transaction

The value of total transaction which is not editable by the user.

Created By

Populated automatically by the system.

Created Date

Populated automatically by the system during creation time of the record.

Approved By

Populated automatically by the system, when the doccument gets approved.

Approved Date

Populated automatically by the system during time and date of the doccument approval.

 

Details ERG

Overview

Details of the Management document that records the lifecycle of each transaction of the assignments or changes to the budget of each recipient institutions grants.

 

Details ERG screen fields

Field

Description

Sequence Number

Unique Number for Each Document Of Budget Management ERG. This number is System Generated.

Grantee

Catalog that contains the characteristics of receiving grants. 

Coding Block

Coding block information depending on grant attribute.

Total

This field is for the total value of transaction. The Value should not be Zero.

 

Document Of Execution ERG

Overview

This is a Management document that records the lifecycle of each transaction of the execution to the budget of each recipient institutions grants.

Navigation

Expenditures ► Grants ► Document Of Execution ERG

Document Of Execution ERG screen fields

Field

Description

Code

Unique identification code.

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Fiscal Year

Fiscal Year of the voucher. Default: current Financial Year.

Fiscal Period

Fiscal Period of the voucher. Default: current period.

Voucher Date

Shows the Voucher date. By Default shows System date.

Budget Office

This field contains budget office Id.

Execution Type

The basic Stages are ‘COM’, ‘DEV’, ‘CYD’. By default set as 'COM'.

Source Document Number

Number of the source doccument

Document Type

Unique code that identifies the document type.

No Of Supporting Document

No. of document that supports the transaction.

Total Value Of Transaction

The value of total transaction which is not editable by the user.

Deduction Amount

Automatically recorded by the system. Default value is zero.

Total Amount

Total Value of the transaction.

Is Revolving Fund Execution

Indicates if ERG Voucher is for execution with Revolving Funds. Default Value = FALSE

Is Multifold Funding Source

Checked if the management will be paid with different funding sources. Default is unchecked.

Executes Project

It indicates whether the record is execution of externally funded projects. Default value false.

Project Id

Unique identifier that identifies an ID of project.

Treasury Bank Account

If multifold funding source is unchecked, then the field is enable. Here, user must select payer account. If multifold funding source is checked then the is field disable.

Bank Account Number

System automatically displays the bank account number.

Bank Account Bank Name

System automatically displays the bank account bank name.

Language

Country Specific Language

Description

Describes the concept of the Transfer

Created By

Populated automatically by the system.

Date and Time of Creation

Populated automatically by the system during creation time of the record.

Approved By

Populated automatically by the system, when the doccument gets approved.

Date Approved

Populated automatically by the system during time and date of the doccument approval.

Entities Receiving Transfer Detail

Details of entities receiving grants of Management documents that records the lifecycle of each transaction of the execution to the budget.

ERG Paying Account

Collection of one to many Paying Account

 

ERG Paying Account

Overview

Details of Paying Account of Management documents that records the lifecycle of each transaction of the execution to the budget.

 

ERG Paying Account screen fields

Field

Description

Serial Number

Unique Number for Each Document Of ERG Paying Account. This number is System Generated.

Treasury Bank Account

Government’s Bank Account from where the payment gets issued. Only Bank Accounts (linked to the selected treasury bank account) having the currency same as the voucher currency is allowed.

Bank Account Number

System will automatically display the bank account number.

Bank Account Bank Name

System will automatically display the bank account bank name.

 
Total Value Of Payment

Total value of payment, for an account.

 

Entities Receiving Transfers Details

Overview

Details of entities receiving grants of Management documents that records the lifecycle of each transaction of the execution to the budget.

 

Entities Receiving Transfers Details screen fields

Field

Description

Serial Number

Unique Number for Each Document Of Entities Receiving Transfers Details. This number is System Generated.

Grantee

Unique code that identifies the Entities receiving grants.

Item Code

Item cose related to Grant Id.

Total Value Of Transaction

Total Amount When Currency is Domestic.

Amount Deduction

Amount deduction is automatically recorded by the system.

Total Amount

Total value of transaction. Read only.

No. Document of expense

No. Document of execution of expense. Automatically assigned by the system. When the document is "approved".

 

Deduction Details

Overview

This Tab contien the deductions details to the record and control the Document of execution ERG .

 

Deduction Details screen fields

FieldsDescription
Serial Number

Unique serial number generated by the system.

Deduction and Retention

Deduction and retention details. The system should present a list of values for selection by the user or search functionality.

Deduction Type

System will automatically display the Offset code for Deduction Type

Offset Code

System will automatically display the Offset code.

Deduction name

System will automatically display the Deduction name.

Retention origin

Retention origin should be manually entered by the user.

Domestic Amount

Amount value of Deduction Details, Where Currency is Domestic.

 

ERG Project structure

Overview

This Tab contains the list of project structures by “Grants” that must be related with details of the “Document of execution ERG (Voucher)”.

 

ERG Project structure screen fields

FieldsDescription
Serial Number

Unique serial number generated by the system.

Is Counterpart

Check box to genrate ERG Project structure as a counterpart. By default unchecked. 

Domestic Amount

Amount value of Project Structure, Where Currency is Domestic.

 

Grant

Overview

Registration and monitoring of allocations and modifications budget for each entity receiving grants

Navigation

Expenditures ► Grants ► Grant

Grant Screen Fields

Fields

Description

Code

Unique code automatically generated by the system

Fiscal Year

Fiscal Year of the voucher, Default current FY 

Institution

Allows to select institution from lookup field

Grantee

show all list active grantee related 

Item Code

Select a Coding block from Fiscal Year

Initial Budget

Initial Budget of the Entities receiving grants

Increases

Additions to the budget of the Entities receiving grants  

Decrease

Decreases the budget of the Entities receiving grants

Reallocations

Transfer from another Entities receiving

Budget Current

Initial Budget + Increase - Decrease + Reallocation

Obligation

Cumulative Obligation executed. Default = 0

YTD Actual

Cumulative YTD Actual executed. Default = 0

Non YTD Actual Funds

Obligation – YTD Actual. Read only attribute

Balance Budget

Budget current – Obligation. Read only attribute

 

Nicaragua Grants Reports

Distribution Of Transfers Report

Navigation

Expenditures ► Grants ► Nicaragua Grants Reports ► Distribution Of Transfers Report

Distribution Of Transfers Report Screen Fields

Fields

Description

Fiscal Year

Allows to select fiscal year from the dropdown list

Fiscal Period

Allows to select fiscal period from the dropdown list

 Comment

Allows to write a comment about this repot

 

Nicaragua Reports

Grants Detail Report

Overview

Shows all the information related to Grants.

Navigation

Expenditures ► Grants ► Nicaragua Reports ► Grants Detail Report

Grants Detail Report Screen Fields

Fields

Description

Fiscal Year

Current Fiscal Year

Fiscal Year

Current Fiscal Period

Comment

Allows to write comment on this report

Hierarchy Rollups Coa Elements

By default it must have selected in the Coding Block Filter Type the option Hierarchical Coding Block Elements.

 

Support Entities

Grantee

Overview

Catalog that contains the characteristics of entities receiving grants. 

Navigation
 
Expenditures ► Grants ► Support Entities ► Grantee
 
Grantee Screen Fields
 

Fields

Description

Code

Unique code automatically generated by the system

Active

To indicate if the transfer entity is: restrictive or not restrictive

Origin

Default is MANUAL. Read only field

Institution

Allows to select Institution from lookup field

Grants Type

Grants type, unique id.

Language

Country specific language

Description

Name of the entity receiving transfer

Vendor

Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity.

Vendor Bank Number

This field will always be automatically populated with Vendor Bank Account

Document Identification Number

Document identification.

Created By

Populated automatically by the system

Created On

Populated automatically by the system at creation time of the record.

Modified By

Populated automatically by the system when corresponding workflow reaches its last modified stage

Modified On

Populated automatically by the system

 

Grants Type

Overview

Entity that has the list of types of grants which reflects the state's obligations.

Navigation

Expenditures ► Grants ► Support Entities ► Grants Type

Grants Type Screen Fields

Fields

Description

Id

Unique code that identifies type transfer.
read only attribute

Active

To indicate if the transfer type is active or restrictive.

Language

Country specific language

Description

Description the type transfer

Origin

Allows to select origin from dropdown list

 

Multi-Vendor

Multi Vendor Expense Voucher

Overview

Documents containing the registration and control of the management of Multi-vendor expenditure voucher. And linkage to budgetary expenses and accounting documents.

Navigation

Expenditures ► Multi-Vendor ► Multi Vendor Expense Voucher

Multi Vendor Expense Voucher Screen Fields

Fields

Description

Code

Auto-Generated

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Fiscal Year

Current Fiscal Year. The fiscal year should be open for the transactions.

Fiscal Period

Current Fiscal Period. The fiscal period should be open for the transactions.

Institution

Institution code for the expense voucher.

Execute Type

Configuration Setting for this Entity the basic Stages are:

‘CYD’ (Obligation + Actual), ‘REG’ (Obligation + EV, Prepaid), Default = ‘CYD’

Voucher Date

Default current system date. Read Only Field

Document Type

Unique code that identifies the document type

No Supporting Document

No. document that supports the transaction.

Language

Country specific language

Description

Description voucher

Currency

To allow the user to select the Voucher Currency. Default is Domestic Currency.

Exchange Rate

Will show the latest active exchange rate for the selected currency which is linked to Expenditures, 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. Default is 1

Total Amount (Domestic)

“Calculated/Updated Read Only Field” displays the amount domestic of all MvEV Items. Default is Zero

Total Amount (Foreign)

“Calculated/Updated Read Only Field” displays the Amount Foreign of all MvEV Items. Default is Zero

Deduction Amount Domestic

“Calculated/Updated Read Only Field” displays the Deduction Amount Domestic of all MvEV Items. Default is Zero

Deduction Amount Foreign

“Calculated/Updated Read Only Field” displays the Deduction Amount Foreign of all MvEV Items. Default is Zero

Total Net Amount Domestic

Total value of transaction. Total Net Amount Domestic = Total domestic amount - Deduction Domestic Amount

Total Net Amount Foreign

Total value of transaction. Total Net Amount Foreign = Total foreign amount - Deduction Foreign Amount

Revolving Fund RegisterRevolving fund code enter in the field. The user can select with the help of lookup button.

Treasury Bank Account

Institution code user can enter using lookup button to pick one.

Offset Code

The system must automatically load the value of the attribute where if Is Revolving Fund Execution” = ‘TRUE’ and Fund ID has a valid number

Created By

Populated automatically by the system

Created Date

Populated automatically by the system at creation time of the record.

Approved By

Populated automatically by the system, when the document is approved.

Approved Date

Populated automatically by the system in time of approved for registration

 

Multi-Vendor Expense Voucher Detail

Overview

Documents containing the registration and control of the management of Multi-vendor expenditure voucher detail.

Multi-Vendor Expense Voucher Detail Screen Fields

Fields

Description

Serial Number

Unique code that identifies the Multi-vendor expenditure details. Automatically generated by the system

Language

Country specific language

Description

Describe Multi-vendor expenditure details.

Vendor

Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity.

Coding Block

Full Coding Block, COA Group with attribute 'Budget Execution' = True

Amount (Domestic)

“Calculated/Updated Read Only Field” displays the Amount Domestic of all Project Structure. Default is Zero

Amount (Foreign)

“Calculated/Updated Read Only Field” displays the Amount Foreign of all Project Structure. Default is Zero

Total Amount (Domestic)

The system must automatically calculate the value.

Total Domestic = Amount Domestic - Deduction amount domestic

Total Amount (Foreign)

Total Domestic = Amount Foreign - Deduction Amount Foreign

Deduction Amount Domestic

Amount Domestic value of deduction

Deduction Amount Foreign

Amount Foreign value of deduction

Refund Amount Domestic

Attribute read only, Value default = 0

Refund Amount Foreign

Attribute read only, Value default = 0

Is Reversed

Read Only Field” will be updated automatically by the system

Is Refund

Read Only Field” will be updated automatically by the system

Is Correction

Read Only Field” will be updated automatically by the system

Number of Document Expense

No. Document of execution of expense. Automatically assigned by the system. When the document is "approved"

Cheque SeriesThe cheque series information.
Cheque NumberCheque number.
Error MessageTo input the error message.

 

Multi Vendor Deduction Details

Overview

The tab allows the user to enter the information of the multi vendor deductions.

Multi Vendor Deduction Details

FieldsDescription
Serial NumberSerial number of the multi vendor deduction.
DeductionDeduction information. The user can select using lookup feature.
Deduction TypeType of the deduction for the multi vendor.
Retention OriginOrigin of the retention.
Amount (Domestic)Dedutction amount in domestic currency.
Amount (Foreign)Dedutction amount in foreign currency.

 

Multi Vendor ReSumit

Overview

System must allow to Resumit a Multi-Vendor Detail with Errors. System must allow to Find, Select, UnSelect and Remove all Multi-vendor expenditure detail with Error Message.

Navigation

Expenditures ► Multi-Vendor ► Multi Vendor ReSumit

FieldsDescription
Multi Vendor Expense VoucherIt allows the user to enter the unique code of the Multi expense voucher, or user can select using lookup button.
Multi-vendor expenditure detailDetails of the multi vendor expenditure.

 

Project External Financing

Annual Financial Plan

Overview

This entity contains the list of “Annual financial plan” for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Annual Financial Plan

Annual Financial Plan Screen Fields

Fields

Descriptions

Code

Unique ID that identifies a Annual financial plan. Consecutive unique number automatically generated by the system.

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Fiscal Year

Fiscal Year of the Annual financial plan. Default current Fiscal Year where ‘Current Fiscal Year Budget Execution’ is True.

Institution

System will automatically display the Institution Code, based on the attribute "Institution Name" from Institution entity

Project ID

Unique identifier that identifies a Project with external financing.

Type

Allows to select type from dropdown list.

Plan Date

Default current system date.

Project Amount Dc

Calculated field, Display only. Shows Total Domestic Amount for the Annual financial plan

Counter Part Project Amount Dc

Calculated field, Display only. Shows Total Domestic Counterpart Amount for the whole Plan

Total Project Amount Dc

Calculated field, Display only. Total Domestic Project Amount” = “Domestic Project Amount” + “Domestic Counterpart Project Amount”

Created By

User who created the Project Plan. Populated automatically by the system.

Created Date

Date and time of creation the Plan Project with External Financing. Default current system date and time.

Approved By

User who approved the Plan Project with External Financing. Populated automatically by the system, when the document is approved.

Approved Date

Date and time in which the Plan Project with External Financing document turns to ‘Approved’ Status. Default current system date and time.

 

Annual Financial Plan Details

Overview

This entity contains the list of Annual financial plan Details for Projects with external financing.

Annual Financial Plan Details Tab Screen Fields

Fields

Descriptions

Sequence Number

Unique ID that identifies the Annual financial plan detail. It’s a consecutive number automatically generated by the system.

Fiscal Period

Fiscal Period of the voucher, manually update by the user

Project Current Account

Project Current account belongs to the Project external Financing in the header

Agreement Amount

Assigned Agreement Amount of Project Plan. Manually entered by the user 

Domestic Amount

Assigned Domestic Amount of Project Plan.

 

Disbursement Request Application Voucher

Overview

This is used to record the Disbursement Request regarding expenditure done by a Spending Agency for submission to Donor for release of funds.

Navigation
 
Expenditures ►  Project External Financing ► Disbursement Request Voucher-BTMS
 
Disbursement Request Application Voucher Screen and Tabs
 
FieldsDescriptions
CodeA unique identification code generated by the system.
Workflow StatusThe workflow status of the Disbursement request application voucher. By default, its value is Created. It changes as per the approval stage.
Fiscal YearThe default value is the current Fiscal year. It allows the user to select the fiscal year for the Disbursement request application voucher, it should be open for the financial transactions.
Expending AgencyExpanding agency id, it holds the details of the spending agency. User can enter manually or select it using the lookup button.
Project External FinancingA unique identifier that identifies a Project with external financing.
Debt InstrumentInstrument the EVs area related to.
Voucher DateThe system automatically fetches the system current date.
TrancheThe tranche of the related instrument. User has to enter the details.
CurrencyThe default value is the country's domestic currency. The user can change it.
Total Domestic AmountThe total expense voucher details amount Domestic.
Total Foreign AmountThe total expense voucher details amount foreign.
Email CommentsAdditional comments to be sent via email to the Donor.
Created ByThe system automatically fetches the user details who has created the Disbursement Request Application Voucher.
Created DateThe system fetches the current system date.
Approved ByThe user ID of the approver, it is automatically fetched by the system when the voucher gets approved.
Approved DateThe current system date when the voucher gets approved.
Disbursement Request Application Details TabDetails of Expense Vouchers related to the Disbursement Request Voucher.
AttachmentsThis allows the user to attach the document for the Disbursement Request Application Voucher.
 
 
 

Attachment

Overview

This tab allows the user to attach the document for the Disbursement Request Application Voucher.

 Attachment Screen and Tabs

FieldsDescriptions
IDThe unique identification code for the attachment.
Attachment ClassificationThe user selects the document type from the drop-down list.
TitleTitle for the attachment.
DescriptionDescription of the attachment.
AttachmentThis feature allows the user to attach the file from the system.
Date TimeIt fetches the system current date and time.
DateThe user can enter the date using the calendar feature.
UserSystem fetches the user details.

 

Disbursement Request Application Details

Overview

It records the expense voucher details which is related to a disbursement request expenditure done by spending agency. User selects the expense voucher which is linked to DR voucher.

Disbursment Request Application Details Screen and Tab

FieldDescription
Expense VoucherThe expense voucher code user needs to enter. The user can select it using the lookup feature.

Disbursement Request Voucher

Overview

This entity contains the list of Disbursement Request Voucher, these are the documents containing the registration and control of the management of project with external financing. And linkage to budgetary expenses and accounting documents.

Navigation
Expenditures ► Project External Financing ► Disbursement Request Voucher
 
Disbursement Request Voucher Screen Fields
 

Fields

Descriptions

Id

Unique ID that identifies a Disbursement Request Voucher.

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Fiscal Year

Fiscal Year of the Disbursement Request Voucher.

Fiscal Period

Fiscal Period of the voucher, Default current period

Institution

Unique identifier. Manually entered by the user. Or automatically assigned by the system according to parameter ‘Automatic Institution Unit ID’.

Project External Financing

Unique identifier that identifies a Project with external financing.

Agreement Project

Unique identifier that identifies an Agreement of project.

Disbursement Type

Unique identifier of Disbursement Type for Project with External Financing associated with Disbursement Request Voucher. Only one Disbursement Type can be linked.

Disbursement Request Voucher Date

Default current system date and time. Populated automatically by the system at creation time of the record.

Language

Country specific language

Disbursement Request Voucher Name

Voucher description, describes the Disbursement Request.

Date

By default, is Null, but can be manually entered by the user

Reference Number

Reference Number. Manually entered by the user.

Disbursement Request Date

Date and time Request of disbursement. Manually entered by the user

Item Code Financial Organism

System will automatically display the Elements to definition in the attribute “Item code financial organism” the entity Agreement Project

Is First Disbursement

Manually entered by the user. Value default False

Is Forwarded

Indicates the forwarded. Manually entered by the user. if True, was forwarded to higher level.

Is Submitted

Indicates the submitted. Manually entered by the user If True, was submitted to higher level.

Is Received ORG

Indicates the received by ORG. Manually entered by the user. If True, was received by ORG to higher level.

Received Date ORG

Date and time of received by ORG to higher level. Automatically populated by the system in time of received by ORG, but the user can modified.

Submitted Date

Date and time of Submitted. Automatically populated by the system in time of submit, but the user can modified

Requested Date

Date and time of Requested.

Real Account

Real Monetary Account of Project with External Financing associated with Disbursement Request Voucher.

Scriptural Account

Scriptural Monetary Account of Project with External Financing associated with Disbursement Request Voucher.

Currency

 

Exchange Rate

Exchange rate, of the Agreement Currency

Total Amount Requested(Domestic)

Displays the “Total Domestic Amount Requested” of all Disbursement Expense Details “attribute Domestic Requested mount”.

Total Amount Requested(Foreign)

Displays the “Total Foreign Amount Requested” of all Disbursement Expense Details “attribute Foreign Requested Amount”.

Total Amount Submitted(Domestic)

Displays the “Total Domestic Amount Submitted” of all Disbursement Expense Details “attribute Domestic Submitted mount”

Total Amount Submitted(Foreign)

Field Calculated/Updated, Display Only” displays the “Total Foreign Amount Submitted” of all Disbursement Expense Details“ attribute Foreign Submitted Amount”

Total Amount Disbursed(Domestic)

Field Calculated/Updated, Display Only” displays the “Total Domestic Amount Disbursed” of all Disbursement Expense Details “attribute  Domestic Disbursed Amount”

Total Amount Disbursed(Foreign)

“Field Calculated/Updated, Display Only” displays the “Total Foreign Amount Disbursed” of all Disbursement Expense Details “attribute  Foreign Disbursed Amount”

Beneficiary

Beneficiary Name associated with Disbursement Request Voucher.

Financial Institution Intermediary Name

Intermediary Financial Institution Name associated with Disbursement Request Voucher.

Financial Institution Depository Name

Depositary Financial Institution Name associated with Disbursement Request Voucher.

Created By

User who created the Disbursement Request Voucher. Populated automatically by the system.

Creation Date

Date and time of creation the Disbursement Request Voucher. Default current system date and time.

Approved By

User who approved the Disbursement Request Voucher. Populated automatically by the system, when the document is approved.

Approved Date

Date and time in which the Disbursement Request Voucher document turns to ‘Approved’ Status. Default current system date and time.

 

Disbursement Expense Details

Overview

This entity contains the list of Disbursement Expense Details that must be disbursed.

Disbursement Expense Details Tab Screen Fields

Fields

Descriptions

Expense Voucher

Expense Voucher Number corresponding to Expense Voucher.

Submitted Amount Dc

Submitted Amount corresponding to Disbursement Requested Voucher when Currency is Domestic.

Submitted Amount Fc

Submitted Amount corresponding to Disbursement Requested Voucher when Currency is not Domestic.

Disbursed Amount Dc

Disbursed Amount corresponding to Disbursement Requested Voucher when Currency is Domestic.

Disbursed Amount Fc

Disbursed Amount corresponding to Disbursement Requested Voucher when Currency is not Domestic.

 

Multiyear Financial Plan

Overview

This entity contains the list of “Multiyear financial plan” for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Multiyear Financial Plan

Multiyear Financial Plan Screen Fields

Fields

Descriptions

 Id

Unique ID that identifies a Multiyear financial plan.

Fiscal Year

Fiscal Year Default current FY

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Institution

Name of Institution. System will automatically display the Institution Code, based on the attribute "Institution Name" from Institution entity.

Project ID

Unique identifier that identifies a Project with external financing. Only one Project External Financing can be linked.

Plan Date

Default current system date and time. Populated automatically by the system at creation time of the record.

Type

Allows to select type from dropdown list

Domestic Project Amount

Calculated field, Display. Only Shows Total Domestic Amount for the Multiyear financial plan,

Domestic Counterpart Project Amount

Shows Total Domestic Counterpart Amount for the whole Plan,

Total Domestic Project Amount

Calculated field, Display only

Created By

User who created the Project with External Financing.

Created Date

Date and time of creation the Plan Project with External Financing.

Approved By

User who approved the Plan Project with External Financing. Populated automatically by the system, when the document is approved.

Approved Date

 Date and time in which the Plan Project with External Financing document turns to ‘Approved’ Status

 

Multiyear Financial Plan Details

Overview

This entity contains the list of Multiyear financial plan Details for Projects with external financing.

Multiyear Financial Plan Details Tab Screen Fields

Fields

Descriptions

Sequence Number

Unique ID that identifies the Multiyear financial plan detail.

Fiscal Year

Fiscal Year of the Multiyear financial plan details. Default current Fiscal Year where ‘Current Fiscal Year Budget Execution’ is True. User can modify the year

Project Current Account

Allows to select project current account from search functionality

Agreement Currency

Agreement currency of Line Plan.

Agreement Amount

Assigned Agreement Amount of Project Plan.

Domestic Amount

Domestic currency of Line Plan.

 

Nicaragua Reports

 

 

Reconciliation Of Bank Resource Report

Overview

The purpose is to list information related to agreement and disbursement request. 

Navigation

Expenditures ► Project External Financing ► Nicaragua Reports ► Reconciliation Of Bank Resource Report

Reconciliation Of Bank Resource Report Screen Fields

Fields

Descriptions

Fiscal Year

Current Fiscal Year

Disbursement Request Voucher

Select the disbursement request voucher from search functionality.

Comment

Any comment defined by the user in the generation screen of the report

 

Status Of Project Execution

Overview

Control report to determine the execution status of each investment project at the level of expenditure categories, in national currency and currency of origin, by each funding agency and by national counterpart funds. Summarized by each source of financing, by each funding agency, indicating the data of the current budget, cumulative execution by categories of investment and available balances.

Navigation
Expenditures ► Project External Financing ► Nicaragua Reports ► Status Of Project Execution
 
Status Of Project Execution Screen Fields
 

Fields

Descriptions

Fiscal Year

Current Fiscal Year

Project Structure

If the user does not define any filters in the text, 'None' will appear. There is a drop-down list for selecting multiple filters (Component, Sub-Component, Development Action).

Currency

Display only the currencies defined for Nicaragua. (Ex: The filter should have the values: Cordoba, Dollars, Euros).

Print Amount

Allow the report to be filtered by Cordobas / thousands / millions. Based on the criteria selected by the user in this parameter, apply these criteria to display the amounts in the columns of the report.

Monetary Account

Must be selected by the user, otherwise display all accounts.

Entity OCE/OEP

It must be selected by the user, otherwise it presents all the entities.

Financial Organism

Display the name of all the Financial Organisms. Must be selected by the user, otherwise display all data

Source

Display the name of all the Sources. Must be required by the user, otherwise show all sources

Specific Source

Display the name of all the Specific Sources. Must be required by the user, otherwise show all sources

Number Of Agreement

Must be required by the user, otherwise show all agreements

Project

Must be required by the user, otherwise show all projects.

Comment

Any comment defined by the user in the generation screen of the report

 

Project current account

Overview

This entity contains the Current Account for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Project Current Account

Project current account Screen Fields

Fields

Descriptions

Id

Unique identifier that identifies a Project current account.

Institution

Id of the Institution code

Project ID

Unique identifier that identifies an ID of project.

Agreement ID

Unique identifier that identifies an Agreement of project.

Project Structure Code

Unique identifier that identifies a project structure code.

Expense Category Code

Unique identifier that identifies a Expense category code.

Counterpart

Default value false

Initial Assigned Amount

Default value zero

Reallocations Amount

Default value zero

Executed Amount Obligation

Default value zero

Executed Amount EV

Default value zero

Available Amount

Automatically calculated by the system

Initial Assigned Amount Agreement

Default value zero Read-only

Reallocations Amount Agreement

Default value zero Read-only

Executed Amount Obligation Agreement

Default value zero Read-only

Executed Amount EV Agreement

Default value zero Read-only

Available Amount Agreement

Automatically calculated by the system

 

Reallocation Voucher

Overview

This entity contains the list of Reallocation for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Reallocation Voucher

Reallocation Voucher Screen Fields

Fields

Descriptions

Code

Unique ID that identifies a Reallocation Voucher. Consecutive unique number automatically generated by the system.

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Voucher Type

Allows to select voucher type from dropdown list

Fiscal Year

Fiscal Year of the Disbursement Request Voucher.

Fiscal Period

Fiscal Period of the voucher, Default current period

Institution

Name of Institution. System will automatically display the Project Structure Code, based on the attribute "Institution Name" from Institution entity

Project External Financing

Unique identifier that identifies a Project with external financing. Only one Project External Financing can be linked.

Voucher Date

Default current system date and time. Populated automatically by the system at creation time of the record.

Document Type

Unique code that identifies the document type

Supporting Document Number

No. document that supports the transaction

Legal Provision

Number supporting legal of the reallocation

Legal Provision Date

Date on which passed the legal provision

Project Amount Domestic

Shows Total Domestic Amount for the whole Reallocation

Counterpart Project Amount Domestic

Shows Total Domestic Amount for the whole Reallocation

Total Project Amount Domestic

Calculated field, Display only. Total Domestic Project Amount” = “Domestic  Project Amount” + “Domestic  Counterpart Project Amount”

Created By

User who created the Project with External Financing. Populated automatically by the system.

Created Date

Date and time of creation the Project with External Financing. Default current system date and time.

Approved By

User who approved the Project with External Financing. Populated automatically by the system, when the document is approved.

Approved Date

Date and time in which the Project with External Financing document turns to ‘Approved’ Status. Default current system date and time. Populated automatically by the system in time of approved for registration.

 

Reallocation Voucher Details

Overview

This entity contains the list of Reallocation Details for Projects with external financing.

Reallocation Voucher Details Tab Screen Fields

Fields

Descriptions

Agreement Project

System will automatically display the Elements to definition in the Parameter where Concept Id is equal System string Parameter  " Agreement" 

Agreement Exchange Rate

Exchange rate, Domestic Currency of Project with external financing.

Project Structure Element

Name of Project Structure.

Expense Category Element

Name of Expense Category.

Is counter Part

It indicates whether the amount corresponds to funds domestic or counterpart.

Agreement Amount

Assigned Agreement Amount of Project with external financing.

Domestic Amount

Assigned Domestic Amount of Reallocation.

 

Support Entities

Disbursement Type

Overview

This entity contains the list of Disbursement type for Projects with external financing.

Navigation

Expenditures ► Project External Financing ► Support Entities ► Disbursement Type

Disbursement Type Screen Fields

Fields

Descriptions

Id

Unique ID that identifies the Disbursement type.

Language

Country specific language

Name

Short name of disbursement type. Manually entered by the user.

Description

Name or description of disbursement type. Manually entered by the user.

Active

To indicate if the Disbursement Type is Active or Restrictive.

 

Project External Financing

Overview

This entity contains the list of Project with External Financing which are opening management.

Navigation

Expenditures ► Project External Financing ► Support Entities ► Project External Financing

Project External Financing Screen Fields

Fields

Descriptions

Id

Unique ID that identifies the Project External Financing

Fiscal Year

Fiscal Year Default current FY 

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Institution

System will automatically display the Project Structure Code, based on the attribute "Institution Name" from Institution entity.

Element

System will automatically display the Elements

Project Status

Basic Stages are: ’In process’, ’Execution’, ‘Finalized’, ‘Suspended’ Default = ‘In Process’

Opening Date

Opening date of Project with external financing. Manually entered by the user.

Closing Date

Closing date of Project with external financing.

Account Closing Date

Accounting Closing date of Project with external financing. Manually entered by the user. Default is Null.

Eligibility Date

Eligibility date of Project with external financing. Manually entered by the user. Default is Null.

Last Disbursement Date

Updated date of last disbursement for Project with external financing. Attribute Read Only. Default is Null.

Language

Country specific language

Name

Short name of Project with external financing according to their characteristics. Manually entered by the user.

Description

Full name of Project with external financing according to their characteristics.

Analytics Description

Analytics name of Project with external financing according to their characteristics.

Loan Condition

Loan conditions of Project with external financing.

Authorized No

Authorized No. of Project with external financing.

Project Manager

Project Manager of Project with external financing.

Domestic Project Amount

Shows Total Domestic Amount for the whole agreements,

Disbursement Project Domestic Amount

Shows the total amount of the sum of "Disbursement Domestic Amount" attribute of the entity Agreement Project for all agreements related to Project ID. 

Domestic Counterpart Project Amount

Shows Total Domestic Amount for the whole agreements, the attribute “Domestic Amount” of the entity Agreement Project where the attribute “Counterpart” = True

Total Domestic Project Amount

Total Domestic Project Amount” = “Domestic Project Amount” + “Domestic Counterpart Project Amount”

Snip Code

Code of project, allocated in the SNIP (National Public Investment System) for Project with external financing.

Created By

User who created the Project with External Financing.

Creation Date

Date and time of creation the Project with External Financing.

Approved By

User who approved the Project with External Financing.

Approved Date

Date and time in which the Project with External Financing document turns to ‘Approved’ Status. Default current system date and time.

 

Agreement Project

Overview

List of one to many Agreements assigned to this Project with External Financing.

Agreement Project Tab Screen Fields

Fields

Descriptions

Correlative

Unique identifier that identifies a Agreement. It's assigned automatically by application. Attribute read only. Correlative Number

Sigade Code

Code of loan, allocated in the SIGADE (Management System and Debt Analysis) for Project with external financing. Manually entered by the user.

Agreement No

Code of Agreement. Manually entered by the user.

Is Counter Part

It indicates whether the amount corresponds to funds domestic or counterpart. Default value = false

Agreement Currency

Agreement currency of Project with external financing. Selection by the user manually.

Agreement Exchange Rate

Exchange rate, of the Agreement Currency. Read-only if the currency is Local then Exchange Rate = 1

Agreement Amount

Agreement Amount of Project with external financing.

Amount (Domestic)

Agreement Currency is Foreign then it will be read only auto calculated, if the currency is Local then its manually entered

Disbursement Foreign Amount

Automatically calculate and will be populated by the Revenues module

Disbursement Domestic Amount

Automatically calculate and will be populated when an Invoice Document related to "Agreement No" is Approved.

Country

Country director of the agency

Intermediary Bank

Intermediary bank of Project with external financing. Selection by the user manually. drop down

Financial Organism

System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “Financial Organism" 

Specified Source

System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “Financing source" 

Financing Source

System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “Specified source"

Treasury Bank Account

Unique identifier of Bank Account Number associated with one Treasury Bank, Agreement Account.

Special Account Bcn

Unique identifier of Bank Account Number associated with one Treasury Bank, Special Account in BCN (Central Bank of Nicaragua).

Language

Country specific language

Abbreviation

Abbreviation or Short name of the Agreement.

Description

Full name of the Agreement.

 

Line Project

Overview

This entity contains the list of the Project Structure and Expense category, with amounts allocated.

Line Project Tab Screen Fields

Fields

Descriptions

Correlative

Unique identifier that identifies a Line of Project with external financing.

Agreement Amount

Assigned Agreement Amount of Project with external financing.

Amount (Domestic)

Assigned Domestic Amount of Project with external financing for the Line item

Project Structure

System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “Project Structure"  

Project Structure Name

Name of Project Structure. System will automatically display the Project Structure Name, based on the attribute "Project Structure Code" from Element entity.

 Expense Category

System will automatically display the Elements to definition in the Parameter where Concept Id is equal System String Parameter “CATEGORY_EXPENSE" 

Expense Category Name

Name of Expense Category. System will automatically display the Expense Category Name, based on the attribute "Expense Category Code" from Element entity.

 

 

Reports

Expense Voucher List By Voucher# Report

Overview

This report essentially serves as a log of all expense vouchers (Eexpense Vouchers and Expense Vouchers related to Purchase Orders) within a specified numerical range that have been posted over a given period of time. This report provides total expense vouchers for each period and grand total for all periods being specified.

Navigation

Expenditures ► Reports ► Expense Voucher list by Voucher # Report

Expense Voucher List by Voucher # Report Screen Fields

FieldsDescriptions
Fiscal YearThis field contains the Financial Year for which report will be generated
Fiscal Period FromBeginning limit for the period covered in the report.
Fiscal Period ToEnd limit for the period covered in the report.
Work Flow StatusUsers can select any options from available six options for generate the report. Options are Approved Request, Approved, Cancelled, Created, Rejected and Template.
Posting StstusFilter option for status of the transactions in the system. Options are Saved and Temp Saved.
SourceThe source of the expense voucher is mentioned in this field to generate the report. Available options are Temp and Temp Saved.
TypeThe type of voucher to be displayed in report, either ‘Against a PO’, ‘Regular Expense’, or ‘Both’.
Recurring EVsIf checked indicates that the expense vouchers are recurring. Only recurring EV will displayed in the report.
From DateBeginning limit of the posting date for the expense vouchers covered in the report.
To DateEnd limit of the posting date for the expense vouchers covered in the report.
Coding BlockThe Coding Block for the Expense Voucher List by Voucher # Report. Users can mention specific coding block for generate specific coding block wise report. 
Coding Block DescriptionA description of the coding block. This section is automatically generated and defines each segment in the coding block with regards to what group it represents in the chart of accounts.
Financial InstitutionThis field indicates the Financial Institution for generate Expense Voucher List by Voucher report. 
VendorUsers can look up and select a vendor as filter criteria for the Expense Voucher List by Voucher Report. 
Voucher Accounting OfficeThis field indicates the Accounting Office for generate report. Users can selete the institution which is used as accounting office also.
Payment ModeUsers can look up Payment Mode here to generated payment mode wise report.
Payment LocationThis field indicates the Payment Location to generate specific payment location wise report. 
Treasury Bank AccountUsers can look up Treasury Bank Account here to generated specific Treasury Bank Account wise report. 

 

Laos Reports

Approved PV Batch Report

Navigation

Expenditures ► Reports ► Laos Reports ► Approved PV Batch Report

Approved PV Batch Report Screen Fields

Fields

Description

Fiscal Year

Default Value is Current Fiscal Year

Batch Date

Default value is Current Date, Expense Voucher Batch Generation matches with the batch Date

Batch Number

Drop down, display the List of batch Number matches with the batch date

Accounting Office

Institution Lookup. Logged User, Employee institution as a default

Comment

Allows to write a comment on this report

 

Laos Accounts Payable Report

Navigation

Expenditures ► Reports ► Laos Reports ► Laos Accounts Payable Report

Laos Accounts Payable Report Screen Fields

Fields

Description

Report Type

Allows to select the report type from the dropdown list

Fiscal Year

Default Current Fiscal Year.

Currency

Default blank, if its selected will get all the EV with selected currency

Payment Type

Allows to select the payment type from the dropdown list

GL Account Code

Display the drop down list of all the distinct object element code - description in the coding block of the OffsetCode table those matched in the Concept Offset Code Mapping table

Is Group By GL Account

Default value is TRUE

Vendor

Allows to select the vendor from the lookup field

Organization

Allows to select the organization from the lookup field

Treasury Bank Account

Allows to select the Bank Account from the lookup field

Include Vouchers On Hold

Default value if TRUE.

Include Payment Suspended

Default value is FALSE

Comment

Allows user to write a comment on this

 

Line Ministry Batch Report

Navigation

Expenditures ► Reports ► Laos Reports ► Line Ministry Batch Report

Line Ministry Batch Report Screen Fields

Fields

Description

Fiscal Year

Default Value is Current Fiscal Year

Batch Date

Default value is Current Date, Expense Voucher Batch Generation matches with the batch Date

Batch Number

Drop down, display the List of batch Number matches with the batch date

Institution

Allows to select Institution from lookup field

Comment

Allows to write a comment on this report

 

Progress Report Of Payments Against Annual Budget Report

Navigation

Expenditures ► Reports ► Laos Reports ► Progress Report Of Payments Against Annual Budget Report

Progress Report Of Payments Against Annual Budget Report Screen Fields

Fields

Description

Fiscal Year

Default Value is Current Fiscal Year

PV Workflow Stage

The stages in the Workflow process will have the custom key value as

1. Line ministry Approval (LM_APPROVAL)

2. Received Treasury (RECEIVED_TR)

3. Approved Treasury (APPROVED_TR),

4. Sent For Payment (SENT_FOR _PAYMENT)

5. Paid (PAID))

Is Paid

Tristate checkbox if the user selects True will displays the PAID EV's, if selects False then will displays the NOT_PAID EV's if the user selects empty then will be shown both the EV's

Comment

Allows to write a comment

Workflow Stage Date

From Date:  And To Date (default is current date the user can't change the to date)

Hierarchy Rollups Coa Elements

Selection of segment and concept as per Hierarchical COA option Group by.

 

Progress Report Of Payments By PV Numbers Report

Overview

The purpose of this report is to generate information regarding Payment Vouchers on the basis of Payment Voucher Number and their detailed information on progress status.

Navigation

Expenditures ► Reports ► Laos Report ► Progress Report of Payments by PV Number Report.

Progress Report of Payments by PV Number Report Screen Fields

Fields

Description

Fiscal Year

Fiscal Year to which the Payment Voucher relates to be selected as filter criteria.

Expense Voucher

Expense Voucher to which the Payment Voucher relates to be selected from the lookup button.

Vendor

Code of the vendor to whom the payment is to be made.

PV Workflow Stage

Stage of the Payment Voucher for which information is to be generated.

EV Paid Status

Whether report is to be generated for all expense vouchers or partially paid or not paid ones, is to be filtered in this field.

Comment

Comment on the report is made in this field.

EV Workflow Execution Step Date

Allows to select From date and To date to generate the report for specific dates.

 

Progress Report of Payments Against Budgets and Cash Allocation.

Overview

The purpose of this report is to generate detailed information regarding Payment Vouchers with respect to Planned Budget and Cash Allocation for a particular period.

Navigation

Expenditures ► Reports ► Laos Report ► Progress Report of Payments against Budgets and Cash Allocation.

Progress Report of Payments against Budgets and Cash Allocation Screen Fields

FieldsDescription
Fiscal YearFiscal Year to which the Payment Voucher relates to be selected as filter criteria.
PV Workflow StageStage of the Payment Voucher for which information is to be generated. Status of Payment Voucher Workflow may be: Line Ministry Approved; Approved by Head of Expenditure LM; Approved for Payment and Received in Treasury.
Is PaidWhether the Payment Voucher has been paid, is mentioned in this field.
As At Workflow Stage DateCurrent Date is shown by the system. It refers to end date up to which the information is to be shown in the report.
CommentComment on the report.
Coding Block Filter TypeInformation for the report is filtered on the basis on Coding Block which may be: Coding Block, Coding Block Expression Filter and Hierarchical Coding Block Element.

 

Tracking List Of Document Verifications Report

Navigation

Expenditures ► Reports ► Laos Reports ► Tracking List Of Document Verifications Report

Tracking List Of Document Verifications Report Screen Fields

Fields

Description

Fiscal Year

Default Value is Current Fiscal Year

Batch Date

Default value is current date

Batch Number

Display drop down list of the EV batch number for the selected batch date

Comment

Allows to write a comment on this report

 

Liberia Reports

Daily Expense Voucher Report

Overview

This report essentially serves as a log of all expense vouchers (EVs), Paid and Unpaid including Cheque Number and Number of days in Process for a specified date.

Navigation

Expenditures ► Reports ► Liberia Report ► Daily Expense Voucher Report

Daily Expense Voucher Report Screen Fields

FieldsDescription
Ministry & AgencyInstitution of Ministry & Agency to be selected from lookup button as filtering criteria.
Fiscal YearFiscal Year to which the Expense Voucher relates is to be selected from dropdown box
Paid StatusWhether the Expense Voucher has been paid in full or partially or not at all paid, is mentioned in this field as filtering criteria.
Posting Status: From DateStarting date of posting status from which date the data for report is filtered.
Posting Status: To DateEnd date of posting status up to which date the data for report is filtered.

 

Nicaragua Reports

Budget Balance of Revenue and Expenses Report

Overview

Generic report of Budget Balance of Revenue and Expenses Report.
 
Navigation
 
Expenditures ► Reports ► Nicaragua Reports ► Budget Balance of Revenue and Expenses Report
 
Budget Balance of Revenue and Expenses Report Screen Fields
 
FieldsDescription
Account Plan Group - IncomeAllows to select Income from the drop down list.
Account Plan Group - ExpenseAllows to select Expense from the drop down list.
Print AmountAllows to select Amount from the drop down list.
Fiscal YearCurrent FY with is open for Execution equal to TRUE
Fiscal Period FromFiscal Period with status is OPEN in list.
Fiscal Period ToFiscal Period with status is OPEN in list.
CommentOptional Parameter

Budget Control Actuals Per Financing Source Report

Overview

Generic report of expenditure execution, with financing source

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Budget Control Actuals Per Financing Source Report
 
Budget Control Actuals Per Financing Source Report Screen Fields

Fields

Descriptions

Budget Control Type

Budget Control Type selected by the User. Do not allow multi selection.

Fiscal Year

User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details.

Fiscal Period

Mandatory and display only, since report shows Period To Date allotment details.

Currency

Selection of Currency to show the data.

Concept

Allows to select concept from dropdown list

Comment

Optional.  This will be filled up after the report is printed.

 

 

Budget Control Current Vrs Obligations Report

Overview

Generic report of expenditure execution, Current vs Commitments and Obligations.

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Budget Control Current Vrs Obligations Report

Budget Control Current Vrs Obligations Report Screen Fields

Fields

Descriptions

Budget Control Type

Budget Control Type selected by the User. Do not allow multi selection.

Fiscal Year

User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details.

Fiscal Period

Mandatory and display only, since report shows Period To Date allotment details.

Currency

Selection of Currency to show the data.

Concept

Allows to select concept from dropdown list

Comment

Optional.  This will be filled up after the report is printed.

 

 

Budget Control Outstanding Amounts And Ratios Report

Overview

Generic report of expenditure execution, amounts and ratios.

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Budget Control Outstanding Amounts And Ratios Report

Budget Control Outstanding Amounts And Ratios Report Screen Fields

Fields

Descriptions

Budget Control Type

Budget Control Type selected by the User. Do not allow multi selection.

Fiscal Year

User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details.

Fiscal Period

Mandatory and display only, since report shows Period To Date allotment details.

Currency

Selection of Currency to show the data.

Comment

Optional.  This will be filled up after the report is printed.

 

Budget Control Outstanding Amounts Report

Overview

Generic report of expenditure execution.

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Budget Control Outstanding Amounts Report

Budget Control Outstanding Amounts Report Screen Fields

Fields

Descriptions

Budget Control Type

Budget Control Type selected by the User. Do not allow multi selection.

Fiscal Year

User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details.

Fiscal Period

Mandatory and display only, since report shows Period To Date allotment details.

Currency

Selection of Currency to show the data.

Concept

Allows to select concept from dropdown list

Comment

Optional.  This will be filled up after the report is printed.

 

Budget Control and Actuals by Economic Clasification Definition E Report

Overview

This reports allows users to analyze, by economic classification type, the entire financial position of the government or an institution, up to a certain fiscal period. If no period is selected the entire fiscal year is taken into consideration.

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Budget Control and Actuals by Economic Clasification Definition E Report

Budget Control and Actuals by Economic Clasification Definition E Report Screen Fields

Fields

Descriptions

Budget Control Type

Dropdown to select Budget Control Type filter for this report.

Fiscal Year

Dropdown to select Fiscal Year filter for this report.

Fiscal Period Initial

Dropdown select Initial Fiscal Period filter for this report.

Fiscal Period EndDropdown select End Fiscal Period filter for this report.

Comment

Any comment to add in the output report.

 

Budget Control and Actuals by Economic Clasification Report

Overview

Generic report of expenditure execution, with Economic classification.

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Budget Control and Actuals by Economic Clasification Report

Budget Control and Actuals by Economic Clasification Report Screen Fields

Fields

Descriptions

Budget Control Type

Budget Control Type selected by the User. Do not allow multi selection.

Fiscal Year

User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details.

Fiscal Period

Mandatory and display only, since report shows Period To Date allotment details.

Comment

Optional.  This will be filled up after the report is printed.

 

Consolidated Statement of Revenues and Expenditures Report

Overview

This report shows a Consolidated Statement of Revenues and Expenditures Report () for the Current Fiscal Year, based on the selected Fiscal Year and Budgetary Execution Group, and the Specified Financial Coding Block Grouping information.

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Consolidated Statement of Revenues and Expenditures Report

Consolidated Statement of Revenues and Expenditures Report Screen Fields

Fields

Descriptions

Fiscal Year

User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details.

Fiscal Period

List of values. User selects the Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period.

Comment

Optional.  This will be filled up after the report is printed.

Hierarchy Rollups Coa Elements

Allow the user to group and filter by any concept and range of elements belonging to the group of the Budget Control Type

 

Quarter Execution Nicaragua Reports

Budget Control Outstanding Amounts Quarter

Overview

Generic report of expenditure execution Quarter.

Navigation

Expenditures ► Reports ► Nicaragua Reports ►Quarter Execution Nicaragua Reports ► Budget Control Outstanding Amounts Quarter

Budget Control Outstanding Amounts Quarter Report Screen Fields

Fields

Descriptions

Budget Control Type

Dropdown to select Budget Control Type as filter criteria for this report.

Fiscal Year

Dropdown to select Fiscal Year as filter criteria for this report.

Fiscal Period Initial

Dropdown select Initial Fiscal Period as filter criteria for this report.

Fiscal Period EndDropdown select End Fiscal Period as filter criteria for this report.
CurrencyDropdown select Currency as filter criteria for this report
ConceptDropdown select Concept as filter criteria for this report

Comment

Any comment to add in the output report.

 

Budget Control Outstanding Amounts and ratios Quarter Report

Overview

Generic report of expenditure execution, amounts and ratios by Quarter.

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Budget Control and Actuals by Economic Clasification Report

Budget Control Outstanding Amounts and ratios Quarter Report Screen Fields

Fields

Descriptions

Budget Control Type

Dropdown to select Budget Control Type as filter criteria for this report.

Fiscal Year

Dropdown to select Fiscal Year as filter criteria for this report.

Fiscal Period Initial

Dropdown select Initial Fiscal Period as filter criteria for this report.

Fiscal Period EndDropdown select End Fiscal Period as filter criteria for this report.
CurrencyDropdown select Currency as filter criteria for this report

Comment

Any comment to add in the output report.

 

Revenues Budget Per Item And Collecting Unit Actuals Report / Presupuesto de Ingresos por Rubro Unidad Recaudadora

Overview

The Revenues Budget Per Item And Collecting Unit Actuals Report shows the amounts of revenue for each Collection Unit.

A screenshot of the Revenues Budget Per Item And Collecting Unit Actual Report/Presupuesto de Ingresos por Rubro Unidad Recaudadora 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: Expenditures ► Reports ► Nicaragua Reports ► Presupuesto de Ingresos por Rubro Unidad Recaudadora.

 

Filters

The following table lists and describes all filter for the Revenues Budget Per Item And Collecting Unit Actual 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.

FieldDescription
Print AmountThe field allows users to choose how the amount is going to be displayed in the report. 
Execution CoA GroupIt refers to the CoA Groups for the report.
Fiscal YearIt refers to the fiscal year for the report.
Fiscal Period FromThis field allows users to define from which fiscal period the report is to be generated.
Fiscal Period ToThis field allows users to define till which fiscal period the report is to be generated.
CommentThis field allows users to give any custom comment to the report.
Coding Block Filter TypeThis field allows users to select a coding block filter type for hierarchy rollups coding block element for the report. 
Coding BlockThe field is visible only when coding block filter type is coding block. It allows choosing the coding block of the report.
SegmentIt refers to the segments of the chart fo accounts.
ConceptIt refers to the concept of the selected segments of the chart fo accounts.

 

 

 

 

 

 

 

 

 

 

 

 

 

Visible Fields

A sample of the Revenues Budget Per Item And Collecting Unit Actuals Report output is available here. The following table lists and describes all visible fields for the Revenues Budget Per Item And Collecting Unit Actuals 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
ConceptThis column shows description of CoA Elements of the corresponding elements of each row.
Collecting Unit (Revenues)This column shows the amounts for the related selected report filters.
Collecting Unit (Customs Services)This column shows the amounts for the related selected report filters.
Collecting Unit (Treasury)This column shows the amounts for the related selected report filters.
Total IncomeThis is a calculated amount column, shows total 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 Revenues Budget Per Item And Collecting Unit Actuals Report.

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

 

 

 

 

 

 

 

 

 

Statement of Accumulated Investments by Expense Category Report

Overview

The purpose is to Investments by Expense Category.

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Statement of Accumulated Investments by Expense Category Report

Statement of Accumulated Investments by Expense Category Report Screen Fields

Fields

Descriptions

Fiscal Year

User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details.

Institution

Non-Mandatory. User can select a single value

Agency

Non-Mandatory. User can select a single value

Expense Category

Non-Mandatory. User can select a single value

Comment

Optional.  This will be filled up after the report is printed.

 

Status Of Cash Flow Report

Overview

Financial control report detailing the cash flow statement for each funding agency, by agreement / project.

Navigation

Expenditures ► Reports ► Nicaragua Reports ► Status Of Cash Flow Report

Status Of Cash Flow Report Screen Fields

Fields

Descriptions

Fiscal Year

User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details.

Fiscal Period

Current Period. User types Period. This parameter is mandatory.

Institution

Optional. If left blank, all OCE/OEP institutions are taking into consideration. User can only select valid OCE/OEP institutions.

Comment

Optional.  This will be filled up after the report is printed.

 

Philippines Reports

Alphabetical List Of Taxes Withheld From Suppliers Report

Overview

The Agency and Operating Unit prepare this report on each month and send this to BIR and COA to show the tax deduction based on the each each business class.

Navigation

Expenditures ► Reports ► Philippines Reports ► Alphabetical List Of Taxes Withheld From Suppliers Report

Alphabetical List Of Taxes Withheld From Suppliers Report Screen Fields

Fields

Descriptions

Fiscal Year

By default, show the current fiscal year. Based on requirement user can modify

Fiscal Period

Mandatory- Allow to select date single selection from the Fiscal Period. Print based on selection.

Organization

Mandatory - Allow to select from concept "Department" in the "Organization" Segment of UACS. Derived Department name from the concept "Department" which rolls up from the agency.  Single Selection.

Comment

Optional.  This will be filled up after the report is printed.

 

DV Pending for Payment

Overview

To analyze the DVs which are pending for payment including those which are partially paid.

Navigation

Expenditures ► Reports ► Philippines Reports ► DV Pending for Payment

DV Pending for Payment Screen Fields

Fields

Descriptions

Fiscal Year

This is mandatory. Defaults to current year. Allow selection of previous year.

Organization

Mandatory- Allow to select the concept from the organization segment. Show the only concept name (Example: Department/Agency/Operating Unit in the drop down. So, the user can select any one)

From Date

Mandatory - User to input period covered.

To Date

Mandatory - User to input period covered.

Comment

Optional.  This will be filled up after the report is printed.

 

Expanded Withholding Tax

Overview

The Agency and Operating Unit prepare this report on each month and send this to BIR and COA to show the tax deduction based on the each each business class. This report will show only the withholding tax.

Navigation

Expenditures ► Reports ► Philippines Reports ► Expanded Withholding Tax

Expanded Withholding Tax Screen Fields

Fields

Descriptions

Fiscal Year

By default, show the current fiscal year. Based on requirement user can modify

Fiscal Period

Mandatory- Allow to select date single selection from the Fiscal Period. Print based on selection.

Operating Unit

Optional- Allow Selection from concept "Operating Unit" in the "Organization" Segment of UACS. (Based on selection the point no 2 and 3 filled up corresponding with operating unit). Print based on selection

Tax Type

Mandatory-Allow to select the tax type for the tax table.

Comment

Optional.  This will be filled up after the report is printed.

 

Index of Payment Report

Overview

The Index of Payment is used by the Accounting Division/Unit to record/monitor payments made to each creditor/payee.  It shall be maintained by fund cluster.

Navigation

Expenditures ► Reports ► Philippines Reports ► Index of Payment Report

Index of Payment Report Screen Fields

Fields

Descriptions

Fiscal Year

Mandatory-Allow to select fiscal year. By default, show the current fiscal year.

From Date

Mandatory-Allow to select from date

To Date

Mandatory-Allow to select to date

Organization

Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS. By Default, it will show Agency but user can change to Operating Unit/Department.

Funding Source

Mandatory- Allow to select Fund cluster from concept "Fund cluster" it is roll up from "Authorization" in the Funding source segment of UACS. Print based on selection. Show the code and name of the fund

Vendor Classification

Optional-Single selection the category will come from the vendor category Table.

Vendor

Mandatory- Single selection allow to select the Vendor ID from the vendor table. Show the vendor ID with Name in the look up.

Comment

Comments made on the report

 

Regional BreakDown Of Expenses

Overview

This report is used by users to analyze the composition of expenses per region.

Navigation
Expenditures ► Reports ► Philippines Reports ► Regional BreakDown Of Expenses
 
Regional BreakDown Of Expenses Screen Fields

Fields

Descriptions

Fiscal Year

Mandatory dropdown filter. It allows users to select the Fiscal Year to generate the report. The default value is the current fiscal year.

Fiscal Period

Mandatory dropdown filter. It allows users to select fiscal month from the fiscal period.

Organization

Mandatory filter. Users can select Department / Agency / Operating Unit from the dropdown. Information is retrieved from the Organization segment of UACS. By default, it shows Agency but users can change to Operating Unit.

Fund Cluster

Allows users to select multiple concepts from "Fund Cluster" in the "Fund" segment of UACS. If none selected, values for all are displayed.

Allotment Class

Mandatory filter. Allows users to select allotment class from UACS, which is roll up from "Sub-major account group".

Comment

Comment to print on the output report.

 

Registry of Allotments and Notice of Transfer of Allocation Report

Overview

To determine the utilized amount against the NTA received and find out the remaining balance.

Navigation

Expenditures ► Reports ► Philippines Reports ► Registry of Allotments and Notice of Transfer of Allocation Report

Registry of Allotments and Notice of Transfer of Allocation Report Screen Fields

Fields

Descriptions

Fiscal Year

Mandatory-Allow to select fiscal year.

From Date

Mandatory - Date picker, allow to select From Date single selection

To Date

Mandatory - Date picker, allow to select To Date single selection

Operating Unit

Mandatory-Allow Selection from concept "Operating Unit" in the "Organization" Segment of UACS. 

Funding Source

Mandatory - Allow many selection from concept "Fund Source" in the "Fund" segment of COA. If none selected, value for all will be displayed.

Comment

Optional.  This will be filled up after the report is printed out.

 

Report of Advice to Debit Account Issued Report

Overview

This report used by the Disbursing Officer to report daily or as often as necessary his/her disbursements made through ADA. It shall include cancelled ADA and be maintained by fund cluster.

Navigation

Expenditures ► Reports ► Philippines Reports ► Report of Advice to Debit Account Issued Report

Report of Advice to Debit Account Issued Report Screen Fields

Fields

Descriptions

Bank Account No.

Non-mandatory- Single selection. Show only those banks which are related to the bank.

Fiscal Year

By default, show the current fiscal year. Based on requirement user can modify

From Date

Allows to select from date

To Date

Allows to select to date

Operating Unit

Allow Selection from concept "Operating Unit" in the "Organization" Segment of UACS.

Funding Source

Allow selection from concept "Fund Cluster" from "Fund" Segment of COA.

Report Type

Mandatory- Allow to select report type detail or summary from the close domain

Comment

Optional.  This will be filled up after the report is printed.

 

Schedule Of Payables Report

Overview

To analyze the aging payments due to creditors. This report is submitted to COA for post-audit purpose. This report will provide the end user to generate a consolidated or unconsolidated report. Consolidated Report consist both Central and Regional Offices information whereas, unconsolidated report only consist information specific to the office which is either Central or Regional Office.

Navigation
Expenditures ► Reports ► Philippines Reports ► Schedule Of Payables Report
 
Schedule Of Payables Report Screen Fields

Fields

Descriptions

Fiscal Year

This is mandatory. Defaults to current year. Allow selection of previous year.

As at

Mandatory- Allow to select date single selection. Print based on selection. The reporting period in which the accounts are outstanding.

Organization Unit Type

Allows to select organization unit type from dropdown menu

Organization

Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS. By Default, it will show Agency but user can change to Operating

Fund Cluster

Mandatory, allow many selection from concept "Fund Cluster" in the "Fund" segment of UACS. IF none selected, value for all will be displayed.

Allotment Class

Mandatory-Allow single selection from allotment class from UACS. Which is roll up from "Sub-major account group"

UACS Object Code

Mandatory - Allow selection from concept "GL CONTRA ACCOUNT" in the ''OBJECT" segment of UACS. Show only those codes relating to Allotment Class. Print as per selection.

Comment

Optional.  This will be filled up after the report is printed.

 

Schedule of Expenses per Responsibility Center Report

Overview

This report is prepared for monitoring the expenses against the each responsibility center. This report prepared monthly basis/As on date basis and send to COA for analysis purpose.

Navigation

Expenditures ► Reports ► Philippines Reports ► Schedule of Expenses per Responsibility Center Report

Schedule of Expenses per Responsibility Center Report Screen Fields

Fields

Descriptions

Fiscal Year

Mandatory-Allow to select fiscal year. By default, show the current fiscal year.

Report Type

Allows to select the report type from drop down list

Period From

Mandetory- Allow to select from fiscal period (For the Month)

Period To

Mandetory- Allow to select To fiscal period (For the Month)

UACS

Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS.

Organization

Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS. By Default, it will show Agency but user can change to Operating Unit/Department.

Comment

Comments made on the report

 

Statement Of Appropriations Allotments Obligations Disbursements And Balances Report

Overview

The purpose of the this report is to show the status of:

1. Appropriation
2. Allotments
3. Obligation
4. Disbursements
5. Balances
The report represents the status of the Appropriation against utilizations
 
Navigation
Expenditures ► Reports ► Philippines Reports ► Statement Of Appropriations Allotments Obligations Disbursements And Balances Report
 
Statement Of Appropriations Allotments Obligations Disbursements And Balances Report Screen Fields

Fields

Descriptions

Fiscal Year

Mandatory-Allow to select fiscal year. By default, show the current fiscal year.

Fiscal Period

Mandatory, single selection. Allow user to select quarters.

Organization

Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS. By Default, it will show Agency but user can change to Operating Unit/Department.

Fund Cluster

“Fund cluster” from concept Fund Source from fund segment of UACS.

Comment

Comments made on the report

Hierarchy Rollups Coa Elements

Selection of segment and concept as per Hierarchical COA option Group by.

 

Summary of Appropriations, Allotments, Obligations, Disbursements and Balances by Object of Expenditures Report

Overview

The purpose of the this report is to show the status of:

1. Appropriation
2. Allotments
3. Obligation
4. Disbursements
5. Balances
The report represents the status by object of Expenditure. This report is commonly generated on quarterly basis.
 
Navigation
Expenditures ► Reports ► Philippines Reports ► Summary of Appropriations, Allotments, Obligations, Disbursements and Balances by Object of Expenditures Report
 
Summary of Appropriations, Allotments, Obligations, Disbursements and Balances by Object of Expenditures Report Screen Fields
 

Fields

Descriptions

Fiscal Year

Dropdown to select Fiscal Year as filter for this report.

Fiscal Period

Dropdown to select Fiscal Period as filter for this report.

Organization

Mandatory filter, Allow Selection of concept in the "Organization" Segment of COA and element code for the concept selected.

Funding Source

Mandatory filter, multiple selection. Allow selection from concept "Fund Cluster" from "Fund" Segment of COA.

Comment

Comment to add on the output report.

Hierarchy Rollups Coa Elements

Selection of segment and concept as per Hierarchical COA option Group by.

 

 

Srilanka Reports

Accounts Payable with Aging Analysis Report

Overview

The accounts payable aging report categorizes payable to suppliers based on time frames. The intent of the report is to help TOD in determining which invoices are overdue for payment.

Navigation

Expenditures >> Reports >> Srilanka Reports >> Accounts Payable with Aging Analysis Report

Accounts Payable with Aging Analysis Report Screen Fields

Fields

Descriptions

Fiscal Year

Mandatory-Allow to select fiscal year. By default, show the current fiscal year.

Payment Date

Mandatory. Restricts Expense Voucher selection: Invoice Receipt Date

Payment Due Date

Payment Due Date. Default as per the Payment Terms defined in the Expense Voucher header

Include Vouchers On Hold

Determines if the Vouchers on hold should be included in the report.

Include Payment Suspended

To indicate if the payment has been suspended through the ‘Payment Suspension’ Process. Suspended Payments will not be processed within the Payment function and cannot be released. Extracted Payments cannot be suspended.  Default is False

Include Vouchers Suspended

Determines if the Vouchers on hold should be included in the report.

Period

Allows to select the period from dropdown list

Vendor

Allows to select the vendor code from search functionality

Accounting Office

This will always get the Accounting Office value of the relevant EV.

Treasury Bank Account

Allows to select the Treasury Bank Account Treasury Bank Account from search functionality

Payment Mode

Default value will be populated automatically from the selected vendor information if defined, if not defined in the Vendor, it will be populated from the selected Institution, if not defined in the Institution then default will populated be as defined in the Expenditures Parameter

Payment Method

System will allow user to select only the Payment Type that selected Institution has access to.

Payment Location

Default value will be populated automatically from the selected vendor information if defined, if not defined in the Vendor, it will be populated from the selected Institution, if not defined in the Institution then default will populated be as defined in the Expenditures Parameter

Comment

Comments made on the report

 

Vendor Analysis Progress Report

Overview

To identify the progress of a Purchase Order versus payments (disbursements).

Navigation

Expenditures ► Reports ► Srilanka Reports ► Vendor Analysis Progress Report
 
Vendor Analysis Progress Report Screen Fields

Fields

Descriptions

Fiscal Year

Mandatory-Allow to select fiscal year. By default, show the current fiscal year.

Fiscal Period

Optional - Allow to select fiscal period.

Purchase Order Date

Optional. Date Picker. Allow to select a range of dates

Purchase Order

Optional. Allow to select a range of PO #'s, should be a numeric range.

Purchasing Vehicle

Purchasing Vehicle Short Description

Vendor

Optional - Vendor name

Buyer

Optional - Buyer name

Purchasing Office

Optional - Institution name

Requester

Optional - Institution name

Item

Optional - Catalogue Item short Description

 

Vendor Analysis Report

Overview

Allows users to analyze the amount of business which the organization has done with particular vendors.

Navigation

Expenditures ► Reports ► Srilanka Reports ► Vendor Analysis Report
 
Vendor Analysis Report Screen Fields

Fields

Descriptions

Fiscal Year

Dropdown to select Fiscal Year Filter criteria for this report.

Fiscal Period From

Filter criteria for Fiscal Period From for this report.

Fiscal Period ToFilter criteria for Fiscal Period To for this report.
Report TypeDropdown to select Report Type  Filter criteria for this report.
Workflow StageWorkflow stage of EV that may be selected as filter criteria.
Include Pending ApprovalCheck box, that allow the selection of Pending Approval Expense Vouchers in the report.
CommentAny specific comment to add in the output report.

Cheque Series

Filter for the check series.
Accounting OfficeLookup for select Accounting Office as filter criteria.
Financial InstitutionLookup for select Financial Institution as filter criteria.
Financial Institution BranchDropdown to select Financial Institution Branch Filter criteria for this report.
Payment ModeLookup for select Payment Mode as filter criteria.
Payment LocationLookup for select Payment Location as filter criteria.
Treasury Bank AccountLookup for select Treasury Bank Account as filter criteria.
Cheque NumberFilter criteria for check numbers.
Cheque DateFilter criteria for check date.

 

Vendor Analysis Report

Overview

The purpose of the "Vendor Analysis Report" is to allow the user to analyze the amount of business which the organization has done with particular vendors. The user has the choice of producing summary or detailed Vendor Analysis reports, with or without period totals.

Navigation

Expenditures ► Reports ► Vendor Analysis Report

Vendor Analysis Report Screen Fields
 

FieldsDescriptions
Fiscal YearThis field contains the Financial Year for which report will be generated.
Fiscal Period From Beginning limit for the period covered in the report.
Fiscal Period ToEnd limit for the period covered in the report.
Report TypeThe type of report to be generated, either ‘Detail’ or ‘Summary’.
Workflow StageUsers can select any options from available six options for generate the report. Options are Approved Request, Approved, Cancelled, Created, Rejected and Template.
Include Pending ApprovalIf checked indicates that vouchers with a status of approval pending will be included in the report.
CommentUsers can insert comment here which will be published with the generated report.
Cheque SeriesThis field indicates the cheque series for generate report, for example cheque series printed on the cheque book.
Accounting OfficeThis field indicates the Accounting Office for generate report. Users can selete the institution which is use as accounting office also.
Financial InstitutionThis field indicates the Financial Institution for generate report. 
Financial Institution BranchUsers can look up and select the financial institution branch according to the previously selected Financial Institution.
Payment ModeUsers can look up and select Payment to generated specific payment mode wise report.
Payment LocationThis field indicates the Payment Location for generate report. 
Treasury Bank AccountUsers can look up and select Treasury Bank Account here to generate Treasury Bank Account related report.
Cheque NumberUnder this heading, there are two fields i.e. Cheque Number From and Cheque Number To. Cheque Number From indicates beginning number of cheque and Cheque Number to indicates ending cheque number for generate cheque specific report.
Cheque DateUnder this heading, there are two options i.e. From Date (beginning date of cheque) and To Date (ending date of cheque) for generate cheque date wise report.
Group byUsers can select group option from the dropdown menu list for generate group wise report.
Hierarchy Rollups CoA ElementThere are three options i.e. Coding Block, Coding Block Expression Filter and Hierarchical Coding Block Elements. Coding Block option for generate report according to specific coding block. Coding Block Expression Filter is for generate report according to specific coding block expression filter. Hierarchical coding block option helps to generate specific Segment, Concept wise report.
Vendor
User can look up and select a vendor for the vendor analysis report.

 

Accounts Payable Report

Overview

This report provides an up-to-date listing of all debts that your organization owes to its vendors. Similar to the Cash Requirements Report, this information gives you a better understanding of how much cash will be absorbed in future payments.

Navigation

Expenditures ► Reports ► Accounts Payable Report

Accounts Payable Report Screen Fields

Fields

Descriptions

Report Type

The type of report will be generated, either ‘Detail’ or ‘Summary’.

Fiscal year

This field contains the Financial Year for which report will be generated.

Payment Date

Filter criteria for the date of payment. Default value is current date. Users can select any date.

Payment Due Date

Filter criteria to filter the report by the date the payment is due to be paid.

Include Vouchers on Hold

If checked indicates that the report will contain vouchers with a status of On Hold.

Include Payment Suspended

Allows to select Suspended Payments from dropdown list

Vendor 

Users can look up and select a vendor as filter criteria for the Accounts Payable Report.

Accounting Office

Users can look up and select an accounting office as filter criteria for the Accounts Payable Report.

Treasury Bank Account

Users can look up and select a bank as filter criteria for the Accounts Payable Report.

Payment Mode

Users can look up and select a Payment Mode as filter criteria for the Accounts Payable Report.

Payment Method

Users can look up and select a Payment Method as filter criteria for the Accounts Payable Report.

Payment Location

Users can look up and select a Payment Location as filter criteria for the Accounts Payable Report.

Comment

Supporting comment which will be publish with report

 

Expenditure List By Commitments Or Obligations Report

Overview

Generate expenditure report based on Pre-created Commitment or Obligation select by the users. 

Navigation

Expenditures ► Reports ► Expenditure List by Commitments or Obligations Report

Expenditure List By Commitment or Obligation Report Screen Fields
 

FieldsDescriptions
Fiscal YearUsers can insert the fiscal year to generate report. For example, if users insert 2013, that means report will generate for the year 2013 only.
Fiscal Period FromBeginning limit for the period covered in the report.
Fiscal Period ToEnd limit for the period covered in the report
Journal Voucher Workflow StatusThere are six options available to choose i.e. Approved Request, Approved, Cancelled, Created, Rejected and Template. Report will generate on basic on workflow status choose by the users.
Journal Voucher Posting StatusThere are two options available to choose i.e. Saved and Temp Saved. Report will generate on basic on workflow status choose by the users
Currency Users should select any one currency from the dropdown list. There are two options available i.e. Domestic Currency and Foreign Currency.
Commitment Holds pre-created commitment for reporting purpose. Report will generated basic of commitment select by the users. It is non-mandatory field.
ObligationHolds pre-created obligation for reporting purpose. Report will generated basic of obligation select by the users. It is non-mandatory field. 
CommentField contain additional information and/or remarks   for publish in the report. 

 

Expense Voucher Details Report

Overview

This report prints out a detailed listing of all expense vouchers that were created during a specified period of time. Vouchers are printed in numerical sequence. This report displays information to assist on maintaining accurate control over every expense voucher that was input in the system.

Navigation

Expenditures ► Reports ► Expense Voucher Details Report

Expense Voucher DetailsReport Screen Fields
 

FieldsDescriptions
Fiscal YearFiscal year to generate report. Report will generate basis of fiscal year mentioned here.
Fiscal Period From Beginning limit for the period covered in the report.
Fiscal Period ToEnd limit for the period covered in the report
SourceThere are six dropdown options i.e. Assets, Contract Management, Inventory, Manual, Other External Source, Payroll and Purchase Order. Users can select any option from available six options; Report will be generated on basis of source option selected by the users. 
Posting StatusThere are two options available to choose i.e. Saved and Temp Saved. Report will generate on basic on workflow status choose by the users. 
Workflow StatusThere are six options available to choose i.e. Approved Request, Approved, Cancelled, Created, Rejected and Template. Report will generate on basic on workflow status choose by the users.
Posting DateThere are two fields i.e. Posting Date From and Posting Date To. Posting Date From indicates starting date of report and Posting Date to indicate ending date of report.
VoucherAllow the users enter a single value or a range of values. There are two fields i.e. Voucher From and Voucher To. Voucher From field indicates starting expense voucher ID and Voucher To field indicates ending expense voucher ID in report.
BatchAllow the users enter a single value or a range of values. . There are two fields i.e. Temporary From and Temporary To. Temporary From field indicates starting temp number and Temporary to field indicates ending temp number in report. 
TemporaryAllow the users enter a single value or a range of values. . There are two fields i.e. Batch From and Batch To. Batch From field indicates starting batch number and Batch To field indicates ending batch number in report.

 

Expense Voucher Detailed Report

Expense Voucher Detailed Report

Overview

The purpose of this report is to present a full detail of the Expense Voucher, including detailed information from EV like, Status, voucher source, item details, EV description, Domestic Amount, Paid Status, Vendor Name, Treasury Bank Account, workflow information and others.

Navigation

Expenditures ► Reports ► Expense Voucher Detailed Report

Expense Voucher Detailed Report Screen Fields
Expense Voucher Detailed Report screen includes following fields:

FieldsDescriptions
Fiscal Yearfiscal year to generate report. For example, if users insert 2013, that means report will generate for the year 2013 only.
Fiscal Period From Beginning limit for the period covered in the report.
Fiscal Period ToEnd limit for the period covered in the report
Posting statusThere are two options available to choose i.e. Saved and Temp Saved. Report will generate on basic on workflow status choose by the users. 
Workflow StatusThere are six options available to choose i.e. Approved Request, Approved, Cancelled, Created, Rejected and Template. Report will generate on basic on workflow status choose by the users. 
Voucher SourceThere are six dropdown options i.e. Assets, Contract Management, Inventory, Manual, Other External Source, Payroll and Purchase Order. Users can select any option from available six options; Report will be generated on basis of source option selected by the users.
Cheque DateUsers can insert cheque date for generate cheque date wise report. It is not mandatory field.  
Financial InstitutionThis field indicates the Financial Institution for generate report
Financial Institution BranchUsers can look up and select the financial institution branch according to the previously selected Financial Institution.
VendorUsers can look up and select a vendor as filter criteria for the Accounts Payable Report.
Accounting OfficeShows accounting office from Institution
Payment ModeUsers can look up and select a Payment Mode as filter criteria for the Accounts Payable Report.
Payment LocationUsers can look up and select a Payment Location as filter criteria for the Accounts Payable Report
Treasury Bank AccountUsers can look up and select a bank as filter criteria for the Accounts Payable Report
Cheque NumberAllow the users enter a single value or a range of values. . There are two fields i.e. Cheque Number From and Cheque Number To. Cheque Number From field indicates starting Cheque Number and Cheque Number to field indicates ending cheque number in report. 
Voucher DateAllow the users enter a single value or a range of values. . There are two fields i.e. From Date and To Date. From Date field indicates starting date and To Date field indicates ending date in report.
Expense Voucher IDAllow the users enter a single value or a range of values. There are two fields i.e. Expense Voucher ID From and Expense Voucher ID To. Expense Voucher ID From field indicates starting Expense Voucher ID and Expense Voucher ID to field indicates ending expense voucher ID in report. 
Journal Voucher IDAllow the users enter a single value or a range of values. There are two fields i.e. Journal Voucher ID From and Journal Voucher ID To. Journal Voucher ID From field indicates starting Journal Voucher ID and Journal Voucher ID to field indicates ending journal voucher ID in report.
TempAllow the users enter a single value or a range of values. There are two fields i.e. Temp ID From and Temp ID To. Temp ID From field indicates starting temp ID and Temp ID to field indicates ending temp ID in report. 

 

Revolving Funds

Nicaragua Reports

Revolving Fund Current Account Report

Overview

The purpose is to show Current Account information of a specific Revolving Fund including Petty Cash and Cash in Advance related.

Navigation

Expenditures ► Revolving Funds ► Nicaragua Reports ► Revolving Fund Current Account Report

Revolving Fund Current Account Report Screen Fields

Fields

Descriptions

Fiscal Year

Fiscal Year with attribute Fiscal Year Status = “OPEN”

Institution

Mandatory, Single Selection

Execute Type

Possible Values to select execution type are ‘INS’ and ‘INT’

Fund Id

Mandatory, Single Selection

 

Revolving Funds Tracing Report

Overview

The purpose of this report is to show all operations related with a Revolving Fund, including all cash in advance and petty cash that are related with Revolving Funds Tracing.

Navigation

Expenditures ► Revolving Funds ► Nicaragua Reports ► Revolving Funds Tracing Report
 
Revolving Funds Tracing Report Screen Fields
 

Fields

Descriptions

Fiscal Year

Dropdown to select Fiscal Year as filter criteria for this report.

Institution

Look up function to select Institution as filter criteria for this report.

Execute Type

Dropdown to select Execute Type as filter criteria for this report.

Fund Id

Dropdown to select Fund Id as filter criteria for this report.

Comment

Any comment to add on the output report.

 

Reallocation Budget Document

Overview

Registration and control of reallocation budget documents, Reallocation of budgetary reserve level Control Group COA.

Navigation
 
Expenditures ► Revolving Funds ► Reallocation Budget Document
 
Reallocation Budget Document Screen Fields

Fields

Descriptions

Id

Voucher unique ID, automatically generated by the system

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Fiscal Period

Fiscal Period of the voucher, Default current period

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Voucher Date

Default current system date

Institution

Accounting Office Code.

Fund ID

Reference to Fund ID. Users must select one of List of distinct Fund ID

Currency

To allow the user to select the Voucher Currency. Default is Domestic Currency.

Exchange Rate

Will show the latest active exchange rate for the selected currency which is linked to Expenditures, 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. 

Total Domestic Amount

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

No Of Supporting Document

No. document that supports the transaction

No Document Generated

No. Document Generated. Automatically generated by Financial Programming.

Language

Country specific language

Description

Describe the purpose of the reallocation.

Created By

Populated automatically by the system

Created Date Time

Populated automatically by the system at creation time of the record.

Approved By

Populated automatically by the system, when the document is approved.

Approved Date

Populated automatically by the system in time of approved for registration

 

 

Details Reallocation

Overview

Document contains details of budgetary reserve, of the execution of revolving funds.

Details Reallocation Tab Screen Fields

Fields

Descriptions

Serial Number

Unique code that identifies the Details fund. Automatically generated by the system

Details Norm

Reference to Details Norm ID. User most select one detail associated to the norm from a list

Coding Block

System will automatically display the CoA Code number for Details Norm ID

Total Domestic Amount Requested By

If Domestic Currency, then the user must enter the value else the value is equal to   the attribute “Total Foreign Amount Requested by” * the value the attribute “Exchange rate”

Total Foreign Amount Requested By

If not Domestic Currency, then the user must enter the value else default value zero.

Total Domestic Amount Approved

Value default = “Total Domestic Amount Requested by” If Domestic Currency then the user can modify value else the value is equal to   the attribute “Total Foreign Amount Requested by” * the value the attribute “Exchange rate”

Total Foreign Amount Approved

Value default = “Total Foreign Amount Requested by” If not Domestic Currency then the user can modify value Else default value zero.

 

Redistribution Voucher

Overview

Registration and control of redistribution of available balance on control groups of petty cash and cash in advance

Navigation

Expenditures ► Revolving Fund ► Redistribution Voucher

Redistribution Voucher Screen Fields

FieldsDescription
Voucher IDA unique identification number, it is generated by the system.
Fiscal YearThe default value is current fiscal year. The fisacl year should be open for the transaction.
Fiscal PeriodThe default value is current fiscal period. The fisacl Period should be open for the transaction.
Workflow StatusThe workflow status of the redistribution voucher, it changes automatically after completion of the approval. The possible values are Created, Approval requested, Saved, and Approved etc.
Voucher DateThe default value is the current system date. User can change it using the calendar feature.
InstitutionAccounting office code.
Fund NumberFund number. User selects it using the drop down button.
Source Fund NumberThe Fund number of the source fund.
Generated Document NumberIt is automatically generated by the system.
CurrencyCurrency for the transaction. By default it shows the country domestic currency.
Exchange RateThe exchange rate for the foreign currency if selected in the currency.
Total Domestic Amount RequestedTotal amount in domestic currency for the redistribution voucher.
Total Foreign Amount RequestedTotal amount in foreign currency for the redistribution voucher.
Total Domestic Amount ApprovedTotal approved amount in domestic currency for the redistribution voucher.
Created ByThe user id of the creator.
Created DateIt fetch the system current date when data successfully saved.
Requested byInformation of the requestor system automatically shows in this field.
Date requestedSystem automatically fetch the request date of the redistribution voucher.
Approved ByThe information of the approver system fetch when it get approved.
Approved DateDate of the approval system automatically capture when transaction got approved.
LanguageThe default language is English. User can change it
DescriptionThe related description of the Redistribution Voucher.
Redistribution Details TabIt capture the Redistribution details.

 

Redistribution Details

Overview

The tab contains the details of the Redistribution Voucher.

Redistribution Details Screen Fields

FieldsDescription
Serial NumberThe system generates a unique identification number for the redistribution details.
Coding BlockCoding block for the redistribution voucher. User can input directly or using the element view.
Total Domestic Amount RequestedRequested Total domestic amount for the redistribution voucher.
Total Foreign Amount RequestedRequested Total foreign amount for the redistribution voucher.
Total Domestic Amount ApprovedApproved total domestic amount for the redistribution voucher.
Total Foreign Amount ApprovedApproved total foreign amount for the redistribution voucher.

 

Revolving Document

Institutional Revolving Document Voucher

Institutional Cash In Advance Voucher

Overview

Registration and control of revolving fund documents, petty cash and advance in their different modes of execution: Opening, Expansion, replacement and refund.

Navigation

Expenditures ► Revolving Funds ► Institutional Revolving Document Voucher ► Institutional Cash In Advance Voucher

Fields

Descriptions

Id

Voucher unique ID, automatically generated by the system

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Fiscal Period

Fiscal Period of the voucher, Default current period

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Institution

Allows to select the Accounting Office Code from search functionality

Voucher Date

Default current system date

Record Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Execute Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Operation Type

Allows to select the operation type from dropdown list

Fund Number

Allows to add the fund number from lookup functionality

Source Fund Number

The fund number of the source fund.

Institution ID for Execution

Populated automatically by system from Institution to Execute of Fund Number selected.

Fund Type

This only applies if Record Type = "FRT" in other case it must to be hidden

Norm Of Revolving Fund

Reference to Norm ID

Grants Document type

Reference to Document Type ID. Unique code that identifies the document type

No Supporting Document

No. document that supports the transaction

Date No. supporting document

Date of No. document that supports the transaction

Currency

To allow the user to select the Voucher Currency. Default is Domestic Currency.

Exchange Rate

Will show the latest active exchange rate for the selected currency which is linked to Expenditures 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.

Total Domestic Amount Requested

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Requested

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Total Domestic Amount Approved

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Approved

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Bank Paying Account

Reference to Treasury Bank Account ID or Ref: Paying Account's Entity

Bank Account Source

Populate by system from Revolving Fund Bank Account of Fund Number selected

Language

Country specific language

Fund Purpose

Describe the purpose of fund.

Vendor Beneficiary

Reference to Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity.

Offset Code

Populate by system from Debts to Pay Offset Code of Fund Number selected

Created By

Populated automatically by the system

Created Date

Populated automatically by the system at creation time of the record.

Is Requested

State that identifies whether the document this Requested. default: false

Requested by

Populated automatically by the system, when the document is requested.

Date Requested

Populated automatically by the system in time of Requested.

Is Approved

State that identifies whether the document this approved. State default: false

Approved By

Populated automatically by the system, when the document is approved.

Date Approved

Populated automatically by the system in time of approved for registration

 

Fund’s Detail

Overview

Contains the details of the revolving funds document and source-level group of the institution that execute the revolving fund.

Funds Details Tab Screen Fields

Fields

Descriptions

Sequence #

Unique code that identifies the Details fund. Automatically generated by the system

Details Norm

Reference to Details Norm ID

Available Balance

Amount available to the revolving fund. Amount automatically calculated by the system

Total Domestic Amount Requested

If Domestic Currency, then the user must enter the value else the value is equal to   the attribute “Total Foreign Amount Requested by” * the value the attribute “Exchange rate”

Total Foreign Amount Requested

If not Domestic Currency, then the user must enter the value else default value zero.

Total Domestic Amount Approved

If Domestic Currency, then the user can modify value else the value is equal to the attribute “Total Foreign Amount Requested” * the value the attribute “Exchange rate”

Total Foreign Amount Approved

If not Domestic Currency, then the user can modify value Else default value zero.

 

 

Institutional Petty Cash Voucher

Overview

Registration and control of revolving fund documents, petty cash and advance in their different modes of execution: Opening, Expansion, replacement and refund.

Navigation

Expenditures ► Revolving Funds ► Institutional Revolving Document Voucher ► Institutional Petty Cash Voucher

Institutional Petty Cash Voucher Screen Fields

Fields

Descriptions

Id

Voucher unique ID, automatically generated by the system

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Fiscal Period

Fiscal Period of the voucher, Default current period

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Institution

Allows to select the Accounting Office Code from search functionality

Voucher Date

Default current system date

Record Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Execute Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Operation Type

Allows to select the operation type from dropdown list

Fund Number

Allows to add the fund number from lookup functionality

Source Fund Number

The fund number of the source fund.

Institution ID for Execution

Populated automatically by system from Institution to Execute of Fund Number selected.

Fund Type

This only applies if Record Type = "FRT" in other case it must to be hidden

Norm Of Revolving Fund

Reference to Norm ID

Grants Document type

Reference to Document Type ID. Unique code that identifies the document type

No Supporting Document

No. document that supports the transaction

Date No. supporting document

Date of No. document that supports the transaction

Currency

To allow the user to select the Voucher Currency. Default is Domestic Currency.

Exchange Rate

Will show the latest active exchange rate for the selected currency which is linked to Expenditures 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.

Total Domestic Amount Requested

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Requested

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Total Domestic Amount Approved

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Approved

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Bank Paying Account

Reference to Treasury Bank Account ID or Ref: Paying Account's Entity

Bank Account Source

Populate by system from Revolving Fund Bank Account of Fund Number selected

Language

Country specific language

Fund Purpose

Describe the purpose of fund.

Vendor Beneficiary

Reference to Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity.

Offset Code

Populate by system from Debts to Pay Offset Code of Fund Number selected

Administrative Unit

ID Administrative unit. Enable if the attribute “Record type” = “CCH” AND  the attribute “Operation type” = “APE”

Replacement of fund

Enable and Visible only if the attribute (“Record type” = “FRT” or “CCH”) AND the attribute “Operation type” = “APE”.

Created By

Populated automatically by the system

Created Date

Populated automatically by the system at creation time of the record.

Is Requested

State that identifies whether the document this Requested. default: false

Requested by

Populated automatically by the system, when the document is requested.

Date Requested

Populated automatically by the system in time of Requested.

Is Approved

State that identifies whether the document this approved. State default: false

Approved By

Populated automatically by the system, when the document is approved.

Date Approved

Populated automatically by the system in time of approved for registration

 

Funds Details

Overview

Contains the details of the revolving funds document and source-level group of the institution that execute the revolving fund.

Funds Details Tab Screen Fields

Fields

Descriptions

Sequence #

Unique code that identifies the Details fund. Automatically generated by the system

Details Norm

Reference to Details Norm ID

Available Balance

Amount available to the revolving fund. Amount automatically calculated by the system

Total Domestic Amount Requested

If Domestic Currency, then the user must enter the value else the value is equal to   the attribute “Total Foreign Amount Requested by” * the value the attribute “Exchange rate”

Total Foreign Amount Requested

If not Domestic Currency, then the user must enter the value else default value zero.

Total Domestic Amount Approved

If Domestic Currency, then the user can modify value else the value is equal to the attribute “Total Foreign Amount Requested” * the value the attribute “Exchange rate”

Total Foreign Amount Approved

If not Domestic Currency, then the user can modify value Else default value zero.

 

 

Institutional Revolving Fund Voucher

Overview

Registration and control of revolving fund documents, petty cash and advance in their different modes of execution: Opening, Expansion, replacement and refund.

Navigation

Expenditures ► Revolving Funds ► Institutional Revolving Document Voucher ► Institutional Revolving Fund Voucher

Institutional Revolving Fund Voucher Screen Fields

Fields

Descriptions

Id

Voucher unique ID, automatically generated by the system

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Fiscal Period

Fiscal Period of the voucher, Default current period

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Institution

Allows to select the Accounting Office Code from search functionality

Voucher Date

Default current system date

Record Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Execute Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Operation Type

Allows to select the operation type from dropdown list

Fund Number

Allows to add the fund number from lookup functionality

Source Fund Number

The fund number of the source fund.

Institution ID for Execution

Populated automatically by system from Institution to Execute of Fund Number selected.

Fund Type

This only applies if Record Type = "FRT" in other case it must to be hidden

Norm Of Revolving Fund

Reference to Norm ID

Grants Document type

Reference to Document Type ID. Unique code that identifies the document type

No Supporting Document

No. document that supports the transaction

Date No. supporting document

Date of No. document that supports the transaction

Currency

To allow the user to select the Voucher Currency. Default is Domestic Currency.

Exchange Rate

Will show the latest active exchange rate for the selected currency which is linked to Expenditures 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.

Total Domestic Amount Requested

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Requested

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Total Domestic Amount Approved

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Approved

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Bank Paying Account

Reference to Treasury Bank Account ID or Ref: Paying Account's Entity

Bank Account Source

Populate by system from Revolving Fund Bank Account of Fund Number selected

Language

Country specific language

Fund Purpose

Describe the purpose of fund.

Vendor Beneficiary

Reference to Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity.

Offset Code

Populate by system from Debts to Pay Offset Code of Fund Number selected

Replacement of fund

Enable and Visible only if the attribute (“Record type” = “FRT” or “CCH”) AND the attribute “Operation type” = “APE”.

Created By

Populated automatically by the system

Created Date

Populated automatically by the system at creation time of the record.

Is Requested

State that identifies whether the document this Requested. default: false

Requested by

Populated automatically by the system, when the document is requested.

Date Requested

Populated automatically by the system in time of Requested.

Is Approved

State that identifies whether the document this approved. State default: false

Approved By

Populated automatically by the system, when the document is approved.

Date Approved

Populated automatically by the system in time of approved for registration

Is Linked

Attribute Enable if the attributes “Record Type = FRT” AND “Execute type” = “INS” AND “operation type” = “APE”. Value default = false.

 

Funds Details

Overview

Contains the details of the revolving funds document and source-level group of the institution that execute the revolving fund.

Funds Details Tab Screen Fields

Fields

Descriptions

Sequence #

Unique code that identifies the Details fund. Automatically generated by the system

Details Norm

Reference to Details Norm ID

Available Balance

Amount available to the revolving fund. Amount automatically calculated by the system

Total Domestic Amount Requested

If Domestic Currency, then the user must enter the value else the value is equal to   the attribute “Total Foreign Amount Requested by” * the value the attribute “Exchange rate”

Total Foreign Amount Requested

If not Domestic Currency, then the user must enter the value else default value zero.

Total Domestic Amount Approved

If Domestic Currency, then the user can modify value else the value is equal to the attribute “Total Foreign Amount Requested” * the value the attribute “Exchange rate”

Total Foreign Amount Approved

If not Domestic Currency, then the user can modify value Else default value zero.

 

Internal Revolving Document Voucher

Internal Cash In Advance Voucher

Overview

Registration and control of revolving fund documents, petty cash and advance in their different modes of execution: Opening, Expansion, replacement and refund.

Navigation

Expenditures ► Revolving Funds ► Internal Revolving Document Voucher ► Internal Cash In Advance Voucher

Fields

Descriptions

Id

Voucher unique ID, automatically generated by the system

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Fiscal Period

Fiscal Period of the voucher, Default current period

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Institution

Allows to select the Accounting Office Code from search functionality

Voucher Date

Default current system date

Record Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Execute Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Operation Type

Allows to select the operation type from dropdown list

Fund Number

Allows to add the fund number from lookup functionality

Source Fund Number

The fund number of the source fund.

Institution ID for Execution

Populated automatically by system from Institution to Execute of Fund Number selected.

Fund Type

This only applies if Record Type = "FRT" in other case it must to be hidden

Norm Of Revolving Fund

Reference to Norm ID

Grants Document type

Reference to Document Type ID. Unique code that identifies the document type

No Supporting Document

No. document that supports the transaction

Date No. supporting document

Date of No. document that supports the transaction

Currency

To allow the user to select the Voucher Currency. Default is Domestic Currency.

Exchange Rate

Will show the latest active exchange rate for the selected currency which is linked to Expenditures 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.

Total Domestic Amount Requested

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Requested

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Total Domestic Amount Approved

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Approved

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Bank Paying Account

Reference to Treasury Bank Account ID or Ref: Paying Account's Entity

Bank Account Source

Populate by system from Revolving Fund Bank Account of Fund Number selected

Language

Country specific language

Fund Purpose

Describe the purpose of fund.

Vendor Beneficiary

Reference to Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity.

Offset Code

Populate by system from Debts to Pay Offset Code of Fund Number selected

Created By

Populated automatically by the system

Created Date

Populated automatically by the system at creation time of the record.

Is Requested

State that identifies whether the document this Requested. default: false

Requested by

Populated automatically by the system, when the document is requested.

Date Requested

Populated automatically by the system in time of Requested.

Is Approved

State that identifies whether the document this approved. State default: false

Approved By

Populated automatically by the system, when the document is approved.

Date Approved

Populated automatically by the system in time of approved for registration

 

Funds Details

Overview

Contains the details of the revolving funds document and source-level group of the institution that execute the revolving fund.

Funds Details Tab Screen Fields

Fields

Descriptions

Sequence #

Unique code that identifies the Details fund. Automatically generated by the system

Details Norm

Reference to Details Norm ID

Available Balance

Amount available to the revolving fund. Amount automatically calculated by the system

Total Domestic Amount Requested

If Domestic Currency, then the user must enter the value else the value is equal to   the attribute “Total Foreign Amount Requested by” * the value the attribute “Exchange rate”

Total Foreign Amount Requested

If not Domestic Currency, then the user must enter the value else default value zero.

Total Domestic Amount Approved

If Domestic Currency, then the user can modify value else the value is equal to the attribute “Total Foreign Amount Requested” * the value the attribute “Exchange rate”

Total Foreign Amount Approved

If not Domestic Currency, then the user can modify value Else default value zero.

 

Internal Petty Cash Voucher

Overview

Registration and control of revolving fund documents, petty cash and advance in their different modes of execution: Opening, Expansion, replacement and refund.

Navigation

Expenditures ► Revolving Funds ► Internal Revolving Document Voucher ► Internal Petty Cash Voucher

Internal Revolving Fund Voucher Screen Fields

Fields

Descriptions

Id

Voucher unique ID, automatically generated by the system

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Fiscal Period

Fiscal Period of the voucher, Default current period

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Institution

Allows to select the Accounting Office Code from search functionality

Voucher Date

Default current system date

Record Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Execute Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Operation Type

Allows to select the operation type from dropdown list

Fund Number

Allows to add the fund number from lookup functionality

Source Fund Number

The fund number of the source fund.

Institution ID for Execution

Populated automatically by system from Institution to Execute of Fund Number selected.

Fund Type

This only applies if Record Type = "FRT" in other case it must to be hidden

Norm Of Revolving Fund

Reference to Norm ID

Grants Document type

Reference to Document Type ID. Unique code that identifies the document type

No Supporting Document

No. document that supports the transaction

Date No. supporting document

Date of No. document that supports the transaction

Currency

To allow the user to select the Voucher Currency. Default is Domestic Currency.

Exchange Rate

Will show the latest active exchange rate for the selected currency which is linked to Expenditures 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.

Total Domestic Amount Requested

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Requested

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Total Domestic Amount Approved

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Approved

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Bank Paying Account

Reference to Treasury Bank Account ID or Ref: Paying Account's Entity

Bank Account Source

Populate by system from Revolving Fund Bank Account of Fund Number selected

Language

Country specific language

Fund Purpose

Describe the purpose of fund.

Vendor Beneficiary

Reference to Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity.

Offset Code

Populate by system from Debts to Pay Offset Code of Fund Number selected

Administrative UnitID Administrative unit. Enable if the attribute “Record type” = “CCH” AND  the attribute “Operation type” = “APE”

Replacement of fund

Enable and Visible only if the attribute (“Record type” = “FRT” or “CCH”) AND the attribute “Operation type” = “APE”. IF “TRUE” the Replacement fund, else not replacement of fund Default Value ‘TRUE’

Created By

Populated automatically by the system

Created Date

Populated automatically by the system at creation time of the record.

Is Requested

State that identifies whether the document this Requested. default: false

Requested by

Populated automatically by the system, when the document is requested.

Date Requested

Populated automatically by the system in time of Requested.

Is Approved

State that identifies whether the document this approved. State default: false

Approved By

Populated automatically by the system, when the document is approved.

Date Approved

Populated automatically by the system in time of approved for registration

 

 

Funds Details

Overview

Contains the details of the revolving funds document and source-level group of the institution that execute the revolving fund.

Funds Details Tab Screen Fields

Fields

Descriptions

Sequence #

Unique code that identifies the Details fund. Automatically generated by the system

Details Norm

Reference to Details Norm ID

Available Balance

Amount available to the revolving fund. Amount automatically calculated by the system

Total Domestic Amount Requested

If Domestic Currency, then the user must enter the value else the value is equal to   the attribute “Total Foreign Amount Requested by” * the value the attribute “Exchange rate”

Total Foreign Amount Requested

If not Domestic Currency, then the user must enter the value else default value zero.

Total Domestic Amount Approved

If Domestic Currency, then the user can modify value else the value is equal to the attribute “Total Foreign Amount Requested” * the value the attribute “Exchange rate”

Total Foreign Amount Approved

If not Domestic Currency, then the user can modify value Else default value zero.

 

Internal Revolving Fund Voucher

Overview

Registration and control of revolving fund documents, petty cash and advance in their different modes of execution: Opening, Expansion, replacement and refund.

Navigation

Expenditures ► Revolving Funds ► Internal Revolving Document Voucher ► Internal Revolving Fund Voucher

Internal Revolving Fund Voucher Screen Fields

Fields

Descriptions

Id

Voucher unique ID, automatically generated by the system

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Fiscal Period

Fiscal Period of the voucher, Default current period

Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Institution

Allows to select the Accounting Office Code from search functionality

Voucher Date

Default current system date

Record Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Execute Type

Read only attribute which is automatically filled by the system depending the menu option selected by the user

Operation Type

Allows to select the operation type from dropdown list

Fund Number

Allows to add the fund number from lookup functionality

Source Fund Number

The fund number of the source fund.

Institution ID for Execution

Populated automatically by system from Institution to Execute of Fund Number selected.

Fund Type

This only applies if Record Type = "FRT" in other case it must to be hidden

Norm Of Revolving Fund

Reference to Norm ID

Grants Document type

Reference to Document Type ID. Unique code that identifies the document type

No Supporting Document

No. document that supports the transaction

Date No. supporting document

Date of No. document that supports the transaction

Currency

To allow the user to select the Voucher Currency. Default is Domestic Currency.

Exchange Rate

Will show the latest active exchange rate for the selected currency which is linked to Expenditures 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.

Total Domestic Amount Requested

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Requested

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Total Domestic Amount Approved

Shows Total Domestic Amount for the details of funds (Total Domestic Amount of the details of funds). Default is Zero

Total Foreign Amount Approved

Shows Total Foreign Amount for the details of funds (Total Foreign Amount of the details of funds). Default is Zero

Bank Paying Account

Reference to Treasury Bank Account ID or Ref: Paying Account's Entity

Bank Account Source

Populate by system from Revolving Fund Bank Account of Fund Number selected

Language

Country specific language

Fund Purpose

Describe the purpose of fund.

Vendor Beneficiary

Reference to Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity.

Offset Code

Populate by system from Debts to Pay Offset Code of Fund Number selected

Replacement of fund

Enable and Visible only if the attribute (“Record type” = “FRT” or “CCH”) AND the attribute “Operation type” = “APE”. IF “TRUE” the Replacement fund, else not replacement of fund Default Value ‘TRUE’

Created By

Populated automatically by the system

Created Date

Populated automatically by the system at creation time of the record.

Is Requested

State that identifies whether the document this Requested. default: false

Requested by

Populated automatically by the system, when the document is requested.

Date Requested

Populated automatically by the system in time of Requested.

Is Approved

State that identifies whether the document this approved. State default: false

Approved By

Populated automatically by the system, when the document is approved.

Date Approved

Populated automatically by the system in time of approved for registration

 

Funds Details

Overview

Contains the details of the revolving funds document and source-level group of the institution that execute the revolving fund.

Funds Details Tab Screen Fields

Fields

Description

Sequence #

Unique code that identifies the Details fund. Automatically generated by the system

Details Norm

Reference to Details Norm ID

Available Balance

Amount available to the revolving fund. Amount automatically calculated by the system

Total Domestic Amount Requested

If Domestic Currency, then the user must enter the value else the value is equal to   the attribute “Total Foreign Amount Requested by” * the value the attribute “Exchange rate”

Total Foreign Amount Requested

If not Domestic Currency, then the user must enter the value else default value zero.

Total Domestic Amount Approved

If Domestic Currency, then the user can modify value else the value is equal to the attribute “Total Foreign Amount Requested” * the value the attribute “Exchange rate”

Total Foreign Amount Approved

If not Domestic Currency, then the user can modify value Else default value zero.

 

Revolving Fund Current Account

Overview

Contains the registration and control of the current account of each revolving fund, petty cash and advances executed from the module of revolving funds, from the constitution or bottom opening until closing. This entity is created when a Revolving documents (just for Operation Type =”APE”) is approved, and is update through process and business rules.

Navigation

Expenditures ► Revolving Funds ► Revolving Fund Current Account

Revolving Fund Current Account Screen Fields

Fields

Descriptions

Id

Unique code automatically generated by the system

Fiscal Year

Default current fiscal year

Institution

ID of the Institution

Fund State

Allows to select the fund state from dropdown list

Execute Type

Allows to select the execution type from dropdown list

Record Type

Allows to select the record type from dropdown list

Norm Of Revolving Fund

Contains the execution rules that defined each type of revolving fund.

Fund Id

ID of the fund

Fund Source Id

The fund number of the source fund.

Coding Block

Populate by system from Debts to Pay Offset Code of Fund Number selected

Item Code Group Expenditure

System will automatically display the Item Code number for “Details Norm ID”

Item Code Source Specific

System will automatically display the Item Code number for “Details Norm ID”

Total Domestic Amount Of Opening

Default value 0

Total Foreign Amount Of Opening

Default value 0

Total Domestic Amount Of Expansion

Default value 0

Total Foreign Amount Of Expansion

Default value 0

Total Domestic Amount Of Refill

Default value 0

Total Foreign Amount Of Refill

Default value 0

Total Domestic Amount Of Reimbursement

Default value 0

Total Foreign Amount Of Reimbursement

Default value 0

Total Domestic Amount Of Execution

Default value 0

Total Foreign Amount Of Execution

Default value 0

Total Domestic Amount Of Surrender

Default value 0

Total Foreign Amount Of Surrender

Default value 0

Total Domestic Amount Of Distributed

Default value 0

Total Foreign Amount Of Distributed

Default value 0

Total Domestic Amount Of Available Balance

Default value 0

Total Foreign Amount Of Available Balance

Default value 0

Total Domestic Amount Of Distributed Returned

Default value 0

Total Foreign Amount Of Distributed Returned

Default value 0

Total Domestic Amount Of Distributed Refill

Default value 0

Total Foreign Amount Of Distributed Refill

Default value 0

Total Domestic Amount Of Transfer

Default value 0

Total Foreign Amount Of Transfer

Default value 0

Total Domestic Amount Of Reallocation

Default value 0

Total Foreign Amount Of Reallocation

Default value 0

 

Support Entities

Fund Type

Overview

Contains the record of the types of funds that can be executed within the module.

Navigation

Expenditures ► Revolving Funds ► Support Entities ► Fund Type

Fund Type Screen Fields

Fields

Description

Id

Unique code that identifies the fund type.

Active

To indicate if the fund type is active or restrictive.

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Execution Type

Allows to select execution type from dropdown list

Institution

ID of the Institution

Created Date

Default current system date

Fund Type Origin

Allows to select origin values from dropdown list

Language

Country specific language

Description

Description of the fund type

 

Norm Of Revolving Fund

Overview

Contains the execution rules that defined each type of revolving fund.

Navigation

Expenditures ► Revolving Funds ► Support Entities ► Norm Of Revolving Fund

Norm Of Revolving Fund Screen Fields

Fields

Description

Id

Unique code, automatically generated by the system

Fund Type

Unique code that identifies the fund type.

Fiscal Year

System will automatically display the branch name associated with the Fund type ID

Institution

ID of the Institution

Active

To indicate if Norm is active or restrictive.

Expense Type

Allows to select the execution type from dropdown list

Is Enable Petty Cash

To indicate if execute petty cash, active or restrictive. Default value is ‘true’

Is Enable Advances

To indicate if advances are enabled. Default value is ‘true’

Created Date

Default current system date

Language

Country specific language

Description

Description of Norm

 

Detail's Norm

Overview

It contains the details of the revolving funds rules that are defined at the COA, through the expenditure groups and funding source for each fiscal year and institution or executing unit

Detail's Norm Tab Screen Fields

Fields

Description

Sequence #

ID details norm of fund. Automatically generated by the system

Language

Country specific language

Description

Description of the detail’s Norm

Percentage Max To Constitute

Maximum percentage constitute

Assigned Amount

Read only, default value = 0

Coding Block

The CB structure is based on Parameter Institutional Revolving Funds Grouping CoA Group

Item Code Group Expenditure

System will automatically display the Elements restricted to definition in the Parameter where Concept Id is equal System String Parameter “Expenditure Group "

Item Code Specified Source

System will automatically display the Elements restricted to definition in the Parameter where Concept Id is equal System String Parameter “Financing source"

 

Exception Criteria

Overview

Contains all COA level records should not be taken into consideration for calculating the available amount to be executed for each standard revolving fund.

Exception Criteria Tab Screen Fields

Fields

Description

Sequence #

ID exception criteria. Automatically generated by the system

Language

Country specific language

Description

Description the details

Coding Block

The CB structure is based on Parameter Institutional Revolving Funds Detail CoA Group Else The CB structure is based on parameter Revolving Funds Detail CoA Group

 

Details Of Accounts Paying

Overview

It contains all the details of paying Account for each defined standard for each revolving fund.

Details Of Accounts Paying Tab Screen Fields

Fields

Description

Serial Number

Unique code, automatically generated by the system

Item Code Specified Source

Allows to select the item code from the search functionality

Treasury Bank Account

Allows to select the Bank Account from the search functionality

Bank Account Number

System will automatically display the bank account number for Treasury Bank Account

Bank Account Bank Name

System will automatically display the bank account bank name for Treasury Bank Account

 

Revolving Fund Register

Overview

This manage Revolving Fund, Petty Cash and Cash in Advance Register previously to use in module.

Navigation

Expenditures ► Revolving Funds ► Support Entities ► Revolving Fund Register

Revolving Fund Register Screen Fields

Fields

Description

Code

Calculated Unique Identifier. Visible to the User. It is generated by the system 

Fiscal Year

Fiscal Year for Revolving Fund

Fund State

Set Automatically by system, possible values. ‘Registered’, ‘Execution’, ‘Closed’, Default = ‘Registered’

Record Type

Allows to select record type from dropdown list

Execute Type

Allows to select Execute Type from dropdown list

Institution

Institution related with Revolving Fund Register

Institution to Execute

Institution use for Revolving Fund for Execution

Fund Id

Identify each Revolving Fund, Petty Cash and Cash in Advance.

Fund Source Id

Reference Fund ID

Fund Type

Enter by user if Record Type = "FRT" In other case it must to be hidden and populate automatically from system

Norm ID

Enter by user if Record Type = "FRT" In other case it must to be hidden and populate automatically from system

Revolving Fund Bank Account Id

Allows to select the item code specified source from the search functionality

Revolving Fund Bank Account

Identify the Treasury Bank Account used for Revolving Fund

Petty Cash Bank Account Id

Allows to select the Bank Account Id from the search functionality

Petty Cash Bank Account

Identify the Treasury Bank Account used for Revolving Fund

Cash in Advance Bank Account Id

Allows to select the Cash in Advance Bank Account Id from the search functionality

Cash in Advance Bank Account

Identify the Treasury Bank Account used for Revolving Fund

Debts to Pay Offset Code

Offset Coding Block COA Group with attribute 'Budget Execution' equal to 'True'

Revolving Fund Offset Code

Read Only. Populate by system from attribute GL Offset Code of Revolving Fund Bank Account

Debts to Pay Petty Cash Offset Code

Offset Coding Block COA Group with attribute 'Budget Execution' equal to 'True'.

Debts to Pay Cash in Advance Offset Code

Offset Coding Block COA Group with attribute 'Budget Execution' equal to 'True'.

Revolving Fund Payment Method

Allows to select Revolving Fund Payment Method from drop down list

Petty Cash Payment Method

Allows to select Petty Cash Payment Method from drop down list

Cash In Advance Payment Method

Allows to select Cash In Advance Payment Method from drop down list

Language

Country specific language

Description

Description of Revolving Fund 

 

Suriname Payroll Interface

Deductions

Overview

Salary Deduction allows users (Payroll Department) to define which Deductions are applicable and valid. Only Deductions defined within this entity are accepted when uploading information via the Salary Deduction File Upload process.

Navigation

Expenditures ► Suriname Payroll Interface ► Suriname Deductions.

Suriname Deductions Screen Fields

Fields

Description

Deduction Code

Unique identification code for Deduction.

Coding Block

Coding Block for salary deduction which is to be selected from lookup button

Affects Cash flow

This field indicates whether Deduction affects Cash Flow or not.

Language

Language used to describe Deductions. It’s a multiple language option from which users are to select as per requirement.

Description

Description of Salary Deductions.

Created On

Date and Time when the salary deductions were created.

Created By

Users by whom salary deductions were made.

Updated On

Date and Time when last update on deduction were made.

Updated By

Users by whom last updates were made.

 

Suriname Coa Mapping

Overview

The Chart of Accounts Mapping Table allows the accounts from the Payroll System to be mapped to the current Chart of Accounts from the Integrated Financial Management Information System. This means that users maintain the relation between the accounts used by the payroll and those current in the Chart of Accounts, these accounts are used by the Payroll Interface to create expense vouchers.

Navigation

Expenditures ►Suriname Payroll Interface ► Coa Mapping.

Suriname CoA Mapping Screen Fields

Suriname CoA Mapping screen includes following Fields.

FieldsDescription
IdUnique identification code for Suriname CoA Mapping.
Cost AccountCost Account code for the current payroll system.
Coding BlockCoding Block which is to be mapped to be selected from lookup button.
Created OnDate and Time when CoA Mapping were created.
Created ByUsers by whom CoA Mapping was made.
Updated OnDate and Time when last update on CoA mapping were made.
Updated By
Users by whom last updates were made.
 

 

AttachmentSize
Coa Mapping.png18.12 KB

Suriname Expenditures Reports

Suriname Aged Payables Account Report

Overview

Expenditures report required which provide ageing of Payables.

Navigation

Expenditures ► Suriname Payroll Interface ► Suriname Expenditures Reports ► Suriname Aged Payables Account Report

Suriname Aged Payables Account Report Screen Fields

Fields

Description

Treasury Bank Account

After the user, has selected the TBA report will include only EV records matching the selected Treasury Bank Account

From Fiscal Year

Optional-Allow to select fiscal year range.

To Fiscal Year

Optional-Allow to select fiscal year range.

Payables To Be Inclued

Optional -Single selection.
Values: 'All', 'Over 30 days', 'Over 60 days', 'Over 90 days', 'Specific'

Specific Number Of Days

Optional - This filter will be enable only if 4.8 Payables to be inclued = 'Specific'. An integer number greater than zero will be captured.

Vendor Name

Optional - look up

Institution

Institution Name. Optional - look up

Comment

Allows to enter the comment for the report

 

Suriname Import Salary Information

Overview

The purpose of Import Salary Information is to import information of salary in a file and add the record in the system. The imported file’s record gets added in the salary details regarding employee.

Navigation

Expenditures ► Suriname Payroll Interface ► Suriname Import Salary Information

Suriname Import Salary Information Screen Fields And Tabs

 FieldsDescription
To Existing Uploaded FileWhether to import salary information to existing uploaded file gets mentioned in this field.
TypeType of information in the imported file gets mentioned. It may be regarding Salary Payment, Salary Deduction
File to ImportFile to be imported to be selected and uploaded from this field.

 

Suriname Institution Mapping

Overview

The Payroll Institutions Catalogue allows users (Payroll Department) to define the conversion codes from institutions of the current Payroll System to ‘Integrated Financial Management System’ institutions. Only institutions defined within this entity are accepted when uploading information via the Salary / Salary Deduction File Upload process.

Navigation

Expenditures ►Suriname Payroll Interface ►Institution Mapping.

Suriname Institution Mapping Screen Fields

Suriname Institution Mapping screen includes following fields

FieldsDescription
Payroll Institution CodeInstitution code of Payroll to be entered by users.
InstitutionInstitution code which is mapped to be selected from lookup button.
Created OnDate and Time when Institution Mapping were created.
Created ByUsers by whom Institution Mapping was made.
Updated OnDate and Time when last update on Institution mapping were made.
Updated ByUsers by whom last updates were made.

 

AttachmentSize
Institution Mapping.png17.56 KB

Suriname Reports

Deduction Payment Expense Voucher Report

Overview

 

This report present relevant information from Deduction Payment Details for a related File Upload ID.

Navigation

Expenditures ► Suriname Payroll Interface ► Suriname Reports ► Deduction Payment Expense Voucher Report

Deduction Payment Expense Voucher Report Screen Fields

FieldsDescription
File Upload IdSuriname Uploaded File code to be selected from lookup button.
Deduction AccountSuriname Deduction to be selected from lookup button
Salary Payment StatusStatus of salary payment to be selected from dropdown box. Status may be: Created, EV Created, EV Error, Invalid and Valid.
Salary Payment Expense VoucherExpense Voucher for salary payment to be selected from lookup button.
Deduction Payment StatusStatus of Expense Voucher to be selected from dropdown box
Deduction Payment Expense VoucherExpense Voucher to be selected from lookup button
CommentComment on the report.

 

File Upload Error Log Report

Overview

File Upload Error Log Report present relevant information from Error log for a related File Upload ID in Suriname Payroll Interface.

Navigation

Expenditures ► Suriname Payroll Interface ► Suriname Reports ► File Upload Error Log Report

File Upload Error Log Report screen Fields

FieldsDescription
File IDUploaded File code to be selected from lookup button.
CommentComment on the report.

 

Salary Payment Expense Voucher Report

Overview

This report present relevant information from Salary Payment Details and related Expense vouchers for a related File Upload ID.

Navigation

Expenditures ► Suriname Payroll Interface ► Suriname Reports ► Salary Payment Expense Voucher Report

Salary Payment Expense Voucher Report screen Fields

FieldsDescription
File IDCode of the Suriname Uploaded File to be selected from lookup button
Cost AccountCode of the Suriname CoA Mapping to be selected from lookup button.
StatusStatus of the Salary Payment Expense Voucher to be selected from lookup button as filtering criteria. Status may be: Created, EV Created, EV Error, Invalid and Valid.
Salary Payment Expense VoucherExpense Voucher for salary payment to be selected from lookup button
CommentComment on the report.

 

Suriname Uploaded File

Overview

Details of the salary payment, salary deduction and error log, if any records exist, they are shown in this entity created from the imported file for salary. This entity depends on the Uploaded File entity.

Navigation

Expenditures ► Suriname Payroll Interface ► Uploaded File

Suriname Uploaded File Screen Fields

FieldsDescription
IdUnique identification code of Uploaded file record.
StatusStatus of the uploaded file is mentioned in this field. It may in created, processed or cancelled status
Uploaded ByUsers by whom files were uploaded
Updated OnDate and time when the files were last updated
Updated ByUsers by whom last update was made
Salary Payment tabInformation regarding salary payment are shown in this tab
Salary Deductions tabInformation regarding salary deduction are shown in this tab
Error Log tabInformation regarding Error Log are shown in this tab

 

Trips and per diem

Support Entities

Category of Employee

Overview

Entity that contains a classification of employees, for the assignment of per diem by category of employees.

Navigation

Expenditures ► Trips and per diem ► Support Entities ► Category of Employee

Category of Employee Screen Fields

Fields

Description

Id

Unique code that identifies the category of staff

Active

To indicate if the category of staff is active or restrictive. false = ‘Active’, true = ‘Restrictive’

Institution

ID of the Institution 

Origin

Select the origin values from dropdown list

Description

Description the category of staff

 

Category of Expenditure

Overview

Entity that contains the types of expenditure to be incurred in the subsystem of trips and per diem.

Navigation

Expenditures ► Trips and per diem ► Support Entities ► Category of Expenditure

Category of Expenditure Screen Fields

Fields

Description

Id

Unique code that identifies the category of expenditure.

Active

To indicate if the category of expenditure is active or restrictive. false = ‘Active’, true = ‘Restrictive’

Institution

ID of the Institution 

CoA

It should take the default value of the COA. This mean that it should take the actual year COA.

Item Code Expenditure Group

System will show a List of Elements restricted to definition in the Parameter where Concept Id is equal

Origin

Select the origin values from dropdown list

Description

Description the category of expenditure

 

Travel Expenses Category

Overview

Entity that contains the list of per diem by country, category of employees and types of viatios.

Navigation

Expenditures ► Trips and per diem ► Support Entities ► Travel Expenses Category

Travel Expenses Category Screen Fields

Fields

Description

Id

Item unique ID, can be either “Calculated/Updated Read Only Field” system generated automatic

Origin

Allows to select origin values from dropdown list

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Created Date

Default current system date

Institution

ID of the Institution

Category of Expenditure

ID Category of Expenditure

Category of Employee

ID Category of Employee

Country

Country where per diem rate is applicable to

Currency

To allow the user to select the Voucher Currency. Default is Domestic Currency.

Location Type

Configuration Setting for this Entity the basic Stages are: ‘Internal’, ‘External’, Default = ‘Internal’

Location

It will show only the regions with Location Type

Expense Cost

Cost of the Expense

 

Travel Expenses Voucher

Overview

Documents containing the registration and control of the management of travel and per diem. And linkage to budgetary expenses and accounting documents.

Navigation

Expenditures ► Trips and per diem ► Travel Expenses Voucher

Travel Expenses Voucher Screen Fields And Tabs

Fields

Description

Code

Voucher unique ID, automatically generated by the system

 Workflow Status

This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'.

Fiscal Year

Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True)

Fiscal Period

Fiscal Period of the voucher, Default current period

Institution

Allows to select Budget Office Code.

Execute Type

Allows to select execute type from dropdown list

Voucher Date

Default current system date

Source Doc Number

The document number of the source document.

Travel Type status

Select travel type from dropdown list

Document Type

Unique code that identifies the document type

No Supporting Document

No. document that supports the transaction

Language

Country specific language

Description

Description expenses voucher

Total Amount (Domestic)

Shows Total Domestic Amount for the whole travel expenses (Total Domestic Amount of the Travel expenses). Default is Zero

Total Amount (Foreign)

Shows Total Domestic Amount for the whole travel expenses (Total Domestic Amount of the Travel expenses). Default is Zero

Deduction Amount Domestic

Total value of deduction

Deduction Amount Foreign

Total value of deduction

Total Net Amount Domestic

Total value of transaction

Total Net Amount Foreign

Total value of transaction

Trip Purpose

Describe the purpose of trip.

Is Revolving Fund Execution

Indicates If TEV is for execution with Revolving Funds. Default Value = FALSE  

Is Multi fold Funding Source

Value default = false

Treasury Bank Account

Lookup to this entity to pick one.

Offset Code

The system must automatically load the value of the attribute where IF Is Revolving Fund Execution” = ‘TRUE’ and Fund ID has a valid number

Created By

Populated automatically by the system

Created Date

Populated automatically by the system at creation time of the record

Approved By

Populated automatically by the system, when the document is approved.

Approved Date

Populated automatically by the system in time of approved for registration

Is Executes Project

It indicates whether the record is execution of externally funded projects. Default value false.

Project External Financing

Unique identifier that identifies an ID of project. 

 

Invoice Details

Overview

This entity contains invoices obtained by the management module Trips and per diem.

Invoice Details Tab Screen Fields

 

Fields

Descriptions

Sequence #

Unique Number for Each Invoice Details, System Generated. READONLY

Invoice Number

Invoice number delivered by the vendor beneficiary. Manually entered by the user.

 

Domestic Amount

If the attribute “Currency” is Domestic, then the value must be manually entered by the user. Else the value must be equal to the amount the attribute “Exchange rate” * "Amount Foreign".

Foreign Amount

If the attribute “Currency” is Domestic, this value has zero Else the value must be manually entered by the user

 

Travel Expenses Details

Overview

Details the documents containing the registration and control of the management of travel and per diem.

Travel Expenses Details Tab Screen Fields

Fields

Descriptions

Serial Number

Unique code that identifies the Travel Expenses Details. Automatically generated by the system

Institution

System will automatically display the Institution attribute

Language

Country specific language

Description

Describe travel expenses Details.

Vendor

Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity.

Travel Expense Category

System will automatically display the Travel Expense Category

Coding Block

Show, only the object of expenses that belongs to the field Item Code Expenditure Group that correspond to the Travel Expense Category selected.

Currency

System will automatically display the Currency, based on the attribute: Travel Category ID

Exchange Rate

Will show the latest active exchange rate for the selected currency which is linked to the Expenditures

Foreign Amount

If the attribute “Currency” is Domestic, this value has zero

Else the value must be equal to the amount the attribute “Expenses cost” based on the attribute: "Travel Category ID" selected.

Domestic Amount

If the attribute “Currency” is Domestic, then the value must be equal to the amount the attribute “Expenses cost” based on the attribute: Travel “Category ID" selected.

Quantity

Quantity which applies to one kind of travel expenses.

Total Foreign Amount

The system automatically calculates the value Total Amount Foreign

Total Domestic Amount

The system automatically calculates the value Total Amount Domestic

Deduction Foreign Amount

Amount Foreign value of deduction Value default = 0 or the sum of the attribute “Amount Foreign" all the details of the entity "Deduction details" automatically recorded by the system Attribute read only

Deduction Domestic Amount

Amount Domestic value of deduction. Value default = 0 or the sum of the attribute "Amount Domestic" all the details of the entity "Deduction details"
automatically recorded by the system. Attribute read only

 

Total Net Foreign Amount

Calculated field Display only to show actual Foreign amount spent on this detail item. Will get updated automatically by the system upon the approval of the transactions

Total Net Domestic Amount

Calculated field Display only to show actual domestic amount spent on this detail item. Will get updated automatically by the system upon the approval of the transactions

Is Reversed

“Read Only Field” will be updated automatically by the system for the process

Is Refund

“Read Only Field” will be updated automatically by the system for the process

Is Correction

“Read Only Field” will be updated automatically by the system for the process

Number Of Document Expense

No. Document of execution of expense. Automatically assigned by the system. When the document is "approved"

 

Project Structure Details

Overview

This entity contains the list of project structures by “Trips and per diem” that must be related with details the “Travel expenses Voucher”.

Project Structure Details Tab Screen Fields

 

Fields

Descriptions

Serial Number

Unique ID that identifies the Project Structure. It’s a consecutive number automatically generated by the system.

Agreement Id

Unique identifier that identifies an ID of Agreement. 

Project Structure

Unique identifier that identifies an ID of Project 

Expense Category

Allows to select expense category from dropdown list

Amount (Domestic)

Amount value of Project Structure, When Currency is Domestic. Default value is Zero.

Amount (Foreign)

Amount value of Project Structure, When Currency is not Domestic. Default value is Zero.

Is Counter Part

Default value false. Unique identifier that identifies an ID of Counterpart.

 

Trip Paying Account

Overview

Detail of accounts payers, when the document is multi-source.

Trip Paying Account Tab Screen Fields

 

Fields

Descriptions

Serial Number

Item Correlative Number, system generated (user cannot change it) for each inserted item

Treasury Bank Account

Automatically load the list of values of the classifier categories of expenditure of the attribute "Treasury Bank Account"

Total Domestic Value Of Payment

Total value of payment, for account. Default value Zero

Total Foreign Value Of Payment

Total value of payment, for account. Default value Zero

 

Withholding Tax Authorization

Overview

This Entity contains the Authorization given to Institution to retain the taxes. Each authorization have a range of numbers to be use on the generation of Withholding Tax Vouchers

 

Navigation 

Expenditures ►Withholding Tax Authorization 

 

Withholding Tax Authorization

 

FieldDescription
Application IdUnique identification code for Withoutholding Tax Authorization.
ActiveIndicate if Authorization is active or not.
TaxIdentify Tax Code related with the Withholding Tax Authorization.
InstitutionIdentify Institution related with the Withholding Tax Authorization.
Authorization KeyAuthorization key for Withholding Tax.
SerialSerial number of Authorization.
Authorization Number FromFirst Number of Authorization Range.
Authorization Number ToLast Number of Authorization Range.
Issues DeadlineDeadline of Authorization.
Last Number GeneratedDefine the last number used to generate the Withholding Tax Voucher this must be a value between Authorization Number From and Authorization Number To.
Without Holding Tax VoucherThis Entity contains the information of Withholding Tax Voucher Generated and the Expense Voucher related. Created automatically by system, not allowed to create manually by user.