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!
Comments
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.
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
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......
:?