Adjust Smartlist decimal places

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (1)

Philippe Simoes 380 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Leslie.

What sort of oddities did you experience?

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MG-16101311-0 26,225 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Makes perfect sense, thanks Mariano

Was this reply helpful? Yes No