NetLease - Use a Different Segment for Balance Sheet or P&L Accounts
Overview
Use Case
Some companies need:
- One segment on the Lease Balance (Balance Sheet) accounts
- A different segment on the related Expense (P&L) account
This is common when leased assets are managed centrally, but lease income or expense needs to be tracked by a different segment. It can also apply when reporting needs to reflect lease activity by department, location, class, or another segment.
By default, NetLease carries the same segments to all posting lines generated from the lease.
If you want different segments for different accounts, you’ll need to:
- Create a second segment field on the NetLease Lease record
- Use Custom Sourcing to control which segment posts to the Balance Sheet and which posts to the Income or Expense account
This process works the same for department, location, class, or other custom segments.
Prerequisite
Before starting this setup, please review the Manage Custom Sourcing article. It contains the detailed instructions for creating sourcing rules.
This article provides a high-level overview of the process, but the detailed configuration steps for Custom Sourcing are covered there.
Step-by-Step Setup
1. Add Field to the NetLease Lease Form. This is the field that the custom sourcing will look to for the segment retagging on transactions.
2. Create a new Custom Sourcing rule using the Transaction Posting trigger. Make sure to specify the accounts the rule should apply to in the Sourcing Filters section; otherwise, it will update the segment on all journal lines. When setting up the rule, select the new field you created on the NetLease Lease record as the source field.
3. Now when journals are run, the new segment will be applied to the accounts specified in the sourcing.