precision rounding of FCY to LCY

AhMoiAhMoi Member Posts: 9
edited 2004-01-13 in Navision Attain
Hi there,

have a problem with precision rounding for sales invoice.

When I FCY is converted into LCY, there is a 1 cent discrepancy.

I understand that there is quite a few precision setup in General Ledger Setup and Currencies Setup, but I am not sure which one to begin with.

Have any one encounter this problem before?

Thanks in advance! :)
Ah Moi

Comments

  • SbhatSbhat Member Posts: 301
    Hi,

    If you set the General Ledger setup rounding precision, it works to the nearest penny. I have used it before and i used to set it to .01 and it worked perfect.

    Regards
    Suresh.
  • AhMoiAhMoi Member Posts: 9
    Hi,

    after looking through some of the code units, I notice the following:

    eg. when I post a sales invoice in currency A as follows:
    base amount = 11,399.68.
    amount incl 4% VAT = 11,855.67 (sys auto fill this in)

    after posting:
    in GL ledger entries in LCY (factor 1.74 to currency A)
    base amount = 19,835.44.
    amount incl 4% VAT = 20,628.87.
    4% VAT = 793.43. (sys calculates as amount incl VAT - base amount)

    This VAT should be 0.04 * base amount = 793.42 (rounded to 0.01 precision of 793.4176) Thus, I have 1 cent more!

    How can I overcome this?
    thanks.

    ah moi
    Ah Moi
  • AhMoiAhMoi Member Posts: 9
    Hi,

    when doing more testing in general journal, a correction line of -0.01 is required for the LCY portion to balance (which is what i expected to be correct). But how come no such correction is required when i post the same thing via sales invoice?

    help......

    :?
    Ah Moi
Sign In or Register to comment.