Advice on quick way of finding suppliers with Bank Account sort codes and Account Nmmbers on a payme
Hi
Periodically we have a payment file that has completed with an error due to a supplier on it having been entered on the TCA with a dogy account number, sort code number or Account name. Often with trialing spaces, under lines and odd characters. This is caused I beleiive by our supplier file team sometimes cutting and pasting details when they create a supplier.
The problem we have is identifying which supplier is to balme to be able to take it out of the batch before re-running the batch with the correct supplier details in. Can you provide with a way we can idetify this rouge suppliers on a payment batch easily? Is there are piece of SQL I can rum or a diagnostic report as looking at the request ID log file of the failed batch doesn't does me underlines or trailing spaces and acute accents etc. which could be causing the payment file to fail