NetLessor - Mass Payment Modifications

OVERVIEW

NetLessor has the ability to mass modify leases in a bulk batch process. This step is especially helpful for users with high volume payment modifications. 

STEP BY STEP PROCESS

1. Fill out a template for the information you want to update/import

If you want to update payment lines that already exist in the system, follow the steps in the article CSV Upload to Change Fields then come back to step 2 of this article. 

If you want to add new payment lines follow the steps below:

  • Fill out the appropriate information on the NetLessor Modification Upload - Payment template. NetLessor Modification Upload - Payment.
  • Import into NetLessor by navigating to Setup > Import/Export > Import CSV Records 
    • Import Type: Custom Record
    • Record Type: NetLessor Lease Payment                                                                                      
    • Data Handling: Add 
    • Map the corresponding fields from the template to the NetSuite fields
      • Lease Internal ID will need to be mapped to the Lease (Req) field and the mapping updated to have a Reference Type of Internal ID
    • If desired, save as a Saved Import by entering an Import Map Name and selecting Save and Run
      • Saved Imports are viewed by navigating to Setup > Import/Export > Saved CSV Imports
  • Confirm that all the payment records have been imported successfully
  • Note that payment records will show up under the Lease Payment subtab and not on the modification record

2. Upload NetLessor Modification Proposals

  • Fill out the appropriate information on the NetLessor Modification Upload - Proposal template
    • The modification type should be "Standard" if you are updating/adding a new lease payment
    • The modification type should be "Non-Lease Payment" if you are updating/adding a non-lease payment
    • If you do not want the modification proposal to go through a review, update the status field to be "Approved".  NetLessor Modification Upload - Proposal.
  • Import into NetLessor by navigating to Setup > Import/Export > Import CSV Records 
    • Import Type: Custom Record
    • Record Type: NetLessor Modifications
    • Data Handling: Add 
    • Map the corresponding fields from the template to the NetSuite fields
      • Lease Internal ID will need to be mapped to the Lease, which is a concatenated field of the Lease ID and Lease Name
    • If desired, save as a Saved Import be entering an Import Map Name and selecting Save and Run
      • Saved Imports are viewed by navigating to Setup > Import/Export > Saved CSV Imports                    
  • Confirmed that all the proposal records have been imported successfully

3. Process the mass modification

  • Navigate to NetLessor > Mass Update Leases > Mass Modify Leases
    • Here you will see all the leases pending modification
    • The effective date of the modification will be the first period after amortization entries have been run
    • Enter any desired filters and click Filter Results if you would only like a subset of lease modifications to be processed
  • Once you have reviewed the leases and you’re happy with the leases displaying in the sublist, click the Mark All button then click the Modify button.

  • Click Refresh until the process status shows Complete
  • Once the process is complete you will see a list of Modified Leases

  • Click on the lease hyperlink to be redirected to the lease record
  • If you would like to reverse the renewal, simply click the Reverse Modification button, and confirm your intent to reverse by clicking Ok
  • The reversal will reverse the lease record and amortization schedule back to before the update. The payment record will need to be manually deleted from the payment subtab. 

 

Was this article helpful?