Error retrieving and displaying receipt information

Description of Issue
  • Error retrieving and displaying receipt information. -284 in Receipts, Receipt Inquiry, or Payment Entry. 
  • ERROR EXECUTING THE SQL STATEMENT selectReceiptIdForReceiptNaturalKey in System Log from Receipts, Receipt Inquiry, or Payment Entry.
Context
  • Accounts Receivable
  • Receipts (arrecinq) 
  • Receipt Inquiry (arrecinq)
  • Payment Entry (arbilinq)
Cause

There are potentially multiple causes for this error. A known cause is that there are two receipts in the system that share the same bill number and receipt number. This is an unexpected data condition. 

Resolution
  1. If encountering this error in Receipts, Receipt Inquiry, or Payment Entry, the first step is to gather more information from the System Log. Use the System log Id provided by the error to find the System Log entry using these steps: Search error by Log Id in System Log
  2. If the Message in the System Log export reads ERROR EXECUTING THE SQL STATEMENT selectReceiptIdForReceiptNaturalKey, please contact Support. This indicates that there are two receipts with the same bill number and receipt number. This unexpected data condition must be resolved by Support. 
    1. For guidance on which Support Team to contact, please see: How to determine the correct Accounts Receivable support team to assist with an issue
  3. After resolving this data condition, please verify that a setting did not cause this issue: Receipt numbers duplicating
Additional Information

Additional resources for working in Payment Entry can be found here: Master Article - Payment Entry