Invoice Entry and Proof Error Creating Bill

Error posting Invoices

Invoice Entry and Proof Error

Error creating bill. Additional information concerning a status error of -268 [-2601] SQL Server Native Client 11.0. Cannot insert duplicate key row in object 'dbo.arbilhdr' with unique index 'arbilhdr1'. The duplicate key value is. 

Error executing insert_arbilhdr

• Munis

• v11

• General Billing

• Invoice Entry and Proof

• Posting

In this scenario a user might hit an error during Invoice posting for Invoice Entry and Proof. This error with the main duplication exception stating: Error creating bill. Additional information concerning a status error of -268 [-2601] SQL Server Native Client 11.0. Cannot insert duplicate key row in object 'dbo.arbilhdr' with unique index 'arbilhdr1'. The duplicate key value is (The duplicate values will be listed here). This can happen when the initial posting was aborted, the program or web page was closed out prematurely before the posting routine could finish or miscommunication between Munis and the SQL Server Database. This creates a partial posting and Munis has trouble rolling back the partial posting creating the duplication issue. 

Please submit a case with Munis Support with Batch information and screen shots if possible.