Error retrieving and displaying receipt information
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
- 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
- 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.
- For guidance on which Support Team to contact, please see: How to determine the correct Accounts Receivable support team to assist with an issue
- 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
Looking for labels? They can now be found in the details panel on the floating action bar.
Related content
Error selecting receipt number for the transaction XXXX 100 in Void Transactions
Error selecting receipt number for the transaction XXXX 100 in Void Transactions
More like this
Posted receipt has no tender
Posted receipt has no tender
More like this
Receipt numbers duplicating
Receipt numbers duplicating
More like this
Payment ID does not match Receipt Number in Receipt inquiry
Payment ID does not match Receipt Number in Receipt inquiry
More like this
Receipts missing from Excel export
Receipts missing from Excel export
More like this
Error executing SQL cursor selectTenderForExport When Exporting Receipts to Excel
Error executing SQL cursor selectTenderForExport When Exporting Receipts to Excel
More like this