Description of Issue
'Error locating bill to obtain Prop/CID information' when processing my lockbox file
Context
UB Classic
UBCIS
Munis
Process Lockbox File
Cause
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 74-82 and positions 195-203 in the lockbox file which is required if processing by Account/CID
Resolution
To verify Process by setup use the following steps
- Property Revenues > Utility Billing > Setup > Settings > Site Options 1 Tab
- Process by with either indicate Account or Account/CID
- If this setting is set to Account/CID, the Process Lockbox File program defined using the file format Property Payment Record HAS to have the Customer ID populated in positions 74-82 and 195-203 in the lockbox file
- If this setting is set to Account, the Process Lockbox File program defined using the file format Property Payment Record does NOT have to have the Customer ID populated in positions 74-82 and 195-203 in the lockbox file
- If processing by Account/CID the import file will need to be updated to include the CID information in the fields listed above.
Additional Information
Add Comment