You’re offline. This is a read only version of the page.
432
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
I have the same question (0)
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
Share
Report
All responses (
Answers (
