Is there a way to delete space prefix/unwanted character from transaction number in Receivables?

Summary:

A way to delete unwanted characters from transaction number for completed and accounted transaction

Content (please ensure you mask any confidential information):

We have a number of transactions created with space as prefix and it is impacting reporting in OAC

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):