Publicado Mon, 30 Sep 2019 19:03:16 GMT por John DeLaat
I have a customer running 6.7 on premise and would like to alert a user when storing an invoice if the vendor/invoice number combination already exists in the file cabinet.  Is there an easy way to do this?
Publicado Tue, 01 Oct 2019 14:24:29 GMT por Matthew Trembly Software Support Manager
Do you want to alert them right from the file cabinet store dialog during the storage event or just if there's a duplicate vendor/invoice combo in the file cabinet?
Publicado Tue, 01 Oct 2019 14:30:31 GMT por John DeLaat
If possible would like to do at storage.  If not, then checking for duplicate.
Publicado Tue, 01 Oct 2019 23:12:18 GMT por Matthew Trembly Software Support Manager
You need a validation that sends the index field entries from the file cabinet store dialog to a REST service.  If your ASP.NET is rusty, take a look at StapleWare's Double Check module.  You can pretty much set up exactly this scenario out of the box in minutes:

https://www.jhoe.com/products/page.php?pageID=13

Does this system have AIX and Task Manager modules?  If so, it's pretty straightforward to check for duplicates in the file cabinet.
Publicado Wed, 02 Oct 2019 17:17:40 GMT por John DeLaat
Thanks for the StapleWare link.  They do have both AIX and Task Manager modules, how would we go about using that path.
Publicado Thu, 03 Oct 2019 21:53:49 GMT por Matthew Trembly Software Support Manager
brb
Publicado Tue, 08 Oct 2019 00:48:49 GMT por Matthew Trembly Software Support Manager
The simplest way is to just use AIX with a compound matchcode to return duplicates.  First, create a file cabinet field that will be used to flag duplicates.  Configure AIX to search the file cabinet for any documents with the same Vendor AND Invoice.  For all results, assign a fixed value to this flag field for duplicates.  Create a file cabinet list to display all records for which the flag field for duplicates is set.

See pics ... 
Publicado Tue, 08 Oct 2019 01:02:05 GMT por Craig Heintz GSME
The simplest way I have found is to upgrade to 7.1, do a workflow to compare the invoice # and date to the cabinet, if it matches set a field to Possible Match, if it does not match, set the field to no match.  Then have two processes for the Match an no match outputs.

This is near real time and will catch the documents that match right away and prevent them from moving forward in an approval process.
Possible duplicates can be assessed and either marked for deletion or marked as not duplicate and on to the approval process.
 
Publicado Tue, 08 Oct 2019 12:05:38 GMT por John DeLaat
Thanks for all your help!!
Publicado Tue, 08 Oct 2019 13:35:45 GMT por Matthew Trembly Software Support Manager

Workflow is elite, for sure, but I don't know if that's an option.  Does this system have a workflow license, John?

Publicado Tue, 08 Oct 2019 13:48:38 GMT por John DeLaat

No, they do not.

You must be signed in to post in this forum.