Etext Outbound FORMAT_NUMBER("PaymentAmount/Value", "999,999.99") or FORMAT_NUMBER(PaymentAmount/Val
Hi Kevin
We are based in the UK, and although the standard invoice amount in payments gives us decimals, we need the thousand seperator for:
PaymentAmount/Value
So In my fixed etext I have tried all of these:
FORMAT_NUMBER("PaymentAmount/Value", "999,999.99")
FORMAT_NUMBER("OutboundPaymentInstruction/PaymentInstructionInfo/OutboundPayment/PaymentAmount/Value", "999,999.99")
FORMAT_NUMBER(OutboundPaymentInstruction/PaymentInstructionInfo/OutboundPayment/PaymentAmount/Value, "999,999.99")
FORMAT_NUMBER("OutboundPaymentInstruction/PaymentInstructionInfo/OutboundPayment/PaymentAmount/Value", "999,999.99")
In the output I get: ?????????
What am I doing wrong?
In the etext field the field is defined as follows:
<LEVEL> | DocumentPayable | |||||||
<POSITION> | <LENGTH> | <FORMAT> | <DATA> | <PAD> | <COMMENTS> | |||
<NEW RECORD> | LINE_DETAILS |
1 | 10 | Number | FORMAT_NUMBER("1234567890.0987654321", "999,999.99") | R, ‘ ‘ |
Thanks In Advance!