cash receipt duplicate check number econnect issue

I am trying to a scribe job that inserting 2 different document numbers in the cash receipts table.  Each document has the same check number.  In this use case we have a document in open table that has check number 02058843.  We then have a document that is being inserted by scribe also with check number 02058843.  The first document is being inserted with check number 02058843-001 and the second document should be inserted with check number 02058843-002.  The -001 and -002 are being insert that the stored procedure (taRMCashReceiptInsert) has been changed to do a search on the max number and add - and a number.  

 

It appears there is something in scribe which doing the duplicate check number check and only against documents in the work table.

 

The first document with check number 02058843-001 goes in without any issues.

Login