NetLease Allocations
Overview
NetLease can facilitate the split out of G/L impacts based on information entered on a custom child allocation record.
STEP BY STEP PROCESS:
Creating the Child Allocation Record
Navigate to Customization > Lists, Records, & Fields > Record Types > New and do the following when defining a new Child Allocation record:
- Enter a "Name" for the allocations being defined (e.g. Allocation)
- Uncheck "Include Name Field" as most of the time individual allocation records do not need to be named
- Change the ACCESS TYPE field to "Use Permission List" and give desired roles Full access on the "Permissions" subtab.
- Check "Allow Child Record Editing" to allow allocations to be entered as an inline sublist from the lease record
- Save the new Custom Record Type
Next, drill back into the Allocation record that was just created and add fields to define the mapping by clicking the "New Field" button:
All three of the following fields will need to be created in the Allocation record:
1) Lease Field - Put the TYPE field as "List/Record", the LIST/RECORD field should be "NetLease Lease", check the box "Show in List" and "Record is Parent". Specify under the "Display" subtab which subtab on the Lease record that the allocations should appear via the "Parent Subtab" field.
2) Segmentation Field - This is the segment that needs to be allocated. It can be any field type so long as it matches the field type of where this information is sourced to the transaction.
3) Amount Field - This can be either a Decimal Number or an Integer field.
Once all fields have been added to the Allocation record, a NetLease Custom Sourcing record needs to be setup to pull from the allocation record to the posted transaction.
Sourcing Allocations to Posting Lease Transactions
Navigate to NetLease > NetLease Setup > Manage Custom Sourcing > New
Enter field information to define sourcing from the Allocation record to the posting transaction (be sure to specify the "Type" as "Allocations" to ensure all necessary fields are available).
Field | Description |
| Name | Input a unique name to define the custom sourcing. |
| Type | Select "Transaction Posting" to source from the lease record to any automated posting transactions and select "Allocations" to source from the allocation record to the transaction record. |
| Allocation Record | The custom record used to define the allocation. |
| Allocation Lease Field | The field referencing the lease on the allocation record. Used to identify which lease the allocation applies to. |
| Allocation Lease Proposal Field | Input the field on the allocations record that relates to a lease proposal if you would like the allocations to be setup on lease proposals and transferred to a lease. |
| Allocation Amount Field | The amount to allocate to the "From Allocation Field" in proportion to the other allocation records on the lease. |
| From Allocation Field | Input the lease field to source to (e.g. Class). |
| To Transaction Field | Input the transaction field to source from (e.g. Class (Journal Line)). |
| Apply To Impacts | Filter the impacts for which this custom sourcing should apply (e.g. apply sourcing only for debits). |
| Apply To Transaction Types | Filter the transaction types for which this custom sourcing should apply (e.g. apply sourcing only for Termination entries). |
| Apply To Accounts | Filter the accounts for which this sourcing should apply to (e.g. apply sourcing only on Balance Sheet accounts). |
| Apply To Subsidiaries | Filter the subsidiaries for which this custom sourcing should apply (e.g. apply sourcing only for the Parent Company). |
| Apply To Classifications | Filter the lease classifications for which this custom sourcing should apply (e.g. apply sourcing only for the Financing leases). |
| Apply To Lease Types | Filter the lease types for which this custom sourcing should apply (e.g. apply sourcing only for Real Estate leases). |
| Apply to Accounting Books (optional) | Filter the accounting books for which this custom sourcing should apply (e.g. apply sourcing only for tax books). |
Once this record is saved, the only remaining setup activity is to make sure that the allocations sublist appears where desired on the NetLease Lease form. It's recommended to use the provided "Allocations" subtab for a cleaner interface:
Enter the allocation criteria (ex: class) and the allocation amount (ex: percentage to allocate to that class), save, and add additional allocations as needed (ex: for another class). Note that allocations are based on relative allocation amounts. The relative weight will be calculated based on the individual allocation amount for each line divided by the sum of all the allocation amounts.
The final result splits out G/L impacts based on the allocations defined on the lease record: