Page Comparison

Import file is missing the information needed to locate a bill  to pay. This error is most likely caused by the Customer ID not being populated in  

The import file needs to contain either the category, bill number and year OR have the account number and CID populated in positions 74-82 and positions 195-203 in of the lockbox file which is required if processing when payments are processed by Account/CID

To verify Process by setup use the following steps

1. Property Revenues > Utility Billing > Setup > Settings > Site Options 1 Tab 
2. Process by with either indicate Account or Account/CID
   1. If this setting is set to Account/CID, the Process Lockbox File program defined using the file format Property Payment Record HAS Record HAS to have the Customer ID populated in positions 74-82 and 195-203 in the lockbox file
   2. If this setting is set to Account, the Process Lockbox File program defined using the file format Property Payment Record does Record does NOT have to have the Customer ID populated in positions 74-82 and 195-203 in the lockbox file
3. If processing by Account/CID the import file will need to be updated to include the CID information in the fields listed above.