webERP Forum
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!