TPAR INSERT Statement Error Processing a $0 Registration

Owned by Knowledge Assistant
Dec 09, 2024
1 min read
Description of Issue

When processing a Class, Membership, or Rental Item that is set to $0 in the citizen portal, an error message displays and the registration does not go through. Checking Administration > System Setup > System Log, the error message reads:

System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PaymentLines_CAS_PAYMENT_METHOD". The conflict occurred in database "parksrecprod", table "dbo.CAS_PAYMENT_METHOD", column 'CAS_PAYMENT_METHOD_ID'.  The statement has been terminated.

Context

  • TPAR

  • Parks & Rec

  • Tyler Parks and Recreation

Cause

The Portal Cart Fee is missing allowed payment method information. Despite the registration itself being $0, the added Cart Fee, even if this calculates to also be $0, needs tender information specified before it will process correctly. 

Resolution

  1. Go to Administration > Cashier Setup > Fees. 

  2. Edit the Portal Cart Fee. 

  3. In the Modules tab, add all options. 

  4. In the GL Accounts tab, add Account Credit and Online Payments (or Credit Card), and specify appropriate debit and credit account. 

  5. Save. 

Additional Information