Dynamics Business Central (NAV)
Experts:
Data Exchange Definition problem with decimals
-
Data Exchange Definition problem with decimals
We are trying to use this to export an ACH, but when there is a trailing zero in the amount, the line gets truncated. We have found that the “Data Format” field is completely ignored for decimal fields by codeunit 10331. The decimal field gets formatted as “Format(Decimal,0,1)”, padded to length and THEN the decimal point is removed, leaving it short. We can’t believe this has been in use for several years, there has to be a solution?
-
4 Replies
-
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.
-
This won’t work because there is no multiplier field in Business Central. Microsoft support says “this will require a customization” and “put this in the product improvement idea forum”. To make the product work the way it is supposed to! To make this worse, there is NO EVENT in the codeunits involved that allows you to address the data.
Log in to reply.
