NetLoan - Payment Type Automation Setup

Overview

Payment types in NetLoan can automatically be applied to loans that meet defined criteria. This applies to any payment types (fees, charges, etc.) and is handled by a scheduled Map-Reduce script that runs on a defined interval. You can also trigger it manually using the Test Auto-Generation button on the Payment Type record.

Auto-Generation Field Descriptions

To configure auto-generation, populate the fields in the Auto-Generation section of the Payment Type record:

Field	Description
Auto-Generation Saved Search	Used to find the loans this payment type should be applied to. The search will need to be configured with criteria that identifies the loans this payment type should be applied to. Two record types are supported: Loan saved search - must include the loans' Internal ID as the first result column Schedule Line saved search - must include the Loan field (custrecord_da_lsa_loan) as the first result column Note: For borrower-level grouping, include the Borrower column in your search.
Auto-Generation Query	An Alternative to the Saved Search for identifying which loans this payment type should be applied to, using SQL. The query must return a result set with an ID column containing the loan internal IDs. This placeholder (current_date) can be used in your query and will be replaced with the date the script runs. Note: SQL coding is required for this field. If you lack development resources, AI tools can help generate and troubleshoot queries. Alternatively, contact your preferred implementation partner. For additional assistance, reach out to support@netgain.tech.
Auto-Generation Timing Unit	Sets the unit time used to calculate the payment date. Available options: Days - adds the specified number of days to the execution date Weeks - adds the specified number of weeks to the execution date Months - adds the specified number of months to the execution date Business Day Convention - adjusts the date using the loan's configured business day convention Payments - schedules the payment at the Nth future payment period on the loan's amortization schedule. For example, if Timing Unit is set to Payments and Timing Periods to 2, the script looks at the loan's amortization schedule, finds the next upcoming payment periods, skips ahead 2 periods from there, and places the payment on that period's due date The practical difference from using "Months" is that Payments respects the actual schedule dates on the loan which matters when loans have irregular payment intervals, stub periods, or non-standard amortization. Using Months would just do calendar math, while Payments anchor to the schedule itself.
Auto-Generation Timing Periods	Defines how many units (as determined by the Timing Unit field) to add to the script execution date to determine the payment date on the amortization schedule. For example, if Timing Unit is Months and this fields is set to 1, the payment will be schedule one month from the date the script runs. If Timing Unit is Payments, this value identifies which future period on the schedule to use. Note: This field is not used when Timing Unit is set to Business Day Convention.
Auto-Generation Percentage	If the payment amount should be calculated as a percentage of a value returned by the Auto-Generation Apply Percentage Search, enter the percentage here (e.g., enter 5 for 5%). If left blank, the system will fall back to the Auto-Generation Amount Query or the Default Payment Amount configured on the payment type record.
Auto-Generation Apply Percentage Search	A saved search used to determine the value to which the Auto-Generation Percentage will be applied. Supports Loan or Schedule Line record types. The first result column should be the loan Internal Id, and the value to apply the percentage to should be in the second result column. Note: If you need more advanced criteria than a saved search can provide, use the Auto-Generation Query field instead.
Auto-Generation Amount Query	An advanced alternative to the Auto-Generation Apply Percentage Search for dynamically calculating the payment amount using SQL. The query must return a result set with an (amount) column. Supports the placeholders (current_date) (replaced with the script execution date) and (loan_id) (replaced with the ID of the loan being processed). Note: SQL coding is required for this field. If you lack development resources, AI tools can help generate and troubleshoot queries. Alternatively, contact your preferred implementation partner. For additional assistance, reach out to support@netgain.tech.

Step by Step Process

Prepare your loan selection criteria. Before configuring the record, decide how you want to identify which loans this payment type applies to and prepare the appropriate input.
- Saved Search - Create a Loan or Schedule Line saved search filtered to the target loans. Ensure the loan Internal ID (Loan searches) or the (custrecord_da_lse_loan) field (Schedule Line searches) is included as the first result column. Reference this NetSuite article for additional guidance on how to create a new saved search.
- SQL Query - Write a query that returns an ID column of loan internal IDs. (current-date) is supported as a placeholder. If you lack development resources, AI tools can help generate and troubleshoot queries. Alternatively, contact your preferred implementation partner or reach out to support@netgain.tech.
Prepare your payment amount criteria (if applicable). If the payment amount should be calculated dynamically, prepare one of the following:
- Apply Percentage Search - Create a saved search where the loan internal ID is the first result column and the value to apply the percentage to is in the second.
- Amount Query - Write a query returning an (amount) column. Supports (current_date) and (loan_id) placeholders. If you lack development resources, AI tools can help generate and troubleshoot queries. Alternatively, contact your preferred implementation partner or reach out to support@netgain.tech.
Select your loan criteria input. Populate either the Auto-Generation Saved Search field or the Auto-Generation Query field from Step 1.
Configure timing. In the Auto-Generation Timing Unit field, select how you want the payment date to be calculated: Days, Weeks, Months, Business Day Convention, or Payments. Then enter a value in Auto-Generation Timing Periods to specify how far from the script execution date the payment should fall.

Note: Timing Periods is not used when Timing Unit is set to Business Day Convention.
Configure the payment amount (optional). If you'd like the payment amount calculated dynamically, enter the percentage in Auto-Generation Percentage and select your Apply Percentage Search or Amount Query from Step 2. If no percentage calculation is needed, leave these fields blank and use the Default Payment Amount field on the payment type record instead.
Save the Payment Type record. Click Save to apply your configuration.

Was this article helpful?