Options

Dividing Local Currency by 1000

xchildxchild Member Posts: 22
Recently, just a few hours ago, I was informed about changes in monetary policy that have resulted in me having to find an elegant way to divide every value stored in Navision local currency fields by a 1000.

Is there a tool I can use to help me do that?

I need to do this for all my clients.

Comments

  • Options
    ara3nara3n Member Posts: 9,256
    :shock:

    I'm sorry but could you give some background on this?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    lessilessi Member Posts: 33
    In Europe we used the Euro Conversion Tools when we turn from local currency to Euro. perhaps your NSC could contact MBS to get this tools.

    Regards.
  • Options
    xchildxchild Member Posts: 22
    Well, the requirement is that all amounts be converted to the new pseudo currency, the currency is not changing name, but it has been valued a thousand times higher so that there would be less zeroes showing on prices etc (inflation is around 1000% here!). New notes have been introduced as well.

    From a Navision point of view all old transaction amounts must be in the new currency as well, meaning the amounts have to be divided by zero.

    The Euro conversion tool sounds interesting, I don't know if the scenarios are similar?
  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    xchild wrote:
    [...] meaning the amounts have to be divided by zero.
    This will certainly generates an error ;-)
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    xchildxchild Member Posts: 22
    Oops!

    I mean't 1000.

    Thanks for that.
  • Options
    lessilessi Member Posts: 33
    If you use the Euro Conversion Tools, you hav to create a new currency with the rate in the currency table , so you will be able to print everything using the new or the old currency.

    The conversion rate is not a problem while 1 Euro cost 1936.27 Italian Lire for Example.
  • Options
    xchildxchild Member Posts: 22
    Can i download the Euro conversion tool, and were can I find more information about how it would handle my problem?
  • Options
    lessilessi Member Posts: 33
    i think you can ask your NSC,they surely could contact MBS to get the objects, the notice and the granule ( 99,004,710 Euro Conversion Tool) and adapt the tool.
Sign In or Register to comment.