04-20-2020 09:25 AM
I am redesigning my duplicate invoice logic and running into a few road blocks. My first try, I created a unity LC using portfolio relationships for each keyword value like PO #, Invoice #, Vendor Name and Invoice Date. I did Invoice to invoice. I also did rules for each and on true would ask about the next value. During testing I found that it wasnt looking at the same document for these values but if these values existed on any document in onbase. I decided to try mapping all my values on 1 relationship but this doesnt work either. It keeps going false even though there is a doc with PO # and Invoice #. I need to be guided the right direction as I dont know what the common way to perform this. Our old setup uses folder types using invoice or PO# and this doesnt work hardly at all. Any advice would be appreciated.
04-20-2020 10:27 AM
You want to exclude primary, because you don't want it to ever match itself.
Invoice is tough: it would be interesting to see others opinion.
PO, Invoice and Vendor # is probably the safest way to go. Vendors may change names, and they may re-issue invoices with a credit or different invoice amount (net terms, etc). I have seen scenarios in which vendors may tag an 'a' or another value at the end of the invoice for the re-created invoice.
We had scenarios in which the invoice would come through the dropbox and the buyer spoke directly to the vendor and they emailed them the revised invoice.
I had always erred on the side of more human scrutiny just because of how unpredictable the vendors have been.
04-20-2020 10:39 AM
why not invoice amount? This seems to be a good indication of if this is a duplicate?
04-20-2020 10:45 AM
True. I guess it depend on what you are matching. I guess it would be based on what scenarios you see. I have seen enough occasions in which a vendor sends and invoice but forgets a discount or a contract cost. They will modify that invoice and re-issue. The invoice # and everything will be the same but the amount will differ.
04-20-2020 10:59 AM
great info and thank you sir
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.