Support Entities
Sub Ledger
Overview
This Entity defines the object code element that are linked to Sub-ledger in the system. If the GL Parameter 'Sub-ledger Control' is Yes, then the system will not allow using any GL Coding Block which contains an object code element that is defined in this table without specifying the linked Sub-ledger code such as Customer, Vendor or Bank Account.
Navigation
General Ledger ► Support Entities ► Sub Ledger
Sub Ledger Screen Fields
| Fields | Description |
| Id | “Calculated/Updated Display Only Field” Auto-Generated Serial Number starts with 1. |
| Active | Determines whether this Portal Permission is active or not. |
| Type | Sub Ledger types. |
| Object Code | Users can enter the object code of a coding block that belongs to CoA group where budget execution is true. System will present a look up button to the concept of the mentioned element, so then user can select it from there. |
| Generic SubLedger Type | Defines Subledger Type if Subledger Type selected is “Generic Subledger” |
Concept Accounting Account Relationship
Overview
This feature allows users to select diferents COA object Segment accounts, and create a relationship to other accounting features.
Navigation
General Ledger ► Support Entities ► Concept Accounting Account Relationship
Concept Accounting Account Relationship Screen Fields
| Fields | Description |
| Id | Auto generated by system, unique identifier. |
| Fiscal Year | Allows users to select fiscal year from drop down. |
| Code Chart Of Accounts | Allows users to select segments of the coding block from drop down. |
| Element | Allows users to select Accounting Element from look up functionality. |
| General Ledger Template Status | Automatically generated and updated based on the workflow process status. |
| Active | Default value is TRUE. If it is false, the record cannot be changed. |
| Origin | Read only. Possible values:'DATA_IMPORT', 'MANUAL', default value: 'MANUAL'. |
| State of Changes in Equity | Allows users to select Accounting Level for State of Changes in Equity from drop down. |
| Cash Flow Statement | Allows users to select Cash Flow Statement from drop down. |
| Debt Exchange Differential | Allows users to select Debt Exchange Differential from drop down. |
| Other Accountants Exchange Differential | Allows users to select Other Accountants Exchange Differential from drop down. |
General Ledger
Overview
This entity to capture the opening and YTD balance of each G/L Coding Block for each Fiscal Year. The balance gets updated upon the approval or auto generating of Journal Vouchers. If a specific G/L Coding Block is not available when a JV is posted, the system will automatically create it in the table. It is important to notice if General Parameter Sub Ledger=TRUE then system will take into account that information when creating a record in this entity.
Navigation
General Ledger ► Support Entities ► General Ledger
General Ledger Screen Fields and Tab:
| Fields | Description |
| Fiscal Year | Fiscal Year of the General Ledger, Default value is current FY. |
| Currency | Currency of the G/L account. |
| Opening Balance Debit (Domestic) | Opening Domestic Debit Balance for the Fiscal Year. |
| Opening Balance Debit (Foreign) | Opening Foreign Debit Balance for the Fiscal Year. If currency is Domestic, this value has zero. |
| Opening Balance Credit (Domestic) | Opening Domestic Credit Balance for the Fiscal Year |
| Opening Balance Credit (Foreign) | Opening Foreign Credit Balance for the Fiscal Year. If currency is Domestic, this value has zero. |
| Actual YTD Debit (Domestic) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Domestic amount posted against the Coding Block during the Fiscal Year if the total amount is Debit. |
| Actual YTD Debit (Foreign) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Foreign amount posted against the Coding Block during the Fiscal Year if the total amount is Debit. If currency is Domestic, this value has zero. |
| Actual YTD Credit (Domestic) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Domestic amount posted against the Coding Block during the Fiscal Year if the total amount is Credit. |
| Actual YTD Credit (Foreign) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Foreign amount posted against the Coding Block during the Fiscal Year if the total amount is Credit. If currency is Domestic, this value has zero. |
| Items | General ledger items. |
| Sub-Ledger Institution Code | It is associated with the institution |
| Attachment | Size |
|---|---|
| General ledger navigation.JPG | 9.6 KB |
| General ledger.jpg | 109.08 KB |
General Ledger Items
General Ledger Item Screen Fields
| Fields | Description |
| Coding Block | Coding block of the General ledger item. |
| Sub Ledger Type | Sub ledger type of the general ledger item . |
| Opening Balance Debit (Domestic) | Opening Domestic Debit Balance for the Fiscal Year. |
| Opening Balance Debit (Foreign) | Opening Foreign Debit Balance for the Fiscal Year. If currency is Domestic, this value has zero. |
| Opening Balance Credit (Domestic) | Opening Domestic Credit Balance for the Fiscal Year. |
| Opening Balance Credit (Foreign) | Opening Foreign Credit Balance for the Fiscal Year If currency is Domestic, this value has zero. |
| Actual YTD Debit (Domestic) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Domestic amount posted against the Coding Block during the Fiscal Year if the total amount is Debit. |
| Actual YTD Debit (Foreign) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Foreign amount posted against the Coding Block during the Fiscal Year if the total amount is Debit. If currency is Domestic, this value has zero. |
| Actual YTD Credit (Domestic) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Domestic amount posted against the Coding Block during the Fiscal Year if the total amount is Credit. |
| Actual YTD Credit (Foreign) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Foreign amount posted against the Coding Block during the Fiscal Year if the total amount is Credit. If currency is Domestic, this value has zero. |
| General Ledger Period | Collection of zero to many general ledger periods. When users are only entering opening balances, there might not be GL period’s transactions yet. |
| Attachment | Size |
|---|---|
| General ledger navigation.JPG | 9.6 KB |
| General ledger item.jpg | 119.3 KB |
General Ledger Account Mapping For Public Debt
Overview
The purpose of this web service is to create a Journal Voucher for adjustments of balances for the LG Accounts that belong to Public Debt and apply for exchange differential. The Web Service will receive a set of data from Public Debt System. With this data, the system should be able to complete the information required to insert a new Journal Voucher and its detail transactions
Navigation
General Ledger ► Support Entities ► General Ledger Account Mapping For Public Debt
General Ledger Account Mapping For Public Debt Screen Fields
Fields | Description |
Debt Type | Allows to select ‘Internal’ or ‘External’ type from dropdown list |
Instrument Type | Allows to select Instrument type from dropdown list |
Term Type | Allows to select Term type from dropdown list |
Debt Status | Allows to select Debt Status from dropdown list |
Creditor Type | Allows to select Creditor type from dropdown list |
Portion | True/False, Default will be true. |
Sector | Numeric Code representing sector to which creditor belongs to |
GL Account | A code representing GL accounts for Public Debt. |
Origin | Default will be manual |
General Ledger Template
Overview
This entity contains the list of accounting classes. These classes identify the different ledger accounts for the accountable transactions.
Navigation
General Ledger ► Support Entities ► General Ledger Template
General Ledger Template Screen Fields
Fields | Description |
Code | Unique ID that identifies a General Ledger Template. Consecutive unique number automatically generated by the system. |
General Ledger Template Status | The Workflow Process Status of the General Ledger Template automatically generated and updated. |
Fiscal Year | Fiscal Year of the Disbursement Request Voucher. |
Class | Associated with the General Ledger Template Class |
Sub Class | Read Only until Class is selected |
Detail | Read Only until Class and Subclass are selected |
Language | Allows to select country specific language. |
Name | Short name that identifies type Class, Subclass and Detail of transaction. |
Description | Complete description of the GLT. |
Active | Indicate if the General Ledger Template is active or not. Default = True |
Source | Basic Stages are ‘Journal Voucher’, ‘Expense Voucher’, ‘Reveneu Voucher’, Default = ‘Expense Voucher’ |
Is Accounts Payable Previous Years | True/False Default False |
Is Accounts Receivable Previous Years | True/False Default False |
Origin | Values: "DATA_IMPORT", "MANUAL", Default value: "MANUAL" |
Created By | User who created the General Ledger Template. Populated automatically by the system. |
Created Date | Date and time of creation the General Ledger Template. Default current system date and time. Populated automatically by the system at creation time of the record. |
Approved By | User who approved the General Ledger Template. Populated automatically by the system, when the document is approved. |
Approved Date | Date and time in which the General Ledger Template document turns to ‘Approved’ Status Default current system date and time. Populated automatically by the system in time of approved for registration. |
Use for Opening a Receivable Account? | True/False Default False |
Use for Opening an Account Payable? | True/False Default False |
Allow to Add Coding Blocks | True/False Default False |
Fields
Fields Tab Screen Fields
Fields | Description |
Sequence Number | Unique Id it will be created automatically |
Accounting Item | It is associated with Accounting item elements |
Coding Block | Full Coding Block of the Account. |
Credit Debit | Allows to select Debit/Credit from the dropdown list |
General Ledger Template Class
Overview
Entity that has the list of classes, subclasses and details of GLT in hierarchical design.
Navigation
General Ledger ► Support Entities ► General Ledger Template Class
General Ledger Template Class Screen Fields
Fields | Description |
Application Id | Item unique ID, can be either “Calculated/Updated Read Only Field” system generated automatic. |
Type | Allows to select values: ‘Class’, ‘Subclass’, ‘Detail’ |
Language | Country specific language. |
Name | Short name that identifies the register transaction. |
Description | Complete description of the register transaction. |
Active | To indicate if the transfer type is active or restrictive. Default value is ‘true’ |
Origin | Allows to select values: ‘MANUAL’, ‘DATA_IMPORT’. Default is ‘MANUAL’ |
General Ledger Template Class Parent | If the transaction Type is Class this will NULL. If the transaction Type is Subclass this will show the list of Active transaction type Class. If the transaction Type is Detail this will show the list of Active transaction type Subclass. |
Transaction Analysis
Overview
This defines the type of Transaction in Journal voucher. While entering a Journal Voucher this defines the purpose of the entry or the reason of posting the entry
Navigation
General Ledger ► Support Entities ► Transaction Analysis
Transaction Analysis Screen Fields
| Fields | Description |
| Code | Code of the transaction analysis. |
| Active | True by default. If user switches this to False, then system will not allow to select this record in future transactions. |
| Abbreviation | Short Description of the Transaction Analysis. |
| Description | Details Description of the Transaction Analysis. |
| Attachment | Size |
|---|---|
| Transaction Analysis.JPG | 34.08 KB |
| Transaction analysis navigation.JPG | 10.01 KB |
