DailyBankTransactions.php: inf in balance and running total - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8) +--- Thread: DailyBankTransactions.php: inf in balance and running total (/showthread.php?tid=8417) |
DailyBankTransactions.php: inf in balance and running total - HDeriauFF - 10-31-2020 when viewing DailyBankTransactions.php with with Transactions Dated From 08/26/2020 until todays date, I get an "inf" in "Balance in USD" and "Running Total USD" columns for all following transactions of the year. If I change my search withTransactions Dated from with 08/26/2020, both columns are fine. What could have gone wrong in transaction 771 to trigger that? See screenshots: [attachment=1038][attachment=1039] Thank you for your input! RE: DailyBankTransactions.php: inf in balance and running total - TimSchofield - 10-31-2020 It looks to me like the USD/EUR exchange rate is zero for that transaction. Run the SQL: SELECT * FROM banktrans WHERE type=22 AND transno=771; and look for the exrate field. Thanks Tim RE: DailyBankTransactions.php: inf in balance and running total - HDeriauFF - 11-07-2020 Sure enough the exchange rate was at zero for a few transactions this past year. Was fun to find the root cause and fix :-) Thank you for your input! |