Identify Duplicate Invoice Payments

[SloppyJoe]

Hi folks,

I am trying to create a spreadsheet that will help identify duplicate invoice payments made to our ERP system on a daily basis. I would like one tab to have all the data loaded from the current fiscal year, and then a daily import of the previous days invoice payments. I would then like to match the previous days payments up with anything that's already loaded with the same vendor, invoice number and amount. Is there a way that after the daily import and you review to see if there are duplicates or not, the data would then automatically go to the tab with the master data so everyday you start with a "fresh" page?

I have attached what I have started...thanks

[queuesef]

Depending on your ERP software, many programs alert you or will NOT allow you to have duplicate check numbers for payment to the same vendor. Also, many softwares (I cant speak for yours as you didn't mention what it is) allow you to see the Payments (with check #)....we typically can look at that before applying payment, BUT again it is generally not needed as our program will REJECT duplicate check numbers. What software are you using?

[Logit]

.
Paste in Regular Module; place commandbutton on sheet attached to this macro :

Please Login or Register  to view this content.