NetLoan - Automate Jobs Scripts

Purpose

The NetLoan - Automate Jobs MR scripts streamline and automate key NetLoan functions, including schedule generation, commencing loans, running journals, processing bills and invoices, generating fees, and updating the Management tab within loan records. 


Step-By-Step Setup Guide

Pre-Setup Requirements

  • Ensure you have NetSuite access with the required permissions.

  • Identify which key NetLoan functions need to be automated

Navigate in NetSuite to "Scripts"

Locate "NetLoan - Automate Jobs MR"


Select the "Deployments" tab

Select NetLoan Process to Automate

Title
NetLoan Process
NetLoan - Automatic Schedules MRGenerate Loan Schedules for all loans in "Pending" status.
NetLoan - Automatic Commencement MRMove Loan status from "Pending" to "Commenced".
NetLoan - Automatic Journals MRCreate Initial Balance, Amortization, and Modification Journal Entries.
NetLoan - Automatic Billing MRCreate NetSuite Invoice or Bill record.
NetLoan - Automatic Modifications MRProcess Modification Proposals in "Approved" status and update loan schedules where new payment or rate records have been added.
NetLoan - Automatic Fee Generation MRFollow the steps listed in the linked article.
NetLoan - Automatic Payment Application MRFollow the steps listed in the linked article.
NetLoan - Automatic Collections MRUpdate "Management" tab of loans for a summary of the current status as of the date updated. (Lenders Only)

Make a copy of Script Deployment

Rename and save

*This will allow any customizations to stick and not be reset with updates

Adjust "Schedule" for the frequency of running

*15 minutes is the lowest repeat time; recommend repeat time to be as infrequently as possible to minimize NetSuite processing impacts. 

List of common adjustments

Title
NetLoan Process
NetLoan - Automatic Commencement MR
Add criteria to only move loans to "Commenced" status that have a Sales Order in a "Pending Billing" status.
NetLoan - Automatic Journals MR
Add criteria to only run "Initial Balance" entries to allow modifications to be processed. Then run monthly entries manually at end of month.
NetLoan - Automatic Billing MR
Add criteria to run only bills 15 days prior to the payment date.
NetLoan - Automatic Modifications MR
Remove criteria to only process Modification Proposals or to update schedules for new Payment/Rate records.

Adjust "Parameters" if needed to limit the Loans affected

  • Find "Saved Search" inside "Parameters"  
  • Search for Saved Search in the Global Search Bar


  • Add new Criteria to narrow down results


  • "Save As" new name    
  • Update "Saved Search" section in "Parameters" of the script created with Saved Search created  

Test by manual execution







Was this article helpful?