This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hello - I'm trying out an audit use case to identify potential duplicate paid invoices. The pattern I'm looking for would be the same vendor name, same gross amount, similar invoice #. Specifically with the invoice number, I sometimes see invoice numbers adjusted with 'A', 'B', or '-1' entered at the end of the invoice. Thus invoice # 1234 would also show as 1234A or 1234-1. My initial thought was to try and verify that for any vendor and gross amounts that match, compare the invoice number with "contains", thus 1234 is contained within 1234A and 1234-1.
I am trying the WildCard Join macro available within the Community, but what I'm finding is that pushing a lot of data through that is quite time consuming for the workflow.
I just built this batch macro this morning that will do the append but on a row my row basis (therefore becoming more performant ;)). This might help you or at the least give you an idea of how to approach. The main idea here is to join the same table to each other and match based on your needs.
Pretty slick, thank you so much! I've been a little shy to take on Reg Ex. Looks like it identifies as a duplicate even if I put A in front of the invoice number. Any recommendations on sites for learning more about the Reg Ex syntax and formulas?