NLS Service

The NLS Service can be used to schedule the accrual process or to schedule report generation.

The NLS Service is not installed by default on client computers and should only be installed on those computers intended to run an automated process. During the installation process, the NLS Service may be installed by selecting Custom/Complete installation and selecting the NLS Service from the list of items to install.

ASP/Switch

For ASP/Switch customers, NLS Service is already installed and ready to use in the hosted environment. Configuration is not necessary. Skip ahead to Automated Accruals.

Configuration

  1. Navigate to the bin directory (C:\Program Files (x86)\Nortridge Software\NLS\bin) and double click NLSServiceMonitor.exe. If you receive the error message below, you will need to right-click the NLSServiceMonitor.exe and select Run as administrator.


    This will present the following dialog box:


    If you had a previous version of the NLSService Installed, you will see a different dialog box which will give you the option to remove the old NLSService—click Yes. After the old Service has been removed, click File > Connect to another computer. Select the computer that you want to connect to and you will then be to the screen shown above, where you may proceed with the remaining steps.
  2. Fill in the Windows account information and click OK.
  3. Start the service by clicking on the toolbar.
  4. Right-click on Local Computer and select Add Server.
    Fill out the database information.

    This will scan the available NLS databases on the server. If there are several databases, the process could take some time. Once it is complete, select the NLS database for which you want to configure the service and click OK.
  5. After the database has been added, it will appear in the tree of the Service Monitor.

  6. Go to Edit > Options and fill out a path for the log file (optional) and the path of the folder where NLS is installed.


  7. Proceed with the configuration under NLS Service in System Setup to set up your accrual automation.

Automated Accruals

In Setup > System > NLS Service, click Add Add to add a new scheduled process. In the configuration window, enter the appropriate database connection information and desired time of execution.


Parameters
/X = Y or /X = N Close program when accrual is done—if not defined, /X = Y is assumed.
/A = date The date to accrue through—the date format is mm/dd/yyyy.
/Y Use yesterday’s date.
/W Accrue through weekend.

Note

Use of this parameter could cause the loan to accrue into the future. Transactions may not be performed on loans with future Accrued Thru Dates until that date has been reached. Therefore, use caution when employing this parameter.

/H = US

Accrue through holiday; supports US Federal Holidays.

Note

Use of this parameter could cause the loan to accrue into the future. Transactions may not be performed on loans with future Accrued Thru Dates until that date has been reached. Therefore, use caution when employing this parameter.
/G = loan group number5.16+
The loan group number. Multiple group numbers may be specified separated with a comma.
/Z = state5.16+
2-letter US state or Canadian province code.
/L = acctrefno5.16+
 
/I = CPU check interval5.20+
The interval between CPU load checks in seconds. To disable CPU load checks, set to 0. This parameter is optional and must be set in conjunction with /J or /K.
/J = minimum CPU load5.20+
An integer representing the minimum CPU load that must be attained before additional thread for accrual is added to the process. Up to 150% of the specified maximum thread count is added. This parameter is optional and must be set in conjunction with /I.
/K = maximum CPU load5.20+
An integer representing the maximum CPU load that must be attained before a thread for accrual is removed from the process. Thread count is reduced to no less than 50% of the specified maximum thread count. This parameter is optional and must be set in conjunction with /I.

Note

/A and /Y are mutually exclusive, and if neither is used, the current system date will be assumed.

Automated Report Generation

To automate the generation of reports in NLS through the NLS service, first follow the steps above to make sure that the NLS Service is enabled. Then create a Stored Parameter for the report that you want to schedule. See section on Reports for more information.

Right-click on the Stored Parameter and select Schedule In Service. Fill in the parameters to schedule your report and click OK.

NLS 5.23 and LaterNLS 5.22 and Before

Send Output To Printer Generated reports are output to the default printer.
Save Report to NLS Generated reports are saved under the stored parameter.
Send Report to E-mail5.20+

Generated reports are emailed to the specified email address using the default outgoing email server. Multiple email addresses may be entered separated by a semi-colon “;”.
The email will be sent at the scheduled time the report generation service is executed. The Time to Send parameter specified for the email server in Communication setup is not observed when sending email through NLS Service.
Errors and logs of emailed reports are handled by the email server.

Note

Check with your organization’s policy on emailing reports as some reports may contain confidential information.
Save Report to a Physical Location

Generated reports are saved to the specified path. Specify the full path including the filename in the field provided. Existing file with the same filename will be overwritten.

Specify the full path including the filename in the Filename Parameters field.5.23+

The file name may be formed from the following variables:

%m = Month as a decimal number (01-12)

%d = Day of month as a decimal number (01-31)

%y = Year without century as a decimal number (00-99)

%Y = Year in four digit format (yyyy)

%H = Hour in 24-hour format (00-23)

%I = Hour in 12-hour format (01-12)

%M = Minute as decimal number (00-59)

%S = Second as decimal number (00-59)

Save Report via SFTP5.14+

Generated reports are transmitted to the selected SFTP server. SFTP servers are configured in Setup > System > SFTP Settings.

By default the name of the report is used as the filename. A different filename may be specified in the Filename Parameters field. Only the filename is needed as the path specified in SFTP Settings is used.5.23+

The file name may be formed from the following variables:

%m = Month as a decimal number (01-12)

%d = Day of month as a decimal number (01-31)

%y = Year without century as a decimal number (00-99)

%Y = Year in four digit format (yyyy)

%H = Hour in 24-hour format (00-23)

%I = Hour in 12-hour format (01-12)

%M = Minute as decimal number (00-59)

%S = Second as decimal number (00-59)

Delete Old Saved Reports Saved reports in NLS matching the selected criteria are deleted.
Override Temp Directory5.21+
The specified directory is used to store temporary files during the service execution.

Any parameter that is date dependent (e.g. Starting Date, Ending Date) can be edited by clicking next to that parameter. The parameter can be set to be equal to the current date on which the report is being run, or can be set to a date relative to the date on which the report is being run.


Automated Statement Generation

Right click on a pre-defined statement code and select Schedule in Service. Fill in the parameters and select Send Output to Printer or Send to Document Queue and click OK.

Send Output to Printer and Send to Document Queue are mutually exclusive and only one can be selected.

Automated Campaign Updates

To automate the updating of Collection campaigns through the NLS service, first follow the steps above to make sure that the NLS Service is enabled. Then create a collection campaign that you wish to schedule.

Right-click on the campaign and select Schedule.

The scheduling parameters for the collection campaign are identical to those used for scheduling a report.

Automated ACH (NACHA) File Creation

To schedule the ACH processing (for ACH payments only—processing of vouchers to ACH is not automatable through the Service), Select ACH from the Target Type drop down list and configure the parameters as follows:

Parameter Notes
/H = company header ACH Company Header code number. Required
/A = ach company ACH Company code number. Optional
/G = loangroup(s) List of loan group numbers. Multiple loan groups should be separated with a comma. Optional
/M = +/- day Defines the date to run the ACH through, relative to the current system date. This date must be later than the date specified by /N. Optional
/N = +/- day5.16+
Defines the date from which to run the ACH, relative to the current system date. This date must be earlier than the date specified by /M. Optional
/L = acctrefno5.16+
Acctrefno of the loan for which to process the ACH. Optional
/Z = billing type5.16+

Valid values are: Optional
0 = All (default)
1 = Billing
2 = One Time
3 = Recurring

/F = filename

Location and name of the NACHA output file. Required

Note

This parameter is not supported on our Switch environment for ASP customers. The file can be retrieved via SFTP.

The file name may be formed from the following variables:

%m = Month as a decimal number (01-12)

%d = Day of month as a decimal number (01-31)

%y = Year without century as a decimal number (00-99)

%Y = Year in four digit format (yyyy)

%H = Hour in 24-hour format (00-23)

%I = Hour in 12-hour format (01-12)

%M = Minute as decimal number (00-59)

%S = Second as decimal number (00-59)

Example

For the command line:

/H=1 /M=+1 /F=c:\achfolder\A%m%d%y.txt

When the ACH executes automatically on November 6, 2013, the ACH Header with a code number of “1” will be used to create the header record in the NACHA file, the ACH will run for all payments with execute dates up to November 7th, and the NACHA file will be created in the C drive of the computer, in a folder called achfolder with a file name of A110613.txt.

Automated Credit Bureau Report Generation

To schedule the generation of a credit bureau Metro 2 file generation, select Credit Bureau Report from the Target Type drop down list and configure the parameters as follows:

Parameter Notes
/H = header ID Credit Bureau Header code. Required
/F = filename

Location and name of the output file. Required
The file name may be formed from the following variables:

%m = Month as a decimal number (01-12)

%d = Day of month as a decimal number (01-31)

%y = Year without century as a decimal number (00-99)

%Y = Year in four digit format (yyyy)

%H = Hour in 24-hour format (00-23)

%I = Hour in 12-hour format (01-12)

%M = Minute as decimal number (00-59)

%S = Second as decimal number (00-59)

/X5.16+
Sets the Total Past Due and Total Current Due values to zero. The loan’s account status must be CLOSED and the payoff/closed date must be before the Metro 2 generation date.

Processing Payment Cards

To schedule the processing of payment cards by loan groups, select Credit Card or Card from the Target Type drop down list and configure the parameters as follows:

Parameter Notes
/G = loangroup number List of loan groups. Multiple loan groups should be separated with a comma. Optional
/M = +/- day Set the Execute Date To +/- from system date. Optional

Interfacing with the General Ledger

NLS 5.15 and later

To interface the general ledger using an external DLL, select GL Interface Wrapper from the Target Type drop down list and configure the parameters as follows:

Parameter Notes
/L = location of DLL Path to the GL interface wrapper DLL.
/T = DB type MSSQL or Oracle.
/S = Server Name of the database server.
/D = Database Name of the database.
/U = Username Username to log into the database.
/P = Password Password for the username.
/A = Parameters Additional parameters to be passed to the DLL.

National Change of Address (NCOA)

NLS 5.19 and later

To schedule the transmission and fetching of data for NCOA processing, select NCOA from the Target Type drop down list and configure the parameters as follows:

/X or /x = Transmit Transmits the name and address of contacts in NLS that is not specifically excluded from NCOA processing.
Transmitting the list of contacts should be done no more than once per month.
/F or /f = Fetch Fetches the NCOA processing results.
Fetching of data may be performed daily.
NLS will process the fetched data and present it in Processing > NCOA.
/T or /t = DB Type MSSQL or Oracle.
/S or /s = Server Name of the database server.
/D or /d = Database Name of the database.
/U or /u = Username Username to log into the database.
/P or /p = Password Password for username.

Sonnet

Select Others for the Target Type and enter the full path to the NLSCreditDisputeProcessor.exe helper application. Enter the parameters for connecting to the database.

Switch Users

Select Sonnet as the Target Type.5.23+

NLS 5.26 and later

Select Sonnet as the Target Type.5.26+

Parameters

/T or /t = DB Type MSSQLSERVER or Oracle.
/S or /s = Server Name of the database server.
/D or /d = Database Name of the database.
/U or /u = Username Username to log into the database.
/P or /p = Password Password for username.

To configure NLS Service to use Windows Authentication in lieu of specifying the /u and /p parameters, open the Services app (enter Windows Services in the search field in the Task Bar to find the Services app). Right click on NLS Service Host in the list of running services. In the Log On tab, click This account and enter your Windows Authentication credentials. Click Apply to save the changes.

Archive

NLS 5.25 and later

To schedule the archiving of loans with the ARCHIVE status code, select Archive from the Target Type drop down list and configure the parameters as follows:

Parameter Notes
/R Maximum runtime in minutes. Required only if /E is not specified
/E End time in HHMM or HH:MM 24-hour format. Required only if /R is not specified
/A Archive server override. Optional
/B Archive database override. Optional
/X Max CPU use percentage (default is 80, range is 10 – 99). Optional
/Y Check CPU every Y minutes (default is 1, range is 0 – 60, use 0 to turn CPU monitor off). Optional
/N Include an “In Progress” log entry every N loans archived in the target database's ArchiveLog table. Set to 0 to disable logging. Setting this value to 100 or less may degrade performance. Optional

Bankruptcy

NLS 5.26 and later

To schedule the processes required for bankruptcies, select Bankruptcy Notifications or Bankruptcy Subscriptions from the Target Type drop down list.

Bankruptcy Notifications will execute NLSBKSubscriptions.exe to send a list of contacts in NLS to BankruptcyWatch.

Bankruptcy Subscriptions will execute NLSBKNotifications.exe to process the notifications from BankruptcyWatch and import the details into NLS.

SFTP RFP

NLS 5.26 and later

To schedule SFTP Listener for automated payments processing, select SFTP RFP from the Target Type drop down list and configure the parameters as follows:

/F Path to a local directory where the remote files are temporarily saved. Local copies are deleted after processing.
/R Remote directory.
/X Remote archive. Path to remote directory to where post processed files are moved. Optional.
/K Path to a local directory where the decrypted files are temporarily saved. Optional.
If undefined, /F will be used. Local copies are deleted after processing.
/A Use NLS ACH/AFT SFTP settings to connect. If defined, /I, /O, /N, or /C are not used. If the SFTP Name contains a space, use ID#.
/I SFTP host. /O, /N, and /C are required.
/O SFTP port number. /I, /N, and /C are required.
/N SFTP username. /I, /O, and /C are required.
/C SFTP password. /I, /O, and /N are required.
/H ACH/AFT header to use. If undefined, ACI reversals are performed.
/E Do not delete temporary local files after processing.

Other Targets

NLS Service can be configured to run an external application by setting the Target Type to Others and specifying the full path to the .exe file in the Target field. The values in the Parameter field will be passed to the external application.

NLS 5.25 and earlier

See Automated Payments Configuration for information on how to set up the SFTP Listener to automatically check for ACH/AFT return files.