CAS extract AR_PAYMENTS_INTERFACE_ALL - TRACE online banking payments to BCROS instead of BCOL

[pstemkens]

CAS will provide us with an extract of AR_PAYMENTS_INTERFACE_ALL where STATUS = AR_PLB_BAD_CUST_NUM order by creation_date desc;

AR BAD CUSTOMER

this list will need to be reviewed to determine next steps.

Scenarios:

• [ ] Wrong CFS account number that doesn't exist
• [ ] Wrong CFS account number that exists
• [ ] Wrong Payee

Link to extract below:

https://docs.google.com/spreadsheets/d/1e-4gEx8soSRSb9N-n4x6ZxxWTGNvwuWo/edit#gid=1768011072

AR_BAD_CUSTOMER - CAS needs to provide us with direct access to this table so we can monitor.

70 transactions Date range - Sept 28, 2021 - June 5, 2024 $6,141.60 dollar value

[pstemkens]

Tara from CAS advised she will set up a calendar reminder to run this every Monday, if there are no new records, she will not email, this is a temporary solution. Once provides us with direct access to this table, we can work to create procedures for managing items on it.

[seeker25]

Putting onhold, waiting for Tara

[seeker25]

Moving this out of the sprint, @pstemkens isn't around to action it