Unreconciled Tyler Payments in Enterprise ERP

Owned by Knowledge Assistant
Nov 22, 2024
Description of Issue

A transaction that should have been sent to Enterprise ERP is showing as Unreconciled.

Context
  • Tyler Payments
  • Enterprise ERP 
  • Accounts Receivable
  • Payment Entry (arbilinq) 
  • Unreconciled Transactions 
Cause

There are a multitude of possible and known causes for this issue. Known causes include: 

  • Tyler Payments could not connect to the External/Billing System.
  • The payment batch in Enterprise ERP is locked because a user is currently accessing it. 
  • The payment batch in Enterprise ERP has been released and is no longer in life cycle step 10. 
  • The payment could not be processed in Enterprise ERP due to an error. 
Resolution
  1. Troubleshooting an Unreconciled Transaction should begin in Tyler Payments by following the steps outlined here: Unreconciled Transaction Unable to Connect to Billing System
  2. If all all Tyler Payments in a batch are going unreconciled, then please follow the steps outlined here: All Payments Going to Unreconciled Transaction List
  3. If working through the above resources do not resolve the issue, navigate to the System Log program either by searching or via the following path: System Administration > General Administration > System Log
  4. Click Search. 
  5. Enter the Date the transaction was processed in Tyler Payments. 
  6. Enter *ARWST* (asterisks are used on either side of this search term to make it wildcard) in the Program ID field. 
  7. Click Accept. 
  8. Review the Message. 
  9. If the Message is unclear, please contact the appropriate Accounts Receivable Support Team for further review: How to determine the correct Accounts Receivable support team to assist with an issue

Development is currently aware of issues that cause Category 2 - Miscellaneous Receipts to fail occasionally for Community Development Payments processed through Resident Access. These transactions will show as Unreconciled in Tyler Payments. In Enterprise ERP, the receipt is missing GL Allocation and remains at Life Cycle Step 10 - In Proof/Initial. The receipt in Enterprise ERP will need to be voided manually in Payment Entry by selecting Cancel Transaction due to the missing GL Allocation and should be manually entered until the cause of this issue is determined or resolved: How to Manually Enter a Record for an Unreconciled Transaction in Payments

Please contact Enterprise ERP General Billing Support for additional updates on this specific issue. 

Additional Information

All Tyler Payment specific resources for Unreconciled Transactions can be found here: Master Article - Payments Unreconciled Transactions