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
Thanks Andree.
Finally we'll export all file as string , user prefer that before have to use DMF.
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?
Hi Israel.
I see "es", all config are in spanish.
If you print CompanyInfo::find().LanguageId what do you see?
Yeah, I check on Ax and machine on server, both have the same configuration "es", I checked language, keyboard..
Hi Javier,
Did you check the regional configuration in your machine and the server?
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156