Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DailyBankTransactions.php: inf in balance and running total
10-31-2020, 10:54 AM,
#1
DailyBankTransactions.php: inf in balance and running total
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:

       

Thank you for your input!
Reply
10-31-2020, 05:38 PM,
#2
RE: DailyBankTransactions.php: inf in balance and running total
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
Reply
11-07-2020, 02:47 AM,
#3
RE: DailyBankTransactions.php: inf in balance and running total
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!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)