ERROR WITH THE SQL STATEMENT getCategorySpecificSettings in AR Payment Plans

Description of Issue

An unexpected error occurred calculating payment plan schedule, unable to display schedule

ERROR WITH THE SQL STATEMENT getCategorySpecificSettings

Context
  • Accounts Receivable Settings
  • Payment Plans
  • Enterprise ERP
Cause

Category 45 - PAYMENT PLAN has not been added under Category Specific Settings in Accounts Receivable Settings

Resolution

From the Tyler Menu > General Revenues or Property Revenues > Accounts Receivable > Setup > Accounts Receivable Settings

  1. Click the Cat Specific button in the toolbar
  2. Click Add
  3. Select 45 - PAYMENT PLAN from the AR Category dropdown
  4. Check under the Forms, Payments, Audit, Reversals, and Refunds tabs and complete any required fields
  5. Click Accept