4.12.1 GL Template Detail

This topic describes about the infromation of GL tempate detail.

  1. On Home screen, type UTDGLTMP in the text box, and click Next.
    The GL Template Detail screen is displayed.
  2. Specify any or all of the details corresponding to the message you want to retrieve.
    The system uses your specifications to as search criteria to query the database and retrieve the record as specified.
  3. On GL Template Detail screen, click New and specify the details.
    For more information on fields, refer to the field description table.

    Table 4-15 GL Template Detail - Field Description

    Field Description Attributes
    Template ID

    Specify the unique ID for the template that you are setting up.

    Alphanumeric; 10 Characters; Mandatory

    Template Description

    Specify the description for the template.

    Alphanumeric; 35 Characters; Mandatory

    Business Event

    Click the Search icon and select the business event for which the template is being defined.

    Alphanumeric; 2 Characters; Mandatory

    Trigger Event

    Click the Search icon and select the trigger event on which GL Extraction will be initiated.

    The available options are:
    • Unitization
    • Authorization
    • Settlement

    Alphanumeric; 15 Characters; Mandatory

    Theoretical Entries
    Select one of the options from the drop-down to indicate if there are entries that will be used for reporting only. The available options are:
    • Yes
    • No

    Mandatory

    GL Currency

    Click the Search icon and select the GL currency from the drop-down list.

    Alphanumeric; 3 Characters; Mandatory

    Product Level Apply
    Indicate if the template is applicable at the product level or not from the drop-down list. The available options are:
    • Yes
    • No

    Note: You can maintain a GL Setup for more than one currency. This is done by choosing the option All Currency against the field GL Currency. This allows you to maintain one GL for transactions carried out by the customer in different currencies. There will be a currency wise posting in the GL.

    Optional

    Component & Primary Account Details Specify the details under this section. NA
    Component ID

    Click the Search icon and select the component ID's of the components that must appear as entries in the general ledger sub-accounts of the selected funds, for the selected business event. from the drop-down list.

    All the loads that have been defined in the system will be included in the drop-down list. You can also select the option VAT.

    Alphanumeric; 20 Characters; Mandatory

    Component Description

    Displays the description of the component based on the component ID selected.

    Alphanumeric; 255 Characters; Mandatory

    Debit/Credit

    Indicate whether the entries arising due to the selected business event are to be deemed as positive (debit) entries or negative (credit) entries in the general ledger.

    Mandatory

    Primary Account Details Specify the details under this section. NA
    Entity
    Select the primary initiating entity from the drop-down list. The available options are:
    • Unit Holder ID
    • Distributor
    • AMC
    • Fund
    • Product

    Mandatory

    GL SetUp For

    The GL set up may be defined for Payment, General Ledger, CASA or SAP. Indicate the same in this field.

    Different fields are displayed, enabled or disabled depending on what option you choose. The same is explained below.

    Mandatory

    Accounting Currency
    Select the accounting currency for the primary entity from the drop-down list. The available options are:
    • Fund Base Currency
    • Transaction Currency
    • Product Base Currency

    Mandatory

    Bank Branch

    Select the bank branch from the option list provided.

    Alphanumeric; 12 Characters; Optional

    Account Number

    Specify the bank account number.

    Alphanumeric; 34 Characters; Mandatory

    Transaction Currency

    This field will be disabled if you choose the option Fund Base Currency in the field Accounting Currency. If you choose the option Transaction Currency, you can choose the Transaction Currency.

    Alphanumeric; 3 Characters; Mandatory

    Direct Debit Applicable
    Select if direct debit is applicable or not from the drop-down list. The available options are:
    • Yes
    • No

    Optional

    Contra Account Details Specify the details under this section. NA
    Contra Entity
    Select the counter party initiating entity from the drop-down list. The available options are:
    • Unit Holder ID
    • Distributor
    • AMC
    • Fund
    • Product

    Mandatory

    GL SetUp For

    The GL set up may be defined for Payment, General Ledger, CASA or SAP. Indicate the same in this field from the drop-down list.

    Different fields are displayed, enabled or disabled depending on what option you choose. The same is explained below:
    • CASA
    • GL
    • SAP
    • Payment

    Depending on what you choose, certain fields will be displayed. The same is explained below:

    Mandatory

    Contra Accounting Currency
    Select the accounting currency for the counter party entity from the drop-down list. The available options are:
    • Fund Base Currency
    • Transaction Currency
    • Product Base Currency

    Mandatory

    Contra Bank Branch

    Select the bank branch from the drop-down list.

    Alphanumeric; 12 Characters; Optional

    Contra Account Number

    Specify the bank account number.

    Alphanumeric; 34 Characters; Mandatory

    Contra Transaction Currency

    This field will be disabled if you choose the option Fund Base Currency in the field Accounting Currency. If you choose the option Transaction Currency, you can choose the Transaction Currency.

    Alphanumeric; 3 Characters; Mandatory

    Direct Debit Applicable
    Select if direct debit is applicable or not from the drop-down list. The available options are:
    • Yes
    • No

    Optional

  4. Click Save to save the record.