I noticed something interesting, on General Ledger report, if I change the Currency to USD, the debit and credit amount shows different values when there’s not filter used. But then again for that particular entry, it’s showing same value.
This is due to different exchange rate in invoice and system. I think there is some excange rate in the system and invoice has different exchange rate then the system. this difference is due to this.
You need to add one column named grand total and dont select currency in GL report
Hello,
Currenly Im facing the same issue, is there any workaround to prevent this?
Because I need to select different currency in GL report.
I’ve tried use filter group by account then GL will show the right amount but it show all the coa not the one I need. Its getting complicated to sort my document.
Hope anyone can give me some advice.