How to remove negative symbol #SQL Data Mapping of Amount as Text Field

Summary:

In some instances, the Entered currency is auto-matching while the CCY2 amounts are not matching, causing unexplained differences in the reconciliations. We bring the CCY2 Functional currency amount into TM as a text field and use a custom solution to load the unmatched transactions as Balance Explanations in the CCY2 amount field.

For auto-match, we want to require a text match of CCY2, as well as the amount match on Entered currency. To do this we want to get an absolute value of CCY2 (in UD11) by copying it to UD3 and removing the "-" on the negative amounts.