Property Lease Management Parameters

Modules > Property lease management > Setup > Property lease management parameters

Use this page to set up the general default settings for creating leases in the Lease Details page. These values (unless otherwise noted) can be changed at the time a lease is created.

General tab

Use this tab to set the default values for creating leases and invoice, journal names, and lease accounting standard reporting (e.g., ASC 842/IFRS 16).

Set Up Default Values

To set up the general default values for Property Lease Management, follow these steps. These values can be changed at the time a lease or invoice is created.

  1. Under the Lease heading, do the following: 
    1. Specify the Area unit for a category.
    2. Select to use the following options for newly created leases: Consolidate, Prorate partial periods, Align to month, and Period by period lease.
    3. Select the lease charge Frequency.
  2. Under the Invoice heading, set the default options for the Invoice Creator pageLease type, Invoice type, and Posting option.
  3. In Sales tax included in expense, select which account is used for sales tax distribution.
  4. Under the Default Journal Names heading, specify the default journal names when invoice journals are created.
  5. Under the Lease Accounting Standard heading (e.g., ASC 842/IFRS 16) , specify the values for using the lease accounting standards: Start date, Reporting start date, and Discount rate.
  6. Select Save.

Fields

This tab contains the following fields:

Field Description
Lease
Area unit

Select the unit of measure for the area of a leasable category or level. For example, sq. ft or square yards.

The unit of measure for the area can be changed when defining the details for a category on the Properties page, but it cannot be changed when creating a lease for the category.

Consolidate

Select whether invoices for multiple leases are combined into a single invoice.

  • Yes: Creates a single invoice that combines the billing details for a customer or vendor. Invoices from a single lease can be consolidated when the separate invoices have the same customer or vendor and the same currency. This feature is available for sales order, free text invoice journal, and vendor invoices.
  • No: Separate invoices are always created.
Prorate partial periods

Select whether to prorate the partial billing periods: 

  • Yes: Calculates partial amounts for first or last periods that are not full billing periods. The amounts for partial billing periods is a fraction of the full billing period amount.
  • No: Does not calculate partial amounts when the first or last periods are not full billing periods. Partial billing periods are charged the same amount as full billing periods.
Align to month

Select whether to align the billing period for a lease to the end of a month when the lease is created:

  • Yes: Aligns the billing period of a lease to the end of a month.
  • For example, a lease is created on April 15, the end of the first billing cycle is April 30. Each subsequent billing cycle then starts on the 1st of the month and ends on the last day of the month.

  • No: Does not align the billing period for a lease to the end of a month.
  • For example, this option is selected and the billing frequency is monthly. For a billing cycle that starts on April 15, the end of the billing cycle is May 14. Each subsequent billing cycle starts on the 15th of the month and ends on the 14th of the month.

Termination

Create termination codes that are used when terminating a lease or lease charge.

To add a termination reason code, follow these steps: 

  1. Select New.
  2. Specify a unique Reason code and a Reason description.
  3. Repeat these steps to add more termination reason codes.
  4. Select Save.
Billing cycle

Use Billing cycle to set up alternative billing cycles when invoicing leases or charges.

  • Yes: You can create billing classes with different billing settings, such as frequency of billing, for example.
  • No: Leases do not use any billing cycles and there is no projected invoice date.
Period by period lease

Indicates whether the period-by-period functionality is used (for example, the invoices for a lease are month to month):

  • Yes: The period-by-period functionality is used. Invoices are created on a period-by-period basis, and lines are added based on the billing frequency of the lease.
  • No: The period-by-period functionality is not used.
Validate occupancy

Validates whether the lowest level is already occupied.

  • Yes: A validation that checks whether the lowest level is occupied based on the lease start date and end date is performed.
  • No: No validation checking whether the lowest level is occupied is performed.

When the lowest level is occupied, it can be used by only one lease and cannot be selected for use with another lease of the same lease type. However, the lowest level can be used by a revenue lease and an expense lease at the same time. Consider the examples: 

  • The lowest level is used by a revenue lease (Lease-001) from January 01, 2020, to December 31, 2020. The same lowest level can also be used by an expense lease (Lease-002) from February 01, 2020, to October 31, 2020.
  • The lowest level is used by an expense lease (Lease-003) from January 01, 2020, to December 31, 2020. The same lowest level cannot be used by a different expense lease (Lease-004) during any time from January 01, 2020, to December 31, 2020.
Frequency

Select a default billing frequency for lease charges. The options are: Monthly, Weekly, Bi-weekly, Quarterly, Annually, and One Time.

Apply fees

Select whether late fees apply to your leases: 

  • Yes: Late fees are applied to leases.
  • No: Late fees are not applied to leases.

Can be applied to both Late fees and Fees on Invoice Outstanding Balance.

Use default customer profile

Select to use the posting profile from the customer profile setup in Accounts receivable.

  • Yes: The customer profile from Accounts receivable is used when you create a new sales reporting record.
  • No: Select the posting profile from the drop-down under Posting profile.

When you set up a posting profile, you can set up your fee amount by creating an Interest code. For more information on setting up a fee amount and interest code, see Late Fee Amounts.

For more information on setting up customer profiles, see Customer posting profiles on the Microsoft Dynamics 365 for Finance and Operations documentation.

Can be applied to both Late fees and Fees on Invoice Outstanding Balance.

Posting profile

Select the posting profile to use when you create new sales reporting records. This option is not available if you use the default customer profile.

Can be applied to both Late fees and Fees on Invoice Outstanding Balance.

Include tax on fee calculation

Select to include the taxes of the lease invoice in the fee calculation.

  • Yes: Taxes are included in the late fee calculation.
  • No: Taxes are not included in the late fee calculation.

Only applies to Fees on Invoice Outstanding Balance.

Invoice
Lease type

Select the default lease type when creating invoices on the Invoice Creator: Revenue or Expense.

Invoice type

Select the default invoice type for the Invoice Creator. The invoice type available are based on the selected lease type.

For a revenue lease:

  • Free text: This invoice type is not attached to a sales order. This invoice type is available for charges that do not have an item.
  • Sales order: This invoice type is used for charges that require an item. When this option is selected, all revenue charges require an item at the time the charge is created or at the time the charge is attached to a revenue lease.

For a expense lease:  

  • Invoice journal: Invoice journals are to be created. These invoice types are similar to free text invoices and is available for charges that do not have an item.
  • Vendor invoice: Vendor invoices are to be created. These invoice types are similar to sales orders and are used for charges that require an item. When this option is selected, all expense charges require an item at the time the charge is created or at the time the charge is attached to a expense lease.

After a revenue or expense lease is created, this option cannot be edited on this setup or on the Invoice Creator.

Posting option

Select the default posting option for the Invoice Creator:

  • Create: Creates the invoice or journal entry transactions. When the invoices are created, invoice or journal numbers are automatically generated. When you manually post the transactions, be sure to change the automatically generated invoice or journal numbers.
  • Create and show form: Creates the invoices and then opens the page where you can review and edit the invoices before posting them. This option can be used when creating sales order invoices from leases where items are required. The sales order invoice numbers are automatically generated based on the setup.
  • Post invoice automatically: Creates the invoices and automatically posts the invoices using the default options. This option can be used when creating a sales order or free text invoices from leases. The sales order or free text invoice numbers are automatically generated based on the setup.

After a revenue or expense lease is created, this option cannot be edited on this setup or on the Invoice Creator.

Rebill

Select if users wants to rebill billing lines which have Credit applied against the original Sales order or Free text.

  • Yes: Allows users to rebill billing lines which have credits applied against the original Sales order or Free text.

  • No: Does not allow users to rebill billing lines which have credits applied against them.

Journal Consolidation This option is visible only when the Lease type is Expense and Invoice type is Invoice Journal. If “Journal consolidation” field is enabled at the Invoice creator, then the system will consolidate multiple lease charges in the same Invoice Journal regardless of the lease vendor. Below conditions need to be met for consolidation: On the Lease Level, Consolidation is enabled. On the Lease Level, Currency is the same for all the leases. On the Invoice Creator window, consolidation is enabled.
Journal Name

Specify the default payables journal names when invoice journals are created. Set the default names for the following invoice journals: 

  • Invoice journal - This journal is used in the Invoice creator window when creating invoice journals for Expense leases.
  • General journal - This journal is used during the initial journal processing and remeasurement processes for leases that use ASC842 & IFRS16 charges.
  • Customer payment journal - This journal is used when processing deposits for Revenue leases.
  • Vendor payment journal - This journal is used when processing deposits for Expense leases.

When creating an invoice on the Invoice Creator, this value is required.

Lease Accounting Standard - ASC 842/IFRS 16
Lease accounting standard

Select the lease accounting standard that your organization uses: 

  • ASC 842: The organization uses the ASC 842 accounting standard for expense and revenue leases. All page and field labels that require the lease accounting standard use the ASC 842 label.
  • IFRS 16: The organization uses the IFRS 16 accounting standard for expense and revenue leases. All page and field labels that require the lease accounting standard use the IFRS 16 label.
Enable modification popup

Select your notification preferences for when a change has been made to an expense or revenue lease and must be recalculated:

  • Yes: A popup will appear prompting the user to run a new journal to recalculate the lease whenever a change is made to the lease.
  • No: A popup will not appear even when a change occurs. However, a small notification bar will appear at the top of the page.

Note: An initial journal must be created for the popup to be activated.

Enable auto-remeasurement on data entity update

Select whether the data entity will automatically run the remeasurement process for the lease charge (as necessary) and have a modification journal created.

  • Yes: When an update to the Lease or Lease Charge is made through data entities, the data entity will automatically run the remeasurement process for the Lease Charge, if needed, and a modification journal will be created.
  • No: A remeasurement process will not be triggered when an update to the Lease or Lease Charge is made through data entities.
Classification

Select the classification for the expense lease:

  • Financial Lease: The lease is a financial (or capital) lease.
  • Operating Lease: The lease is an operating lease.
  • Short Term Lease: The lease is for a period of 12 months or shorter. Available for IFRS 16 only.
  • Non-Lease: The lease is similar to a Short-Term Lease where it is for a period of 12 months or shorter, but is only available for the PLM Non-Lease Summary Report (and no other type of reports).

Select the classification for the revenue lease:

  • Sales type lease
  • Direct financing lease
  • Operating lease
  • Exempt lease: Select the exempt type for the item where the recognition exemption is applied. For example, if you have a low value asset or short-term lease or non-lease components.
Use accumulative amortization account

Select whether then ROU asset accumulative amortization account is used.

  • Yes: The ROU asset accumulated amortization account is used for financial and operating expense leases.
  • For the ASC 842 accounting standard this option cannot be changed when this option is used and at lease one expense lease has been created. For the IFRS 16 accounting standard, this option is always automatically used.

  • No: The ROU asset accumulated amortization account is not used for operating expense leases and for financial leases that use the ASC 842 accounting standard. For financial leases that use the IFRS 16 accounting standard, this account is always used.
Start date

Specify the date on which the lease accounting standard regulations begin.

Report start date

Specify the reporting start date for the lease accounting standard regulations. This date is used so that transactions created after the Start date of the lease accounting standard can be recorded in parallel to the existing transactions. Also, this date is used for running comparison reports. This date must be earlier than the Start date.

If Start date does not have a value, the reporting start date cannot be entered.

Discount rate

Specify the rate used to calculate the present value of future lease payments.

Required when Start date has a value.

Invoice - Create general journal

Select whether the general journal is created for leases that follow the lease accounting standards:

  • Yes: Creates a general journal for the lease accounting standard calculations. For this option, Property Lease Management is primarily used for calculating the lease accounting standard amounts, and the invoices for the leases are created using a different program.
    The general journal is created using the lease payable clearing account for the charge as set up on the Charges page.
  • No: Creates the invoice journal or vendor invoice within Property Lease Management.
CAM reconciliation
Allow negative recoverable amount

Select whether a negative CAM recoverable amount is allowed after the CAM reconciliation is performed: 

  • Yes:  Negative CAM recoverable amounts are allowed.
  • No: Only positive CAM recoverable amounts are allowed.
Partial year calculation

Select the calculation method used for calculating the CAM expenses for a partial year: 

  • Average: Uses the daily average for the reconciled period to calculate the CAM expenses.
  • Actual: Uses the actual periods to calculate the CAM expenses.
Reconciliation year

Select whether the CAM reconciliation amount is calculated based on the fiscal or lease year.

  • Fiscal year: The CAM reconciliation is based on the fiscal year as set up in Microsoft Dynamics 365 for Finance and Operations.
  • Lease year: The CAM reconciliation is based on the lease year.

For example, the fiscal year for a company is January to December. A lease has a start date of April 1, 2018. When the CAM reconciliation is based on the fiscal year, the reconciliation is performed on December 31, 2019. When the CAM reconciliation is based on the lease year, the reconciliation is performed on March 31, 2019.

Sales based reconciliation
Allow negative recoverable amount

Select whether a negative amount is allowed after the sales based reconciliation is performed: 

  • Yes:  Negative recoverable amounts are allowed.
  • No: Only positive recoverable amounts are allowed.
Partial year calculation

If the sales reconciliation reporting includes a partial year, select how the partial year is included in the sales reconciliation calculations.

Available when Reconciliation year is Based on fiscal year.

  • Partial leasing year: Combines the partial year with a full calendar year for the reconciliation calculations. With this option, the sales and billing amounts are calculated for the full year, and then prorated based on the start date of the partial year.
  • Separate period: The partial period is treated separately from the first complete year for the reconciliation calculations. With this option, the sales and billing amounts are calculated for the full fiscal year. No proration is used.
Reconciliation year

Select how start and end dates of the sales reconciliation reporting year is determined: 

  • Based on fiscal year: Sales reconciliation reporting is based on the fiscal year of the company, which bases the start and end dates of the calendar year. The fiscal year setup on the Ledger Calendars page is part of standard Microsoft Dynamics 365 for Finance and Operations.
    When selected, specify the Partial year calculation.
  • Based on lease year: Sales reconciliation reporting is based on the lease year.
  • Tenant fiscal year: Sales reconciliation reporting is based on the tenant fiscal year. When selected, the first and last day of the fiscal year are manually specified.
Apply fees

Select whether late fees apply to your leases: 

  • Yes: Late fees are applied to leases.
  • No: Late fees are not applied to leases.
Use default customer profile

Select to use the posting profile from the customer profile setup in Accounts receivable.

  • Yes: The customer profile from Accounts receivable is used when you create a new sales reporting record.
  • No: Select the posting profile from the drop-down under Posting profile.

When you set up a posting profile, you can set up your fee amount by creating an Interest code. For more information on setting up a fee amount and interest code, see Late Fee Amounts.

For more information on setting up customer profiles, see Customer posting profiles on the Microsoft Dynamics 365 for Finance and Operations documentation.

Posting profile

Select the posting profile to use when you create new sales reporting records. This option is not available if you use the default customer profile.

Termination
Reason code

Select the termination reason code.

Termination type

Select the termination type: 

  • Default: Terminates the lease at the termination date specified. When selected, Issue credit and Prorate daily are turned off. Both options become read-only and cannot be changed.
  • Adjust schedule: The termination process will adjust the termination amount, similar to the Default option. You can choose to apply credit towards billed periods. When selected, Issue credit and Prorate daily are turned on. Both options can be adjusted
  • Bill remaining: The termination process bills all periods prior to termination date.
Credit option

When Adjust schedule is selected, you can choose how the credit is applied: 

  • Credit adjustment: Creates a credit adjustment for a charge in the lease when a line is terminated. The credit adjustment appears in a future billing period for the terminated charge and can be invoiced in future periods when the credit adjustment line is invoiced. The adjustment creates a credit document instead of a standard invoice document.
  • Issue credit: Creates a credit note when a lease or charge is terminated.
  • No credit: No credit adjustment or note is created upon termination of a lease or charge. Available only when terminating a lease using the No adjustment option.
Prorate daily Select to use the number of days for the proration calculation.
Apply termination charge

Select to apply a one-time charge termination fee to the customer.

  • Yes: Applies a one-time terminate fee to the final lease payment.
  • No: No termination fee is applied to the final lease payment.
Expense charge number Select the one-time termination charge number for your expense type lease.
Revenue charge number Select the one-time termination charge number for your revenue type lease.
Lease Status
Enable lease status workflow

Select to use workflows to update the status of your leases. To turn on Enable lease status workflow, you must have workflows already created and active.

  • Yes: Allows the status of leases to be updated through workflows.
  • No: Workflows are not used to update the status of leases.
Initial lease status by default

Select the lease status you want to use as the default initial status for your leases. If Enable lease status workflow is turned on, then Initial lease status by default is a read-only field and automatically set to Draft.

  • Active: New leases are set up as active.
  • Draft: New leases are set up as drafts. When a lease has Draft status you cannot invoice the lease.

Deposits tab

Use this tab to set up information for deposits. Deposits are used to secure a lease for a customer or vendor.

Create Deposit

To create a deposit type, follow these steps: 

  1. Select Add line.
  2. Specify a unique Deposit identifier and a Description.
  3. Select the Deposit account.
  4. Repeat these steps to add more deposit types.
  5. Select Save.

The deposit type is then available when a deposit for a lease is accepted on the Deposits page.

Fields

This tab contains the following fields:

Field Description
Deposit Specify a unique deposit identifier.
Description Specify a description for the deposit type.
Deposit account Select the account for the deposit.

Term Types tab

Use this tab to set up lease term types. Terms are useful for automatically applying the start and end dates when multiple charges are applied to a lease.

Add Term Type

To add a term type, follow these steps:

  1. Select Add line.
  2. Specify a unique Term type identifier and a descriptive Name.
  3. Repeat these steps to add more term types.
  4. Select Save.

The term types are available to be applied to a lease on Lease Term FastTab of the Lease Details page.

Fields

This tab contains the following fields:

Field Description
Term type Specify a brief descriptive name for the term type (maximum 20 characters).
Name Specify a longer descriptive name for the term type (maximum 60 characters).

Fields

This page contains the following fields: 

Field Description
Reason code Specify a unique termination code.
Reason description Specify a description of the termination code.

Number Sequences tab

Use this tab to set the default values for lease number sequences, sales reporting number sequences, and fee note number sequences. Before setting up the number sequences, review Generate Number Sequences.

Set Up Automatic Numbering

To set up the automatic number for leases, do the following: 

  1. For the Reference you want to set, check that the Number sequence code has a value.
    • If the number sequence code is empty, you must generate the number sequence for the Reference number you want.
      For more information, see the Microsoft Dynamics 365 for Finance and Operations documentation.
    • If the number sequence has a value, continue to the next step.
  2. Select Save.

When a lease is created on the Lease Details, the lease number is automatically generated.

Fields

This tab contains the following fields:

Field Description
Reference Displays the field reference for the number sequence.
Number sequence code

Displays the next number ID for a lease.

The number sequences are automatically generated and assigned using the number sequence generation wizard. You do not need to change the number sequence unless you want to make manual changes on top of the generated number sequences.

Custom Fields tab

Use this FastTab to set up custom fields for revenue and expense leases. Custom fields (previously known as User Defined Fields) are for company-specific information and do not affect the functionality of Property Lease Management. The custom fields created on this FastTab are for the lease level.

Custom fields can be created for a property category on the Properties page.

The following is an example of a custom field for a revenue lease: 

  • Field name: Maximum occupancy
  • Field type: Number

Create Custom Fields

To create custom fields, do the following: 

  1. Select the Lease type for which the custom field applies.
  2. For each custom field added to the list, do the following: 
    1. Select Add line.
    2. Specify the Field name and select the Field type.
    3. Repeat these steps to add more custom fields.
  3. Select Save.

After the custom fields are created, the values can be edited for a lease on the User Defined Fields page, which can be accessed from the Lease Details page by selecting Notifications > Custom fields.

Fields

This tab contains the following fields:

Field Description
Lease type Select lease type: Revenue or Expense. Required.
User Defined Fields
Field name Specify the unique name for the field.
Field type

Select the data type for the field: 

  • Currency (for currency numbers)
  • Checkbox (a yes/no option)
  • Date
  • Number (integer)
  • Text (free form text entry)

Lease Groups tab

Use this tab to set up lease groups which you can use to organize various leases within specific groups. Similar to Categories, you use the lease groups to organize leases, but with Lease Groups, you can assign all types of leases, expense or revenue, within the same group. You can use Lease Groups to classify certain leases and use unique number sequences, which you create in the Number Sequences tab.

Create a Lease Group

To set up a lease group, do the following:

  1. Select Add line to create a new lease group.
  2. Enter a description for the lease group.
  3. Select a number sequence.
  4. Repeat these steps to add more lease groups.
  5. Select Save.

Fields

This tab contains the following fields:

Lease groups fields
Field Description
Enable lease group number sequences

Turn on to use number sequences for your lease groups.

  • Yes: Use a number sequences for the lease groups.
  • No: Do not use number sequences for the lease groups.
Lease group lines
Lease group ID Select the lease group ID.
Description Enter a description for the lease group.
Number sequence code Select a number sequence code to use for the lease group.

Notifications tab

Use this tab to set up notifications for your leases. Setting up notifications allows you to notify your contacts – property managers, tenants, and landlords, for example – when important changes or dates coming up. For example, you can set up notifications to inform your tenant that their lease will expire soon.

After you set up your notifications, email messages are sent to the relevant contacts automatically once the conditions for the messages are fulfilled.

Before you set up your notifications in the Parameters page, do the following:

  • Make sure that your email parameters are set up. For more information on setting up email parameters, see Configure and send email. Contact your system administrator (IT) if you are unsure.

  • Create a number sequence for the Lease notification job ID. See Generate Number Sequences for more information on creating number sequences.

  • Set up email templates to use. To create customized email templates, see Email Templates.

Set Up Notifications

To set up notifications, do the following:

  1. Select Add contacts automatically if you have contacts on your property page that you want to automatically add to your notification list.

  2. Under Email templates for notifications, select the email templates you want to use for each scenario.

  3. Under Consolidation for email templates, you can add email templates that consolidate multiple notifications into one email message.

    1. Make sure to select the check box under Consolidate notifications to enable consolidation.

    2. Make sure that you create separate email templates for consolidation.

Fields

This tab contains the following fields:

Notifications fields
Field Description
Add contacts automatically

Select to add contacts that are set up on the property page to the lease or leases connected to that property.

  • Yes: Contacts on the property page are automatically added to leases which are based on that property.
  • No: Contacts on the property page are not added automatically.
Upcoming lease expiration Sends a notification that the lease is to expire on or before the value of the notification days.
Upcoming lease escalation Sends a notification that the start date of the next escalation is on or before the value of the notification days.
Upcoming insurance expiration Sends a notification that insurance is to expire on or before the value of the notification days.
Upcoming custom date Sends a notification that a custom date is on or before the value of the notification days. Available only when adding a notification to a lease.
Consolidation for email templates Add email templates for consolidated notifications. Select the checkbox under Consolidate notifications if you want that email template to be used for consolidated notifications.

Supported Data Entities for Auto-remeasurement after Update

The following is a list of existing data entities that will be modified when certain fields are changed within these entities and the Auto remeasure after data entity update parameter is set to Yes. After the update is completed, remeasurement will be done automatically and a modification journal will be created.

Data Entity Name For Revenue/Expense Trigger for Remeasurement
BssiPrmLeaseEntity Expense The Discount Rate changes.
BssiPrmLeaseChargeEntity Both Any amount or quantity is changed.
BssiPrmEscalationEntity Both Any field change, a new escalation is created, or an existing escalation is updated/deleted.
BssiPrmEscalationDetailEntity Both The Amount and Fee Amount changes.
BssiPrmAbatementEntity Both Any field change, a new abatement is created, or an existing abatement is updated/deleted.
BssiPrmTenantIncentiveEntity Expense Any field change, a new incentive is created, or an existing incentive is updated/deleted.
BssiPrmTenantIncentiveRevenueEntity Revenue Any field change, a new incentive is created, or an existing incentive is updated/deleted.
BssiPrmCpiLineEntity Both Any field change, a new CPI Line is created, or an existing CPI Line is updated/deleted.
BssiPrmRateScheduleLineEntity Both Any field change, a new Rate Schedule Line is created, or an existing Rate Schedule Line is updated/deleted.
See also

Property Lease Management Basic Setup

Charges