Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Multicurrency smartlist issue

113 views
Skip to first unread message

mic...@microsoftinstructor.com

unread,
Feb 3, 2010, 5:08:01 AM2/3/10
to
When i go to smartlist / financial / account transactions it shows my foreign
currency Hong Kong dollars with the letters HKD before the amount. For eg.
HKD10,589.18. Hong Kong dollars is the functional currency for that
particular company as well.
When I export to excel it wont let me do any totals, the letters HKD are in
the way and then I have to edit the excel worksheet. Is this correct behavior
for smartlist?

Victoria [MVP]

unread,
Feb 3, 2010, 7:19:03 AM2/3/10
to
Yes, this is the correct behavior. You can either run a formula in Excel to
remove the HKD or use this tip I learned from Leslie Vail:

In the dex.ini file on the computer where you are exporting to Excel, add
the following line:
ExplorerFormatCurrency=FALSE

This will cause all currency amounts (including US $) not to be formatted
when they are exported to Excel from SmartList.


--
Victoria Yudin
Dynamics GP MVP
Want to use Crystal Reports with GP?
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com


"modo...@knight.com" <mic...@microsoftinstructor.com> wrote in message
news:EB9F7B1A-EC8E-44A2...@microsoft.com...

Jamrock

unread,
Feb 3, 2010, 7:42:41 AM2/3/10
to
That is so cool. Good tip.


"Victoria [MVP]" <vict...@flex-solutions.com> wrote in message
news:07FDDB15-9CBA-4525...@microsoft.com...

mic...@microsoftinstructor.com

unread,
Feb 3, 2010, 9:27:01 AM2/3/10
to
Thank you for an excellent solution.

Jamrock

unread,
Feb 3, 2010, 11:20:20 AM2/3/10
to
Can you post a list of these little known dex.ini options? I think Leslie
posted some once.

Do you know of a document or blog listing them?

"Victoria [MVP]" <vict...@flex-solutions.com> wrote in message
news:07FDDB15-9CBA-4525...@microsoft.com...

Victoria [MVP]

unread,
Feb 3, 2010, 1:49:38 PM2/3/10
to
http://dynamicsconfessions.blogspot.com/2008/12/dexini-switches.html

http://dynamicsconfessions.blogspot.com/2009/01/dexini-switches-part-2.html


--
Victoria Yudin
Dynamics GP MVP
Want to use Crystal Reports with GP?
http://www.flex-solutions.com/gpreports.html
blog: http://www.victoriayudin.com


"Jamrock" <news_j...@yahoo.com> wrote in message
news:eoFkdGPp...@TK2MSFTNGP05.phx.gbl...

brenne...@gmail.com

unread,
Apr 10, 2013, 4:10:38 PM4/10/13
to
Hi,

I'm having the same problem with the company currency (S/.) but using those two options in dex.ini seems not to remove the currency. I'm using GP 2010 v11.00 SP2. Don't know if it has to do with the versions. Thanks
0 new messages