Hi all,
Hoping you can help me here, I'm no expert in excel.
I have a query of about 16,000 invoices based on what I consider possibly important..
-Date
-Invoice Number
-Amount
-Vendor
-GL acct
The problem is A/P clerks will sometimes add a letter to the invoice to bypass the internal control (won't allow you to enter duplicate invoices), so there may be an invoice #240 and #240a and they both end up getting paid but really it's only 1 invoice. What would you suggest in order to find these?
Thanks for any input!
Bookmarks