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.

Categories:

Reports and Business Intelligence

Purchasing

Sales

Financial Management

All responses (5)

Answers (1)

Dallefeld 11,417 on at

Like (1)

Report

RE: Decimal value formatting for payment export

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.
Suggested answer

James De Filippo 80 on at

Like (0)

Report

RE: Decimal value formatting for payment export

Hi Dirik,

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

Thank You!
Verified answer

Dirk on at

Like (0)

Report

RE: Decimal value formatting for payment export

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>
James De Filippo 80 on at

Like (0)

Report

RE: Decimal value formatting for payment export

Hi Inge,

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

Edit: Noticed <Decimal> should be <Decimals>...however doesn't resolve the issue.
Inge M. Bruvik 32,718 Moderator on at

Like (0)

Report

RE: Decimal value formatting for payment export

You have to add a data format to your colum:

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