anyone created a saved search/alert to detect a transaction with the exact same $ amount and/or PO as an already entered transaction?

I would be more tempted to throw a script on the transaction to identify that. Fix it as it occurs

that would be great too

You could probably create a search that groups on the amount and the PO#-field and then have a count internalid on how many transactions for each group. Then add a summary criteria that says that count of internalid should be larger then 1. Schedule this search once a day and get a list of all potential duplicates.

That works for PO# - amount is where you have an issue.

Hmm, doesn't like to group on a currency field?

Right

Perhaps to_char() it and group it as a formula (text)?

i can’t get the saved search “email alerts when records are created/updated” to fire. i have plenty of times previously. any ideas?

Can't do it.

hmm yeah weird i’ve got plenty of duplicates but no firing