NetLoan - Payment Type Schedule Line Tagging Setup

Schedule Line Tagging Setup

This section is used when you have multiple custom payment types that need to be tracked separately from one another using custom fields on the schedule line record. These custom fields would need to be created on the schedule line record before selecting those here. For those payment types that are amortized 4 custom fields are required where as all others would only require one custom field.

FieldDescription
Schedule Line Field ID
Custom schedule line field that captures new fee amounts when they are incurred
Amortization Schedule Line Field ID
Custom schedule line field that indicates the new amortization amount for that period (only needed if payment is amortized)
Amortization balance Schedule Line Field ID
Custom schedule line field that shows the remaining balance to be amortized as of that period (only needed if payment is amortized)
Accumulated Amortization Schedule Line Field ID
Custom schedule line field that sums the total amortization that has been recognized as of that period (only needed if payment is amortized) 


Step-By-Step Setup

  1. Before you will be able to select the custom schedule line fields you would like to use to capture the payment and payment amortization information (if applicable) you will need to add those fields to the NetLoan Schedule Line record. 
    1. First, navigate to Customizations>Lists, Records, & Fields>Record Types to see the list of custom records.
    2. Select the NetLoan Schedule Line record.
    3. Click the Forms subtab and select the preferred form. Make sure to use a copy of the Standard Netgain form. If you haven't done that follow the instructions in this article.
    4. Select the Add Fields button.
    5. Fill in all the necessary field information and save the record.
    6. Create 3 more custom fields if you need to also track amortization on this payment. You will need one field to track the amortization balance, the new amortization recognized, and the accumulated amortization for each period.
  2. Now that you have created the necessary custom fields you can select these fields in each of the dropdowns under the Schedule Line Tagging subtab on the NetLoan Payment Type record.
  3. Save the NetLoan Payment Type record to apply the changes.
  4. If you would like these payments to appear on the Loan Amortization and Fee Amortization schedules on the loan record you will need to edit the saved searches underlying those sublists.
  5. Navigate back to Customizations>Lists, Records, & Fields>Record Types and select the NetLoan Loan record.
  6. Click the Sublists subtab to check for the schedules/sublists to which you would like to add a column for the payment. To the right of the schedule/sublist name there is a saved search listed. Copy and paste the name of the saved search in your global search bar and select it from the dropdown that appears.
  7. Once the saved search opens, click the Edit This Search button at the top left of the screen.
  8. Open the Results tab. Add a result column for the payment by clicking into the bottom row and selecting the desired field you entered into the Schedule line Field ID field on the payment type. Click the Add button.
  9. You can drag and drop that row up to the desired pace you would like the column to appear on the amortization schedule.
  10. Customize the saved search name to one that is unique. Click the Save As button.
  11. Navigate back to the Sublist tab on the NetLoan Loan record type and change the saved search listed next to the schedule/sublist in question to the new saved search you just created.
  12. Save the NetLoan Loan record type.
Was this article helpful?