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.
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 195-203 of the lockbox file when payments are processed 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