Skip to Content
0
Former Member
Feb 09, 2009 at 07:31 PM

how to determine if a document was duplicated

262 Views

Hi everyone

I recieved a support call from one of our customers they claimed that there was some kind of error after the system hanged for 20 mins (reasons unknown so far),after SBO was responsive again, they noticed a duplicated document (A/R Invoice) but with different document number,i.e docnum=1000 and 1001, the same rows, same amounts,costumer, etc...

I decided to run a simple query to determine wheter it was in fact a system error or maybe the user clicked twice while the system was iresponsive triggering a second transaction to be posted.

"select T0.docnum,T0.doctime from oinv T0 where T0.DocNum = 'somedocnum' or T0.docnum='Nextdocnum')" .

Unfortunately the returned information is not very precise since it only shows the min it was created and i was expecting a second o millisecond kind of data but it showed that the documents where created at the same time (minute).

I would like to know if there is another way (more accurate) to determine what happened? before i present the issue to support desk,any idea or suggestion is highly appreciated.

Info:

SBO 2007A pl 15 (migrating soon to highest patch)

Windows 2003 Server R2 Enterprise Edition

Thanx in advance

Aley