Posted Fri, 10 Jan 2020 19:25:59 GMT by Steve Shriver Application Specialist
In the web client viewer at the bottom left corner of the document, there is a display of a file name and a date. I believe the file name is the original name of the file on disk when it was imported into a document tray and the date is the date it was imported into a tray. As opposed to the Stored Date, when the document was indexed and stored in a file cabinet.

Is this correct?

A user wishes to know how long a document has been in a tray before it was stored. If this is the "Tray Date", is it available somewhere to be queried? It is not listed as a system entry.

For auditing purposes in an invoice processing system, we are trying to get a more accurate idea of when a document actually enters the system as opposed to the Stored On Date. That is, a document could be scanned/imported to a document tray, but not indexed and stored for a month. This makes it appear that the invoice processing workflow is taking much longer, when in truth it is a user issue.

Any clues appreciated,
Posted Mon, 13 Jan 2020 16:42:16 GMT by Steve Shriver Application Specialist
After some more investigation I might want to revise this question.

I see in the Database that there is a DWSTOREDATETIME field for a document in the table of a document tray.

This same field is replicated in the table for the file cabinet and updated when the document is indexed and stored.

Is there a way I could find out the difference between these 2 dates? That way I could tell how long a document was in a tray before it was indexed and stored in the file cabinet.

Many thanks,

You must be signed in to post in this forum.