Create Accounts Receivable fails with insertBillLine error

Owned by Knowledge Assistant
Last updated: Dec 05, 2024
1 min read
Description of Issue

Montgomery County, MD specific Create Accounts Receivable program fails with an error trying to assign Special Area Homestead Credits.

  • An error occurred while executing the SQL statement insertBillLine.

  • Cannot insert duplicate key row in object AccountsReceivable.BillLines with unique index UQ_AccountsReceivable.BillLines.BillId.Sequence.INC. The duplicate key value is.

Context

  • MD Property Tax Billing

  • Accounts Receivable

  • Create Accounts Receivable

  • Generate Accounts Receivable

  • Montgomery County, MD

Cause

Resolution

This has been resolved in 2024.2 and above. Install the latest Tyler Deploy release for your current Enterprise ERP version.

Additional Information