An exception has occurred within MiscellaneousPaymentInterface

• Receiving the error An exception has occurred within MiscellaneousPaymentInterface.displayMiscellaneousPaymentInterface(). Additional information concerning a status error of -268 [-2601]: [Miscrosoft][SQL Server Native Client 11.0][SQL Server] Cannot insert duplicate key row in object 'AccountsReceivable.Bills' with unique index 'IX_Bills.HasBalanceDue.VoidedVersion.Category.Year.Number'. The duplicate key value is (X, X, 2, YYYY, XXXXXX). System log Id: XXXXXX when entering a Miscellaneous Receipt.
• Cannot insert duplicate key row in object 'AccountsReceivable.Bills' with unique index 'IX_Bills.HasBalanceDue.VoidedVersion.Category.Year.Number'. error in Payment Entry.

• Accounts Receivable
• General Billing
• Payment Entry (arbilinq)
• Miscellaneous Receipts

A series of actions or settings is causing the program to attempt to create a receipt with the same Year, Category, and Number combination which is not allowed. Known issues that cause this error include: 

• The Dept Specific settings in the Accounts Receivable Settings program contain receipt ranges for different departments that overlap. 

1. Verify if receipt ranges are setup for different departments in the Accounts Receivable Settings program. If they are, verify that the established ranges do not overlap. 
2. To do this, navigate to the Accounts Receivable Settings program either by searching or via the following path: General or Property Revenues > Accounts Receivable > Setup > Accounts Receivable Settings
3. Select Dept Specific from the ribbon.
4. If there is more than one Department listed, then make sure that there is no overlap between the Start Receipt and End Receipt ranges. 
   1. For example, if All Other Departments have a Start Receipt and End Receipt range of 1-999999999 and a specific department, like Treasurers, has a Start Receipt and End Receipt range of 1-999999999, then there is overlap and programs may try to create duplicate receipts. 
   2. Non-overlapping ranges for these departments would be 1-500000000 and 500000001-999999999.
5. To update the ranges, click into the Start Receipt field for the department. 
6. Enter the desired Start Receipt for the department. 
7. TAB to the End Receipt field. 
8. Enter the desired End Receipt for the department. 
9. TAB to the Next Receipt field. 
10. Enter the desired Next Receipt. (Note: The Next Receipt value must fall within the defined Start-End Receipt range.)
11. Repeat steps 5-10 for each department as necessary. 
12. Click Accept to finalize the changes. 
13. Have all users close and re-open Payment Entry before attempting to enter Miscellaneous Receipts again. The error should clear. 

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