Data Exchange Transformation Rule

TESDeveloper
TESDeveloper Member Posts: 42
in NAV Three Tier
Hello All,

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.

8hqm78iqu3e7.png

v9h4jdpzy3mw.png

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.

Categories