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 MR | Generate Loan Schedules for all loans in "Pending" status. |
| NetLoan - Automatic Commencement MR | Move Loan status from "Pending" to "Commenced". |
| NetLoan - Automatic Journals MR | Create Initial Balance, Amortization, and Modification Journal Entries. |
| NetLoan - Automatic Billing MR | Create NetSuite Invoice or Bill record. |
| NetLoan - Automatic Modifications MR | Process Modification Proposals in "Approved" status and update loan schedules where new payment or rate records have been added. |
| NetLoan - Automatic Fee Generation MR | Follow the steps listed in the linked article. |
| NetLoan - Automatic Payment Application MR | Follow the steps listed in the linked article. |
| NetLoan - Automatic Collections MR | Update "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
