Parameter Setup for Capitalized Interest

Tobias Stenbråten Updated by Tobias Stenbråten

Under Cepheo Project Management and parameters, there is a FastTab for setting up Capitalized Interest functionality.

Setup Tab Configuration

The Setup tab contains the following parameters for configuring Capitalized Interest calculations:

Parameter

Description

Project Category

Category to be used for posting of interest calculated by the wizard

Prefix

Prefix used as description when creating the journal

Project Manager

Security role needed to run the wizard, if not system administrator

Journal Name

Expense journal to be used when creating the journal from Capitalized Interest Overview

Round Rule Type

Standardized D365 selection on how rounding should be carried out

Minimum Amount

Amounts lower than this parameter will not be included in the calculation

Line Limit

If there are many lines, this parameter can be set to a given level to improve performance

Include Revenue

Should fee lines that are invoiced be included as part of the interest calculation

Emergency Edit

Opens up the possibility to delete and change staging table data in order to make corrections. Only to be used when reversal of posting or adjustment cannot be selected. Should in day-to-day operation be set to no.

Emergency Edit should only be enabled when standard reversal or adjustment options are not available. This setting should remain disabled during normal operations.

Project Tab Configuration

blurred_image_v4.png

The Project tab contains the following parameters for managing project inclusion and exclusion in Capitalized Interest calculations:

Function

Description

Add by Group

Add projects based on their project group. This will select the header project and any subprojects connected to that structure

Delete

Remove projects from the list

Exclude Projects

Exclude specific projects from structures that you do not want to include in the calculation

Stop Project

Stop projects from being included in calculations

Setup can be performed in three ways:

  • Manual Configuration: Add, exclude, or stop projects individually through this parameter interface
  • Automated Import: Use the Microsoft add-on in the top corner and utilize the entity import framework. This functionality can also be accessed directly on the project itself
  • On the Cepheo® project details FastTab: Configure directly on the actual project

Interest Rate Configuration

The Interest Rate Configuration section allows you to manage interest calculation periods and rates. The following functions and parameters are available:

Function/Parameter

Description

Add

Add period manually for interest calculation

Create Period

Automatically create calculation periods

Period Closed

When set to "Yes", prevents interest calculations from being run for this period

End Date

End date for transactions to be included in the calculation

Interest Rate

Rate per period for monthly setup. For quarterly rates, divide by 3; for yearly rates, divide by 12

Interest Percentage

Default rate used when no specific interest rate is defined for the period

When configuring interest rates, ensure the rate corresponds to your period setup. Monthly periods require monthly rates, while quarterly or yearly rates must be converted accordingly.

Mapping Configuration

The Mapping Configuration section is used when projects require additional categorization beyond the standard project category and project ID setup. This configuration allows for more granular control over how capitalized interest is posted to expense journals.

Field

Description

Project ID

The specific project identifier for which additional mapping requirements are needed

Activity

Optional activity specification for more detailed project tracking

Category

Project category assignment for the mapped configuration

Resource

Resource assignment when specific resource tracking is required

Line Property

Additional line property specifications for enhanced project categorization

The mapping table is only required when you need additional categorization beyond the standard category and project ID requirements for expense journal posting.

Log Configuration

The Log Configuration section provides audit trail information for Capitalized Interest wizard executions. This section displays the following information:

Field

Description

Last Run Date

Date and time when the Capitalized Interest wizard was last executed

Created By

User who initiated the last wizard execution

Execution Status

Status of the last wizard run (successful, failed, or in progress)

The log provides important audit trail information for tracking when capitalized interest calculations were performed and by whom, ensuring proper governance and accountability.

How did we do?

Run Capitalized interest wizard

Contact