After our upgrade to GP2013, all of our Smartlist reports are showing four decimal places instead of the normal two. Is there a place I can change the formatting options so it affects all smartlists?
*This post is locked for comments
Makes perfect sense, thanks Mariano
With the introduction of Microsoft Dynamics GP 2013 and the Web Client, Smartlist performance needed to improve to make the export functionality usable over Web Client, as such, reports are exported unformatted with the hopes that the end user will make them pretty if needed.
If you need nicely formatted reports I would suggest you switch to the Excel Reports.
Carl,
Mostly with document numbers. It would strip the zeros out, and sometimes number the documents oddly. It did it with docs that either had leading or trailing zeros. Other things may happen, but that's been my experience.
That's one of the reasons why it is 'unsupported'.
Kind regards,
Leslie
Thanks Leslie.
What sort of oddities did you experience?
Hi,
There was another question related to this not too long ago. I tried a couple of things and did find one thing that worked, with reservations.
My answer involved using an unsupported dex.ini switch, but it works (be careful, there have been oddities).
SmartListEnhancedExcelExport=TRUE
Put that in your dex.ini file (in the Data folder) and your currency will go back to two decimals. You'll also notice a drastic increase in your download speed.
I tried various combinations of the following .ini switches and none of them worked.
ListsFastExcelExport=TRUE
StdInternationalInfo=FALSE
ExplorerFormatCurrency=TRUE
I tried both TRUE and FALSE, and various combinations, to no avail.
Kind regards,
Leslie
Now that they've finally given me more details, here's an update.
The smartlist itself in GP shows the two decimal places correctly; it's when they export the data to Excel that the formatting is changed to four decimal places instead of the normal two. They tell me this "broke" with GP 2013.
Is there any way to preserve the formatting when going to Excel?
Hi,
Indeed, updating that information field by field can take some time...
The information about smartlist fields is stored in DYNAMICS.dbo.SLB10200, so a query like this one should do the job :
|
update DYNAMICS.dbo.SLB10200 set DECPLCUR = 3 where DECPLCUR = 5 -- and smartlist_ID = 'name' and field_number = 38 -- add more criteria if needed |
Not sure if there is another way, but I tried this on GP2010 with success. Note that the field DECPLCUR contains the number of decimals +1, so to display 2 decimals, you need to specify 3.
I would suggest to test it on a test server or at small scale first...
Hope it helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (