Sunday, 24 June 2012

Negative amounts display #NAME? in Smartlist export

An end user the other day stated that a Dynamics GP Smartlist Builder report that was not exporting data for some rows.  Negative amounts were displaying #NAME? in Microsoft Excel.

To correct the issue for each Amount field I changed the properties in thge Field Optons window (Click Blue arrow next to field to open).  I then unmarked the Show currency Symbol and Show Thousands Separator fields in the Display tab.

No comments:

Post a Comment