Article Details
Id:17723
Product:finPOWER Connect
Type:FIX
Version:3.03.05
Opened:21/12/2020
Closed:24/12/2020
Released:25/02/2021
Job: J025713

Sample Account Processes "Account History Rating Update" script; fails if Client Group or Client Type range specified

The sample Account Processes "Account History Rating Update" script fails if a Client Group or Client Type range specified.

The error is "Failed to run Account Processes. Failed to run script 'AP.HISTRAT'. Failed to open DataReader. Failed to open DataTable. No value given for one or more required parameters.".

Note, this occurs because the "Client" table is not joined into the SQL query.

The following sample script has been updated:

  • AP.HISTRAT
    • Script_AccountProcesses_AccountHistoryRatingUpdate.xml
    • Version 1.06 (24/12/2020)