Procare Solutions Internal Ideas Portal
Due to a fraud action by a customer using ACH via TE, we will need to have a weekly job ran that scrapes all ach transactions and looks for ach rejects with the following characteristics.
Rejects for: No Account, Invalid Account exceeding 35% of any batch total, more than once, in preceding 60 days.
Filters to add –
Same account key, multiple ach rejects for no account, invalid account
Same account key – multiple dda changes >2 changes same key
Multiple rejects all at max line item amount ie 2500
Rejects for: Stop Payment, Unauthorized or Authorization revoked (R10, R7, R8 etc) exceeding 25% of total ach transactions ran in preceding 60 days
The report should present the bam and what they flagged for so they can be reviewed for fraud.
Ability to adjust thresholds based on noise filtering would be good.
| Product Area | Payments |
| Are customers at risk of leaving Procare without this item? | No |
| Are customers going to competitors for this item? | No |
|
How does this impact the customer's business?
Impact is TE Revenue and loss prevention |
|
as long as the above filters and queries are ran Im ok with whoever can run this on a weekly job for me
The queries previously run to assist with this issue when it first arose are available for anyone with access to run in the short term. Meagan has access to be able to run these and we can provide the SQL to assist. Long term I am working with Jerry to restart the Aperia project to bring that data into aperia. If the Aperia project does not become fruitful we will look into prioritizing this one into Procare