NetLoan - Auto-Updating the Loan from a Payment Status
Overview
A payment status can write values back to the loan record when a loan enters it, using a Loan Update JSON mapping. This lets a delinquency tier flip a flag or set a field on the loan automatically - for example, placing a defaulted loan on a fee hold so it stops accruing late fees. This article covers enabling loan updates and building the Loan Update JSON.
Prerequisits
- A custom payment status already exists. See NetLoan - Creating Custom Payment Statuses.
- A NetSuite role with administrator-level access to NetLoan Setup, and familiarity with the NetLoan Loan record's fields and their internal IDs.
- Someone comfortable writing JSON to build the field mapping. If you don't have that expertise in-house, Netgain can help or put you in touch with a partner who can build it for you.
Setup Options
Navigation
Top navigation:NetLoan > NetLoan Setup > NetLoan Payment Statuses, open the status that should update the loan.
Loan update fields (NetLoan Payment Status record)
| Field Name | Field Type | Description | Dependencies | Options / Example | Field ID |
|---|---|---|---|---|---|
| Update Loan | Checkbox | When a loan enters this status, applies your Loan Update JSON to the loan record. | Loan Update JSON | Checked | custrecord_da_pmt_status_update_loan |
| Loan Update JSON | Textarea | A JSON object of NetLoan Loan field IDs to values, applied to the loan when it enters this status. | Update Loan | See below | custrecord_da_pmt_status_loan_json |
Alongside any values in your JSON, the job always stamps the loan's Days Overdue field (custrecord_da_loan_days_overdue) with the current number of days overdue - you don't need to include that in the JSON.
Building the Loan Update JSON
The Loan Update JSON is a flat object whose keys are NetLoan Loan field internal IDs and whose values are what to set. Find a field's internal ID under Setup > Records Catalog. Example:
{ "custrecord_da_loan_hold_fee": true, "custrecord_da_loan_collections_note": "Auto-flagged at default"}- Checkbox fields take
trueorfalse. - Text fields take a string.
- List/record fields take the internal ID of the option as a string.
Tip for Success
The update is applied each time a loan enters the status, so write values that are safe to set repeatedly. Loan updates run as part of the same job that assigns the status. Out of the box that job runs nightly, so changes appear after the overnight run rather than instantly - but the script's deployment can be rescheduled to run at whatever frequency you need.
Use Case Specific Setup
Use Case: Hold fees when a loan defaults
On an "In Default" status (Parent Status = In Arrears, a high Days Overdue such as 120), stop further late fees from being added by putting the loan on a fee hold:
| Field | Setting | Notes |
|---|---|---|
| Update Loan | Checked | Applies the loan update on entering the status |
| Loan Update JSON | {"custrecord_da_loan_hold_fee": true} | Sets Hold Fees so the loan stops accruing late fees |
This pairs with the late-fee article: lower tiers issue fees, and the default tier flips the hold so fees stop once the loan defaults.
Use Case: Tag a loan for downstream reporting
To mark loans that reach a tier so they can be reported on or routed elsewhere:
| Field | Setting | Notes |
|---|---|---|
| Update Loan | Checked | |
| Loan Update JSON | {"custrecord_da_loan_collections_note": "Serious delinquency"} | Replace with your own loan field ID and value |
