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.
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.
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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment