Process Lockbox File Error locating bill to obtain Prop CID information

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

  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 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 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.
Additional Information