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

(0) Share

Report

Posted on by XB

1,867

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

All responses (11)

Answers (1)

XB 1,867 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.
Verified answer

André Arnaud de Cal... 291,391 Super User 2024 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?
XB 1,867 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.
Israel Gonzalez 708 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?
XB 1,867 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..
Israel Gonzalez 708 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?
XB 1,867 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.
André Arnaud de Cal... 291,391 Super User 2024 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.
XB 1,867 on at

Like (0)

Report

RE: When I do a select my numeric value have a dot as decimal
XB 1,867 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.