Share
Reporthello every one .
when ever i'm going to export data from smartlist to excel it change some values.
*This post is locked for comments
You’re offline. This is a read only version of the page.
hello every one .
when ever i'm going to export data from smartlist to excel it change some values.
*This post is locked for comments
Thank you for your reply. Since I've read some things about the dex.ini change affecting document numbers with leading or trailing zeros and other formatting problems, I went another route. I simply copied the t-sql query from the smartlist window for the list I was trying to export, and pasted it into SQL and created a view. Then, I opened Excel and connected it to SQL to pull in my new view, essentially making the smartlist into a refreshable Excel report that the client is even more pleased with. Using this method also pulls the data correctly with no issue, so it's a win-win.
A quick solution is to add the following function to your Dex.ini file
SmartlistEnhancedExcelExport=TRUE
this should work...we had the same issue with the Manufacturing module
Tami
Mahmoud,
I know this is an old post, but maybe you can help me as well. My client is using GP 2013 and has a weird issue when exporting a smartlist to Excel. I know GP 2013 exports all numbers out to 5 decimals, and that is fine. However, they are getting different results in the manufacturing module than in the inventory module. For example, if I look at the inventory quantities smartlist, I see quantities listed as 2,071 and 1,846.30470 and 30. These numbers export to Excel correctly and show as 2,071.00000 and 1,846.30480 and 30.00000 respectively. The problem is when running the manufacturing orders smartlist. For example, I may have quantities of 950 and 915.00000 and 1,960.00000 BUT when I export these to Excel they show as 950.00000 and 915.00000 and 1.00000. So, as you can see, it seems that anything less than 1000 will export correctly, but 1,100 would export as 1.00000 and 3,456 would export as 3.00000. It seems like rather than just adding the 5 decimals, it is only reading the first digit when the number is greater than 1000.
If you have any ideas on how to resolve this I would greatly appreciate it. Also, if you need more information or clarity on the problem just let me know.
Thank you!
If you want a permanent solution not to export the currency symbol at all, include this function in your Dex.ini file
ExplorerFormatCurrency=FALSE
Thanks
This is a manual exercise. Is there not any other way.
Yes, you are correct. Here is another quick work around solution to remove the currency symbol from the exported excel file
Please never hesitate to share any further inquiries,
Thanks Saadi.
by entering the following function to dex.ini. My Issue is resolve. but there is one problem. that currency sign is also exported to excel which is not required. and creating difficulty to applying formulas.
SmartlistEnhancedExcelExport=TRUE
Thanks
A quick solution is to add the following function to your Dex.ini file on the default following path C:\Program Files (x86)\Microsoft Dynamics\GP2015\Data\Dex.ini
SmartlistEnhancedExcelExport=TRUE
Or you may consider the workaround solutions provided by David on Microsoft Dynamics GP 2013 SmartList Export to Excel shows currency values with 5 decimal places
Your feedback is highly appreciated,
Yes
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
