tag:blogger.com,1999:blog-5285970135510371565.post480454279534287947..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: GP 2013: Why are my SmartLists not formatted when exported to Excel? Mariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-5285970135510371565.post-83680509011873783712019-03-12T15:13:43.957-04:002019-03-12T15:13:43.957-04:00Has anyone posted a fix for the "columns shif...Has anyone posted a fix for the "columns shifts on the Excel export if you use the SmartlistEnhancedExcelExport=TRUE"?<br /><br />I saw Pam Robertson posted kink to a suggested fix on connect.microsoft.com but that site has been retired.Anonymoushttps://www.blogger.com/profile/12028146901731740511noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-57145337019363909062018-02-28T17:01:10.913-05:002018-02-28T17:01:10.913-05:00Verify you DO NOT have present a forms dictionary ...Verify you DO NOT have present a forms dictionary for Smartlist (EXP1493F.dic), in the path indicated by your DYNAMICS.SET file. If so, rename it and relaunch GP to see if this fixes the problem.Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-40461124020800220322018-02-28T07:55:43.256-05:002018-02-28T07:55:43.256-05:00Hi All,
GP2016-620(R2) I am having similar issues...Hi All,<br /><br />GP2016-620(R2) I am having similar issues in Samrtlist designer where most of the columns are changed into the different type of data after exporting to Excel where in smartlist it is ok, once exported to excel all the data is shared and codify in a strange manner below are few examples: <br />=DATE(2018,1,1),(suppose to be doc date )<br />#NAME? (suppose to be Account Description) <br />#NAME? (suppose to be TaxDetail Id) <br />0.00000 (suppose to be A Negative number) (-9000.00)<br /><br />to mention there is no special character used anywhere in data <br /><br />apart from this smart list is not sorting the data column by clicking on a column heading a usual practice, any idea what is going on Anonymoushttps://www.blogger.com/profile/07065658517915844668noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-36369523369114805252017-06-12T18:37:37.792-04:002017-06-12T18:37:37.792-04:00Anonymous,
Not sure there's much I personally ...Anonymous,<br />Not sure there's much I personally can do. It will depend on Microsoft to improve the export capabilities of SmartList on Web Client. If something does not meet your requirements, I believe you should be posting it on connect.microsoft.com for the Product Management team to review. Get people to vote on it.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-9456898240122589132017-06-12T18:35:25.373-04:002017-06-12T18:35:25.373-04:00Mey,
What version of GP are you referring to? Is t...Mey,<br />What version of GP are you referring to? Is this still GP 2013? I know this problem has since been fixed in GP2015 R2 and above. <br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-64587753921234006372017-06-08T11:50:52.460-04:002017-06-08T11:50:52.460-04:00Mariano Gomez,
Could you please explain the steps ...Mariano Gomez,<br />Could you please explain the steps to export the currency id? <br />We have SmartlistEnhancedExcelExport=TRUE in dex.ini and we need to export the currency correctly to Excel. $ is exporting but not English pound. <br />Thanks!Meyhttps://www.blogger.com/profile/12009592826985297321noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-8058638093884618202017-02-13T14:39:29.195-05:002017-02-13T14:39:29.195-05:00I just submitted a suggestion to fix the problem w...I just submitted a suggestion to fix the problem where the columns shift on the Excel export if you use the SmartlistEnhancedExcelExport=TRUE and the first column is blank. If you're experiencing that error, you can vote for the suggestion here:<br /><br />https://connect.microsoft.com/dynamicssuggestions/feedback/details/3122390/fix-the-smartlist-export-to-excel-to-properly-align-columns-when-using-smartlistenhancedexcelexport-trueAnonymoushttps://www.blogger.com/profile/10378253896524427967noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-43381643490420396122016-06-17T06:00:57.635-04:002016-06-17T06:00:57.635-04:00Just wanna ask what will you do if it happen in GP...Just wanna ask what will you do if it happen in GP Web while SmartlistEnhancedExcelExport=TRUE can't be used in GP Web. You have another solution?<br /><br />Thanks before.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-66929507550665285202015-01-19T19:46:33.406-05:002015-01-19T19:46:33.406-05:00You will need to export the currency Id as well.
...You will need to export the currency Id as well.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-13968274136924324342015-01-16T04:50:42.337-05:002015-01-16T04:50:42.337-05:00But my user has a column with multiple currencies....But my user has a column with multiple currencies. If the Currency Symbol is removed after export, how would you know which cell refers to which currency?<br />I don't think this is very useful.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-84973537823245316562014-11-03T15:36:44.188-05:002014-11-03T15:36:44.188-05:00We are also having the problem that when a column ...We are also having the problem that when a column is blank it moves the data to the left...has anyone figured out a solution to that issue?<br /><br />thanskDavenoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-25910404492977823152014-05-31T05:06:23.030-04:002014-05-31T05:06:23.030-04:00This article was very helpful in answering allot o...This article was very helpful in answering allot of questions.Thanks for posting.Microsoft Dynamics GPhttp://www.evinciblesolutions.com/index.aspxnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-45491019682391515712014-02-02T22:39:39.511-05:002014-02-02T22:39:39.511-05:00Problem with this or at least what I have noticed ...Problem with this or at least what I have noticed is that if one column is blank it moves the data on the right to the blank column on the left.<br /><br />go awayhttps://www.blogger.com/profile/09629335159083938817noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-72931465702799984412013-12-20T13:07:56.860-05:002013-12-20T13:07:56.860-05:00This was more than displaying the correct number o...This was more than displaying the correct number of decimals for us. In the Inventory Purchase Receipts Excel Export from smartlist (GP 2013), Qty received values greater than 1000 were exported with just the first digit. Eg. a received quantity of 1600 is exported as 1.00, 4032 was exported as 4.00. The Dex.ini setting took care of this problem. Thanks Mariano!RanjitCharlesnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-20701184632303069792013-12-12T09:55:01.802-05:002013-12-12T09:55:01.802-05:00Wow, after adding:
SmartlistEnhancedExcelExport=TR...Wow, after adding:<br />SmartlistEnhancedExcelExport=TRUE<br /><br />to my Dex.ini file, the Excel export runs SUPER fast. It's a huge noticeable difference. Too cool! <br /><br />By the way, I did this in GP 2013 and GP 2010 R2. Works for both!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-21518994395374458722013-12-03T08:46:55.621-05:002013-12-03T08:46:55.621-05:00Thank you, very helpful.Thank you, very helpful.Hussain Ali Al Yousefhttps://www.blogger.com/profile/07478312179692385240noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-69592799532897010582013-10-14T08:05:41.792-04:002013-10-14T08:05:41.792-04:00Useful tip!!Useful tip!!Tinahttps://www.blogger.com/profile/16834555017451410972noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-37893117281013938462013-08-23T10:30:14.628-04:002013-08-23T10:30:14.628-04:00Does it matter what version of Excel? I have a cl...Does it matter what version of Excel? I have a client using Excel 2010 and the switch doesn't seem to be working.<br />Anonymousnoreply@blogger.com