as show in the screenshot, we have turn off automatic Exchange Varience, in the Setup Company.
1. gl inquiry -> bank payment ref 11 and journal entry ref 12 15-jan-2018, created negative balance for petty cash
2. bank account inquiry -> balance for the petty cash showing 205,393.00 (not negative value)
https://www.dropbox.com/s/fsgzrhaj9bd2h61/negative%20value%20for%20automatic%20exchange%20variance.zip?dl=0
thanks
]]>Those exchange variance postings are not any bug result, this is exactly how automatic currency accounts revaluation works.
When you make any foreign (i.e. not home) currency payment (or deposit), current money value on the related account is recalculated and the difference in value (due to changed exchange rate since recent currency operation) is posted. If you do not want this to be done automatically, you should set 'Automatic Revaluation Currency Accounts' option in your Company Setup to off.
Then you will have to make currency accounts revaluation manually when you need it, but those isolated automatic 'Exchange Variance' postings will not appear unexpectedly in your GL.
Janusz
I'm not quite sure whether this issue caused by 'Automatic Revaluation Currency Accounts' or not. But I have been using FrontAccounting since 2012, and just happened this issue in June 2017. Now my Profit and Loss statement are totally messed up. And I have no idea how can I fix it.
Should I manually delete all "exchange variance"Journal entry??
]]>(...)
the exchange rates seems doubled from the last transaction, we check in the table currency, values in the some dates is wrong get from google shown 0.0001, but we have correctly this to 0.000074954090619496, even in the pages https://domain/fa/gl/manage/exchange_rates.php? this always shown 0.0001.
there was exchange rate display bug indeed, which just has been fixed in our repo.
Thanks.
Janusz
When you make any foreign (i.e. not home) currency payment (or deposit), current money value on the related account is recalculated and the difference in value (due to changed exchange rate since recent currency operation) is posted. If you do not want this to be done automatically, you should set 'Automatic Revaluation Currency Accounts' option in your Company Setup to off.
Then you will have to make currency accounts revaluation manually when you need it, but those isolated automatic 'Exchange Variance' postings will not appear unexpectedly in your GL.
Janusz
]]>Is the error message below related to this case?
Kevin Lee
]]>I set the decimals length of Amounts in "Display setup" to 0 already. And what should I do next?
Decimal length to 0
How can I fix the "foreign exchange gain"?
Foreign exchange gain in Profit and Lost statement
Kevin Lee
]]>I will show the discussion to Janusz.
/Joe
]]>@joe: separating the amounts and prices into 2 separate config variables for decimal length may be needed to accommodate such cases.
]]>$xr_providers = array("ECB", "YAHOO", "GOOGLE", "BLOOMBERG");
$dflt_xr_provider = 2;
change it from your config.php .
And also enable debugging mode to see whether it throws any error during conversions.
Actually we have the same problem here. Our home currency is HKD (Hong Kong Dollar). Start using FA since 2014 and never had this problem before. Until this year June. We have so many Journal entry generated by system with MEMO "Exchange Variance" in the system. I checked the exchange rate are all fine. And I have no idea what should I do to solve this problem.
Any hints or help please?!!
Kevin
]]>$log_output = "\n\n Start dump of all variables \n\n" . print_r(get_defined_vars(),true) . "\n\n";
file_put_contents('D:/XAMPP/htdocs/fa24/tmp/log_file.txt', $log_output, FILE_APPEND);We got very confused as to how we can report and diagnose this problem, except if possible we send our database dump by PM?
]]>Fot huge currency rates, it is important to use adequate decimals. Otherwise the values will vary very much.
Joe
]]>