NetLease - Mass Payment Modifications

OVERVIEW

NetLease has the ability to mass process modifications in a bulk batch process. This step is especially useful for users with high volume lease 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 move to step 2. If you want to add new payment lines follow the steps below.
• Fill out the appropriate information on the NetLease Modification Upload - Payment template

NetLease Modification Upload - Payment

Import into NetLease by navigating to Setup > Import/Export > Import CSV Records 

• Import Type: Custom Record
• Record Type: NetLease Lease Payment View full size
• Data Handling: Add View full size
  • 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 View full size
  • 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 View full size
      
  • Confirm that all the payment records have been imported successfully View full size
    
  • Fill out the appropriate information on the NetLease Modification Upload - Proposal template

2. Upload NetLease Modification Proposals

NetLease Modification Upload - Proposal

• Import into NetLease by navigating to Setup > Import/Export > Import CSV Records 
  • Import Type: Custom Record
  • Record Type: NetLease Modifications View full size
  • Data Handling: Add View full size
  • 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 View full size
  • 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 View full size
• Confirmed that all the proposal records have been imported successfully View full size
• Navigate to Net> 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 ran
  • 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 View full size
• Click Refresh until the process status shows Complete
• Once the process is complete you will see a list of Modified Leases View full size
  
• 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.