Setting up a Data Exchange Definition two transformation rules do not seem to work.
Initially I want to remove - from the Bank Account Sort Code for example 20-55-77 should be set to 205577. Please can someone review the setup and give any suggestions to correct it.
When I do a Test on the transformation rule it works correctly..
Secondly I want to format the amount so for example £548.25 would read 00000054825. How can I achieve this because again I have a transformation rule to remove . and on the Column layouts selected to Pad with 0 Justified Left but none of this happens when exporting the payment file.
This is on Business Central 16.2.