Rounding problem
Hello
I am doing accounting program. Its double entry accounting system. Example
1-Aug-2006 20000 ACCOUNT PAYABLES DB: 2000.00
1-Aug-2006 60200 EXPENSES CR: 2000.00
I am generating a report to show monthly journal.
I am calculating totDBAmt and totCRAmt. Based on above, it should show same value(debit and credit). But I am getting some cents difference.
totDBAmt : 757892.74
totCRAmt : 757592.79
in the loop, i am calculating these values. I am using cdbl(rs("dbAmt")) and cdbl(rs("cramt"))
Why is it showing difference?
If I see each entry, its showing correct values(dbamt and corresponding cramt).
where was I wrong?
|
