Change the position of coma in currency??

Mrinmay

Hi All,
i want to know is it possible to represent currency in indian manner?
means i want to change the position of coma(,) in currency.
in navision it represent like 123,123,123.00 but i want like 12,31,23,123.00..is it possible??
thanks in advance..

mrinmay

Savatage

have you tried setting your control panel->regional settings?

Mrinmay

ya i tried that one..but then also it is not working

Joeri

What Savatage said is the way to do it. Navision uses the Regional Settings of your windows. If it says in windows 12,31,23,123.00 then NAV should be the same.

Mrinmay

after changing in control panel i need to re install navision again or not?
because, i already changed in but it is not refecting in navision.

Belias

Try to restart your pc...

DenSter

Mrinmay wrote:

Hi All,
i want to know is it possible to represent currency in indian manner?
means i want to change the position of coma(,) in currency.
in navision it represent like 123,123,123.00 but i want like 12,31,23,123.00..is it possible??
thanks in advance..

mrinmay

Those commas are the thousand separators, and you can set those in the regional settings. I've never seen a number that is marked like that, and I am curious what it means. How do you pronounce the number 12,31,23,123.00?

David_Singleton

This is how currency works in India.

1,00,000 is one lakh (one hundred thousand)

2,00,00,000 is two crore (twenty million)

3,00,00,00,000 is three arawb (three US billion)

basically in India after 1,000 the digits are grouped in twos, and this is VERY important especially in an accounting environment such as Navision. And NO NAV does NOT read this setting from the regional settings. If you select say Hindi then Excel works fine, but Navision just totally ignores it.

This is a pretty huge oversight by Microsoft and they really need to fix it. It is a true stumbling block when selling Navision in India.

BTW you can manually add code on EVERY currency field and hard code it, but that of course would be insane.

DenSter

Cool thanks for the explanation. 8)

David_Singleton

DenSter wrote:

Cool thanks for the explanation. 8)

Well I had to learn this for training, it was just too hard for them to follow thousands and millions. Also for me to understand for instance when a client had 2 crore G/L entries, and trying to work out if that was a lot or a little.