Decimal value formatting for payment export

(0) Share

Report

Posted on by James De Filippo

Hi All,

Trying to solve an issue with a Payment Export file, where it is formatted as a decimal but outputs no decimal when there is a whole number.

Example: 100.00 is outputted as 100

Although this is being accepted by the bank it is showing as £1.00, once imported.

Another possibility is using the text padding, instead of decimals but i cant get this to work correctly.

Does anyone have any experience with this issue and can you show me the correct method to set this up in Data Exchange Definitions.

I have the same question (0)

All responses (5)

Answers (1)

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

You have to add a data format to your colum:

docs.microsoft.com/.../standard-numeric-format-strings

Was this reply helpful? Yes No
James De Filippo 90 on at

Like (0)

Report
Copy link

Link copied!

Hi Inge,

We do have that in place, but is it incorrect?

Edit: Noticed <Decimal> should be <Decimals>...however doesn't resolve the issue.

Was this reply helpful? Yes No
Verified answer

Dirk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Did you try with something similar to this:

<Precision,2><Sign,1><Filler Character, ><Integer,7><Filler Character, ><Decimals>

Found it for a different example:

The expected result is an amount with 11 digits, and "0" as filler in case the number is smaller than 11 digits.

How to achieve this result:

In the column definition of the Data Exchange Definition for field amount you should have the following values.

Data Type = Amount
Data Format = <Precision,2><Sign,1><Filler Character,0><Integer,7><Filler Character,0><Decimals>

With this data format, you get the following results when exporting the payment file:

The amount of 100,11 is converted into:
00000100,11

The amount of 100,00 is converted into:
00000100,00

If the filling zeros are not needed, it is also possible to change the data format to this:

<Precision,2><Sign,1><Filler Character, ><Integer,7><Filler Character, ><Decimals>

Was this reply helpful? Yes No
Suggested answer

James De Filippo 90 on at

Like (0)

Report
Copy link

Link copied!

Hi Dirik,

That's what i was missing! Now added the <Precision,2> to the data format!

Thank You!

Was this reply helpful? Yes No
Dallefeld 229 User Group Leader on at

Like (2)

Report
Copy link

Link copied!

In the field mapping for the amount field there is a 'multiplier field'. It which is hidden by default and is set to 1.00 by default. I needed 100 to show in the file as 10000 (no decimal in the file) and I was getting 100. By simply changing the multiplier to 100.00, the issue was solved. Not sure if it will work for you.

Was this reply helpful? Yes No