Mapping Payment Format - Replace decimal with comma — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Mapping Payment Format - Replace decimal with comma

edited Aug 8, 2025 12:40AM in Payables, Payments & Cash Management 1 comment

Summary:

Mapping Payment Format - Replace decimal point with comma

Content (please ensure you mask any confidential information):

EText RTF Template - Fixed position template

I need to replace the decimal point with comma. The length of the field should be 17 with addition of zeros with LPAD.

Expected Results -

123 should be 00000000000123,00

123.45 should be 00000000000123,45

123.4544 should be 00000000000123,45

My configuration -

<Position> <Length> <Format> <Pad> <Data>

15 17 Number, ###.00 L, '0' TotalPaymentAmount/Value

Sample XML -

<InstructionTotals>
<PaymentCount>1</PaymentCount>
<TotalPaymentAmount>
<Value>100567</Value>
<Currency>
<Code>USD</Code>
</Currency>
</TotalPaymentAmount>
</InstructionTotals>

With no formatting for comma I get result from above as 00000000100567.00

For comma formatting I added this at Format Setup at command tables -

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!