Transformation Rule to convert a positive number to its negative equivalent

(0) Share

Report

Posted on by Nick Webb

891

I'm trying to import a bank statement file into BC and I want to convert one of the amount columns to its negative equivalent (e.g.) 569.96 to -569.96 ? In .NET I would multiply the value by -1, but how would one do this during a bank statement import. It looks to me like Transformation Rule in Field Mapping in Data Exchange Definitions might be a way. I tried to create a new Transformation Rule, but where do specify Value * -1 ?

Can this be done? If yes, how? Thanks in advance for your help.

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

JAngle 133 on at

Like (0)

Report

A custom transformation rule would be a quick win. Here is how: https://youtu.be/L2qt0GKmiGk

Was this reply helpful? Yes No
Verified answer

Nick Webb 891 on at

Like (0)

Report

Thanks for your help. That worked nicely.

Was this reply helpful? Yes No