Error_Customers_with_an_invalid_transaction_date

Error: Customers with an invalid transaction date

Issue

A customer has a transaction with a transaction date that occurs prior to the customer's connect date or after the customer's final bill date. 


Explanation

Connect uses the customer's connect date and final bill date as the valid date range for creating transactions for the customer. The customer should not have any transactions that occur outside the valid date range. 


Solution

You can fix this error by running Recalculate.  

1. Open Connect Utility Management > Organization > Recalculate. 

2. Click to select Correct Invalid Transaction Dates checkbox.  

3. Click GO (CTRL+G). 

 

 

202305 2023Mar27

 

 

Copyright © 2025 Caselle, Incorporated. All rights reserved.

    • Related Articles

    • Error: Customers with transaction that have an invalid amount

      Issue A customer has a transaction record with an amount that has more than two decimal places (0.000000). Explanatio Some amounts come from certifications, deposit, or normal account transactions. The amount is calculated and rounded to the nearest ...

    • Error: Customers missing final disconnect date on a billing service

      Issue A final bill customer is missing the final disconnect date on a billing service that was disconnected with the final bill. Explanation A final bill customer should have a final disconnect date on each billing service that will not be billed ...

    • Error: Customers with transactions that have invalid rate

      Issue A customer has a transaction that uses a rate that doesn't belong to the service transaction. Explanation Only rates that are tied to a service can be used to create a service transaction. Solution You can fix this error by running Recalculate. ...

    • Error: Meter activity with invalid dates

      Issue A meter activity transaction has an invalid date. Explanation Meter activity with invalid dates can cause billing issues. An invalid date can occur when the period date and rotation period do not match the expected period date and rotation ...

    • Error: Customers with invalid final bill information

      Issue A final bill is recorded on a customer account, but the final bill includes a final bill date that falls outside of the period when the customer was active. Explanation The final bill date for a customer should occur after the most recent ...