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.
Prerequisites
NetSuite access with permissions to Customization > Scripting > Scripts
Identify which key NetLoan functions need to be automated
Step-by-Step
1. Navigate to Customization > Scripting > Scripts.
2. Locate the NetLoan - Automate Jobs MR script.
3. Select the Deployments tab.
4. 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 | Auto-generate payments based on each custom payment type. Follow the steps listed in the linked article. |
| NetLoan - Automatic Payment Application MR | Auto-apply payments based on each custom payment type. 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 (lender loans only). For more information, see the linked article. |
| NetLoan - Automatic Statement Generation MR | Generate borrower statements from a NetLoan Statement Template on a schedule. |
| NetLoan - Automatic Statement Emailing MR | Email previously generated statements to borrowers. Must be scheduled to run after Statement Generation. |
5. Make a copy of the script deployment.
6. Rename and save.
*This will allow any customizations to survive NetLoan bundle updates.
7. Adjust Schedule for the frequency of running.
*15 minutes is the shortest repeat time. It is recommend to repeat 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. |
8. Adjust Parameters if needed to limit the loans impacted.
(a) Find Saved Search inside Parameters.
(b) Search for the saved search in the global search bar.
(c) Add new Criteria to narrow down results.
(d) Save As with a new name.
(e) Update the Saved Search selected in the Parameters of the script deployment.
9. Test by manual execution. Select Save and Execute.
10. If the test executes as expected, change the Status from Not Scheduled to Scheduled and save.
