Determinations

Determination tables allow you to define how a variety of master data tables are used. Note that the application verifies the majority of the determination table to retrieve the latest configuration before performing postings.

For information about how to configure these tables, see Using Configuration Tables.

To access the determination tables:

  1. Click Main Menu > Configuration.
  2. In the ERP System drop-down at the top of the Navigation Panel, select the required system. The application only displays data for the selected system.
  3. Select the required sections and click on the table name. The table opens on the right of the screen.

The following tables are available, and must be configured.

Table Description

Accounting Standard Determination

Defines, per company, which accounting standard is the leading, secondary, third, or fourth accounting standard.

You can only select an Accounting Standard that has been attached to the Company.

Asset Class Determination

Maps, per company and accounting standard, the internal asset class defined in the application to the external asset classes that are specific to the classification. Also defines the default asset class useful life, which represents the life used for depreciating an asset (used for classification percentage of useful life thresholds).

The fields are based on the following master data tables:

Transaction Type Determination

Defines the Transaction Types used in the journals for each transaction, per accounting standard. If the application is integrated with SAP, the Transaction Type Values are sent to SAP.

You must configure one table entry per accounting standard used, and then select that entry to view the Transaction Type Mapping in the Relations area. In this Mapping table, you must add table entries for each required transaction type and assign the valid value (configured in the Transaction Type table).

Note: The Transaction Type Posting setting in the Company Financial Setting table must be set to "true" to use the Transaction Type Determination table.

Depreciation Area Determination

Defines, per company and accounting standard, the exchange rate type for each depreciation area.

The fields are based on the following master data tables:

  • Depreciation Area displays values from Depreciation Area.
  • Exchange Rate Type displays values from Exchange Rate Type.
  • Currency field is not used. The currency is defined by the Exchange Rate Type selected.

Note: In depreciation postings, the application sends only one document with all of the currency information together, and sends only the depreciation area that is linked with the COMPANY_CURRENCY Exchange Rate Type.

Whenever the financial schedules are generated during activation group inception, the Depreciation Area for each Accounting Standard and each Exchange Rate Type are stored. If the financial schedules are regenerated in an activation group draft, the stored value is used.

Document Type Determination

Defines, per company, the document type for each type of posting document (for lease amounts). The Document Type field displays values from the Document Type master data table.

Non Lease Document Type Determination

This table is reserved for future use.

Lessee Account Determination

Defines the set of GL accounts used for lease amount postings in lessee contracts.

You must configure a table entry for all combinations of company, asset class (optional), accounting standard, lease type (optional), and classification type. You must then select a table entry, and in the Lessee Account Mapping table, add an entry for each Lessee Account Type with the mapped General Ledger Account (which displays the accounts from the General Ledger Account master data table).

Note that if no determination is found for a particular asset class, Nakisa Lease Administration uses the determination that does not have an asset class configured.

If you require Provision accounts, you must first enable the Provision setting in Company Financial Settings, and then set up the account determination for the "Provisioning" Lease Classification Type. Ensure the Lessee Account Mapping includes the following Lessee Account Types: 

  • Provision Lease
  • Provision Lease Expense
  • Provision Lease Clearing
  • AP Lease Clearing Account
  • Currency Rounding Adjustment Expense

Lessor Account Determination

Defines the set of GL accounts used for lease amounts for lessor contracts.

You must configure a table entry for all combinations of company, asset class (optional), accounting standard, lease type (optional), and classification type. You must then select a table entry, and in the Lessor Account Mapping table, add an entry for each Lessor Account Type with the mapped General Ledger Account (which displays the accounts from the General Ledger Account master data table).

Non Lease Lessee Account Determination

Defines the set of GL accounts used for non-lease amounts for lessee contracts.

You must configure a table entry for all combinations of company, asset class (optional), accounting standard, lease type (optional), and classification type. You must then select a table entry, and enter the following information in the Relations section: 

  • In Non Lease Lessee Expense Category Account Mapping, add an entry for each Expense Category with the mapped Accrual Expense Account (which displays the accounts from the General Ledger Account master data table). Note that if the following accounts are not configured per Expense Category, the default account in the Determination table is used:
    • Non Lease Accrual Account
    • Non Lease AP Clearing Account
    • Non Lease Index Accrual Account
  • If required, in Non Lease Lessee General Ledger Account Mapping, add the General Ledger Account mapping for the following Account Type. For example, these mappings are required for Short Term and Low Value lease classifications.
    • Non-Lease Accrued Expense
    • Deferred Asset Non-Lease
    • Deferred Liability Non-Lease

If you require Provision accounts, you must first enable the Provision setting in Company Financial Settings, and then set up the account determination for the "Provisioning" Lease Classification Type. Configure the Non Lease Lessee Expense Category Account Mapping, and ensure the Non Lease Lessee General Ledger Account Mapping includes the following Lessee Account Types: 

  • For provision non-lease postings, the application uses the Non Lease Accrual Account in the Expense Category Account Mapping table in the Relations section. If it is not configured, the Non Lease Accrual Default Account in the Non Lease Lessee Account Determination table is used.
  • For provision non-lease expenses, the application uses the Non Lease Accrual Expense Account in the Expense Category Account Mapping table in the Relations section.
  • For provision non-lease clearing postings, the application uses the Non Lease Accrual Clearing Account in the Non Lease Lessee Account Determination table.

Non Lease Lessor Account Determination

Defines the set of GL accounts used for non-lease amounts for lessor contracts.

You must configure a table entry for all combinations of company, asset class (optional), accounting standard, lease type (optional), and classification type. You must then select a table entry, and in the Non Lease Lessor Account Mapping table, add an entry for each Expense Category with the mapped Accrual Income Account (which displays the accounts from the General Ledger Account master data table).

Vendor General Ledger Determination

Defines, per company and partner/vendor, the General Ledger Payable Account (for lessee contracts) and General Ledger Receivable Account (for lessor contracts). These two fields display the accounts from the General Ledger Account master data table.

Note that if the General Ledger Payable Account field is empty and Generate Vendor Invoice is enabled on a lessee contract, the vendor account from the contract is used in the payment posting (instead of the GL account).

If you require Provision accounts, you must first enable the Provision setting in Company Financial Settings, and then configure the General Ledger Payable Account Provisioning (used when Generate Vendor Invoice is selected in a contract).

Tax Code Determination

Defines the tax code determination per company, asset class (optional), and partner.

For each entry, you must define the Tax Jurisdiction (which displays values from the Tax Jurisdiction master data table), optionally an Expense Category (which displays values from the Expense Category master data table), and the Tax Exemption Percentage.

You can then select each entry, and in the Tax Code Mapping table, you can add the related Tax Codes and the Exemption Tax Code (where both tables display values from the Tax Code master data table).

See also:  

Financial Organization Structure 2023.R4 © 2023

 

 

Nakisa Inc. All rights reserved worldwide.