SmartList amount formating

(0) Share

Report

Posted on by SRM74

170

Hi,

When I am getting any query in SmartList, the amounts are showing in 5 decimal places. How to format it to show only 2 decimal places and with accounting number format.

Thanks,

Ran

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: SmartList amount formating

Ran,

Here is a link to a Microsoft Knowledge Base article on why this happens, and what methods they would suggest for dealing with what is a design decision.

https://support.microsoft.com/en-us/help/2881746/smartlist-and-navigation-lists-export-currency-values-with-5-decimals-in-excel-using-microsoft-dynamics-gp-2013

We recommend SmartList Builder and other eOne products to all of our clients, and most of them implement them. If you have SmartList Builder, you can actually change the setting using the following approach. Modify the SmartList, chose the amount field, click on the blue arrow and move to the Decimals tab, and change the setting to Constant and 2. Please see the screen shot below: