Microsoft Dynamics GP 2013 SmartList Export to Excel values are 0

Written By: Sheila Ochoa

from March 13, 2013

A customer brought an issue to our attention with Microsoft Dynamics GP 2013 and exporting SmartLists to Excel. Using the Employee default to create a new Smartlist, if you add a column called “Vacation Accrual Amount”, in SmartList after that column is added, the values show up in SmartList just fine.   However, when you export the list to Excel the values for this column are zero in Excel. If you export this to Word, the values are there.

Microsoft Dynamics GP 10 is working just fine.  So this is an issue with GP 2013 and does happen with both Microsoft Office 2010 and Microsoft Office 2013.

I am not sure if there are other fields that will have this same issue and I am also not sure yet of a scheduled fix date, but this has been reported to Microsoft who has tested and confirmed this as an issue.