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)

XB 1,875 on at

Like (0)

Report

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

Thanks Andree.

Finally we'll export all file as string , user prefer that before have to use DMF.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 297,320 Super User 2025 Season 2 on at

Like (0)

Report

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

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
XB 1,875 on at

Like (0)

Report

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

Hi Israel.

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

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

Like (0)

Report

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

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

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

Like (0)

Report

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

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

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

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

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

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
André Arnaud de Cal... 297,320 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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

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

Like (0)

Report

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

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