Dear Experts,
I have a GL Bank Account, which is set to a USD currency. My Exchange rate for the month is $1 = Ksh. 80 (LC).
When i generate a General Ledger report, the closing cumulative balance figure does not tally with the FC ($) figure. Below is an example:-
Posting Date Doc. No. Deb./Cred.(LC) Cumulative Bal (LC) Deb./Cred. (FC) Cumulative Bal(FC) ) 02/03/10 PS 10000174 -48320.00 767276.23 -604.00 436.77 12/03/10 PS 10000186 -1316963.20 -549686.97 -16462.04 -16025.27 12/03/10 PS 10000186 1316963.20 767276.23 16462.04 436.77 30/03/10 RC 10000655 3255200.00 4022476.23 40690.00 41126.77 30/03/10 RC 10000656 2800000.00 6822476.23 35000.00 76126.77 30/03/10 JE 10021335 -2000000.00 4822476.23 -25000.00 51126.77 30/03/10 JE 10021336 -2000000.00 2822476.23 -25000.00 26126.77 30/03/10 JE 10021337 -2080000.00 742476.23 -26000.00 126.77 31/03/10 BN 10021867 -6320.00 736156.23 -79.00 47.77
If you notice, $47.77 is the cumulative total figure(FC), and the corresponding LC figure value should actually be (47.77*80 = 3821.6) but it is 736156.23.
How can i have the report showing the period end balance in LC (KSH) to be 3,821.60, instead of 736,156.23.
Your help will be much appreciated.
regards,
Feroz Dosani.