News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Amount format for a SQ...

Microsoft Dynamics GP (Archived)

Amount format for a SQL Script

(0) Share

Report

Report

Posted on by Tina Haerr

430

The following is line for an amount field in a SQL View. I attached the view to a SmartList using SmartList Designer. When the SmartList is exported to Excel, the Amount column has a general format and can't be summed unless the column format type is changed. I also tried setting the format Currency in SmartList Designer to a $ and 2 decimals, but it still exports with a general format type.

AAGL.GLDebit [Amount]

How should this line be written / formatted so that when the SmartList is exported to Excel it's in a number format so it can be easily summed.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: Amount format for a SQL Script

Hi Tina,

This is an inherent problem with the SmartList exports to Excel.. not a SQL view issue. You can format that in any format you like in SQL, it will always be threated as a 'general' format when arriving in Excel.

However, you could try in GP's DEX.ini (fat client side) to add the following entry :

SmartlistEnhancedExcelExport=TRUE

It was my understanding that this was a bug until GP 2013 and should have been fixed by 2013 or 2015, and according to this blog post it should:

www.erpsoftwareblog.com/.../export-formatted-numbers-to-excel-with-dynamics-gp

partnersupport.microsoft.com/.../8e009ec0-4ef4-4a0a-ade0-1aff6bfdec57

Hope this helps..

PS: check also this thread : https://community.dynamics.com/gp/f/32/t/108340

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans