NetLease - Custom Reclass Journal Type

Overview

A Custom Reclass Journal Type may be required for specific client circumstances. This article walks through the steps needed to create a custom journal entry so it will appear as an option in NetLease > Process Monthly Transactions > Monthly Reclass Journals.

Prior to creating the custom reclass record, all applicable reclass information should be entered in the NetLease software. This includes the applicable mapping as described in the Lease Type configuration article.

Step-by-Step Process

In the NetSuite Search pane, search for NetLease Reclass Journal Type and select the first option.
- Select the New NetLease Reclass Journal Type button to create the custom journal type.
- Enter the applicable information on the Reclass Journal Type screen. Field descriptions are provided in the table below.

Field	Description
Name	Input a unique name to define the custom reclass.
Post as Reversal Journal	Check this box if the reclass should post as a reversal journal.
Reclass Formula	Provide the formula for the desired reclass amount if the amount cannot be found on a field in the Reclass Amount dropdown list. More information on how to construct a formula is provided later on in this article.
Debit Account	Select the lease type field for the account to be debited for the reclass amount.
Credit Account	Select the lease type field for the account to be credited for the reclass amount.
Reclass Amount	Select the schedule line field populated with the reclass amount.
Tag To	Select the schedule line field to populate with the reclass journal entry that will be created.
Tag To (Multi-Book)	If applicable, select the schedule line field to populate with the multi-book reclass journal entry that will be created.
Interval (Months)	Select the interval (in months) over which the short-term/long-term reclass will be calculated.
Short-Term/Long-Term Portion	Select the portion (ST or LT) to post as the reclass amount.
Balance (Take Difference Over Interval)	Select the schedule line field the reclass amount will be calculated from—by using the short-term/long-term interval and subtracting the difference in the balance over the interval.
Profit & Loss Field (Sum Activity Over Interval)	Select the schedule line field the reclass amount will be calculated from—by using the short-term/long-term interval and summing the activity over the interval.
Limit Transaction Type	Optionally limit the schedule line transaction type(s) for which this reclass entry can be created (multiselect supported). If left blank, the reclass will only run on amortization schedule lines.
Limit to Lease Classifications	Optionally select lease classifications to narrow down the processing of the custom reclass (multiselect supported).

Click Save once all applicable information has been entered.

Using Custom Formulas on Reclass Types

When setting up a Custom Reclass Journal Type, the reclass amount can be defined using a Formula instead of selecting a specific schedule line field. This provides additional flexibility to calculate reclass amounts dynamically—for example, by applying a percentage, combining multiple fields, or handling conditional logic.

Formula vs. Reclass Amount Field

Each Reclass Type supports two mutually exclusive options for determining the reclass amount:

Option	When to Use
Reclass Amount Field	Pull the reclass amount directly from a specific field on the schedule line (standard approach).
Reclass Formula	Calculate the reclass amount dynamically, such as applying a percentage or combining values.

Note: Only one option can be used at a time. If a value is entered in the reclass amount field, that will always take precedence over the formula field.

Setting a Formula

Open the Custom Reclass Journal Type record to configure.
- Leave the Reclass Amount field blank.
- Enter the formula in the Reclass Formula field.
- Populate other required reclass information as needed.
- Click Save.

When the reclass Suitelet loads and when reclass journals are run, the formula will be evaluated for each lease to determine the reclass amount. Leases where the formula evaluates to zero will be automatically excluded.

Writing a Formula

Formulas use NetSuite's standard formula field syntax. Schedule line fields are referenced using the following pattern:

{custrecord_laa_lse_lease.FIELD_ID}

Replace FIELD_ID with the internal ID of the schedule line field to use.

Examples:

Goal	Formula
50% of the standard reclass amount	({custrecord_laa_lse_lease.custrecord_laa_lse_st_reclass_amt} * 0.5)
Full standard reclass amount (same as using the field directly)	{custrecord_laa_lse_lease.custrecord_laa_lse_st_reclass_amt}

Standard SQL/Oracle expression syntax is supported, including functions such as NVL, CASE WHEN, ROUND, and standard arithmetic operators.

Validation

Either a Reclass Amount Field or a Reclass Formula must be set before saving. Attempting to save with neither configured will display an alert and block the save.
If both fields have values when the record loads (e.g., due to a data migration), the Formula will be automatically cleared and the Reclass Amount Field will take precedence.

Considerations

Formula values can be positive or negative. Custom reclass types support both.
Zero results are excluded. If the formula evaluates to 0 for a lease, that lease will not appear in the reclass selection list and no journal will be created for it.
Formulas are not validated on save. If the formula contains an unrecognized field or invalid syntax, the error will surface when the reclass suitelet or journal process runs. If an "unrecognized field" error appears, verify that all field IDs in the formula are correct and use the {custrecord_laa_lse_lease.FIELD_ID} prefix format.

Was this article helpful?