Publicado Fri, 17 Jul 2020 20:11:27 GMT por Edward Clarke Community Service Partners Director of Information Technology
I have created a file cabinet and I want to know if I can make the "Vendor" and "Invoice #" unique together.  Example, company "ABC" has an invoice "123" and I want to make sure that invoice number can't be used again for that vendor.  But if company was "DEF" and invoice number "123" that can be entered as it is different by vendor name.

I am on DocuWare 7.2.
Publicado Tue, 21 Jul 2020 08:07:03 GMT por Simon H. Hellmann Toshiba TGIS GmbH | IT-Consultant - Document Management Solutions
Hi Edward, 

this is not possible with unique fields. However, you could put all the stored vendor documents into a workflow. The workflow can then check if this specific combination of index fields already exists in the database.
If it does, the status could be changed to "duplicate" or something like this so you can easily search for this or display them in a task list to review. 

Hope this helps. 

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

You must be signed in to post in this forum.