topic Re: AX Server Save Decimal values in European format (1.01.00,00) in Talend Studio

AX Server Save Decimal values in European format (1.01.00,00)

Anonymous — Sun, 06 May 2018 19:12:59 GMT

Hi Support Team,

We are writing data in AX server using AXSAXOutput. AX Server Save Decimal values in European format (1.01.00,00) The issue we are facing is the double format, As AX is configured in AX in European format. The data we put is in general format 10100.00. The problem is in writing in European decimal format. It is easy to ready data as per requirement and parse it.

We have also converted the format of Decimal using decimal functions. : java.text.NumberFormat.getNumberInstance(java.util.Locale.ITALY).format(10100.00) But it return a String not double value. And AX server reject any string value. And if we format it and parse it again to double using : noformat.parse(myString).doubleValue(); It remove all formatting and number get it's default format (10100.00). Please suggest if there is any solution for this.

Thanks,

Re: AX Server Save Decimal values in European format (1.01.00,00)

Anonymous — Wed, 09 May 2018 07:57:37 GMT

Hello,

Are you using tMSAXOutput component in your work flow? Could you please post your job setting screenshot on forum?

Best regards

Sabrina

Re: AX Server Save Decimal values in European format (1.01.00,00)

Anonymous — Wed, 09 May 2018 08:40:03 GMT

Hi @xdshi ,

The job is working perfectly apart from the decimal data issue.The snapshot is attached for your reference Please find the same. Any suggestion will be helpful.

Thanks,

Vikas

settings.png