Unhandled script exception “Value of range” error when Running Receivables Reconciliation

When attempting to run the sales reconciliation; specifically for the “Current Customer Information”
an unhandled script exception [Value of Range]
Exception_Class_Script_Out_of_Range_Script_CMD_Selected.

As you proceed, when pressing the “Process”, you will get the error stated below:

Resolution
This is most likely caused by a missing statement cycle definition on the customer card, as shown below:

• Go to Cards > Sales > Customer
• On the customer card , press on the options button
• On the customer option window, check the “Statement Cycle”. If it is empty, choose one of the predefined options (monthly, weekly …etc)
  

For a mass update, you can consider the update of this option on the SQL level by running a simple update statement

To identify the customers with no statement cycle definition, run the script below:

SELECT  STMTCYCL AS StatementCycle ,
        CUSTNMBR
FROM    dbo.RM00101
WHERE   STMTCYCL = 0

UPDATE  dbo.RM00101
SET     STMTCYCL = StatementCycleValue
WHERE   CUSTCLAS IN ( )