When I do a select my numeric value have a dot as decimal

(0) Share

Report

Posted on by XB

1,875

Hi.

When I open a form with a numeric value decimal comes with comma and thousands with dot like 1.000,03.

But when I do a select with X++ values shows differents, last example looks like 1000.03, what is the reason for this?Because I'm having problems with a export file.

Thanks for hepl.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Javier,

Can you indicate what coding you are using for the export? Note that the point is internally used within the AX logic. How it is presented on a form depends on user settings.

Have also a look at the next page for some help on number formatting. msdn.microsoft.com/.../aa866120.aspx

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report

Here's my code

commaTextIo = new CommaTextIo(fileName, "w");

while (qr.next())

{

generalJournalEntry = qr.get(tableNum(generalJournalEntry));

generalJournalAccountEntry = qr.get(tableNum(generalJournalAccountEntry));

commaTextIo.write(generalJournalAccountEntry.LedgerAccount, generalJournalEntry.SubledgerVoucher, generalJournalAccountEntry.AccountingCurrencyAmount, generalJournalEntry.AccountingDate, generalJournalAccountEntry.text, generalJournalAccountEntry.TransactionCurrencyAmount, generalJournalAccountEntry.TransactionCurrencyCode);

}

AS you can see I'm not converting numeric to strings...I try with AsciiIo ,textIo event System.io.streamwriter...and I always have the same problem.

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Javier,

You can use the function num2str() to define the thousands and decimal separator. As mentioned the point is used within AX internally. If you don't specify the user preference in coding, it will not convert it as per your preferences.

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report

The problem is that I don't wanna save as string, if I use num2str the value will be converted to string and it 'll show with quotes..

Look at the first red column on images.

Was this reply helpful? Yes No
Israel Gonzalez 733 on at

Like (0)

Report

Hi Javier,

Did you check the regional configuration in your machine and the server?

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report

Yeah, I check on Ax and machine on server, both have the same configuration "es", I checked language, keyboard..

Was this reply helpful? Yes No
Israel Gonzalez 733 on at

Like (0)

Report

If you print CompanyInfo::find().LanguageId what do you see?

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report

Hi Israel.

I see "es", all config are in spanish.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Javier,

Your initial question was tagged with "CSV". CSV is a text format. What exact class are you using for exporting the file?

Have you also looked at Data Import/Export Framework?

Was this reply helpful? Yes No