[Jeff Woodard]

Up

0

Down

::

Looks like the same issue we encountered when we went live in January. Here’s what i documented at the time.

The problem was that any amount numbers were not formatting correctly in the file – numbers with trailing zeros had the zeroes truncated, and numbers with non-zero trailing numbers were not using the correct number of spaces in the file.

i.e.

BC Value Expected File Value Actual File value

$750.00 xxxxx75000 xxxxxxx750

$694.36 xxxxx69436 xxxx69436

I found these articles:

EFT/ACH – Payment Amount shows 0 issue, Data Exchange Definition needs correction

Solved: Data Exchange Definition – Dropping Zeros in Footer Total

The solution seems to be to change the ‘Multiplier’ field on the field mapping table from 1 to 100 (despite the article above indicating to change from 100 to 1.