Incorrect transaction amount and revenue on /billing/order/ table

[SimplyPancake]

There seems to be incorrect data in the /billing/order table, but correct data on every event itself.

[Kurocon]

I noticed this myself as well. The error should be in this change somewhere, but I cannot spot it yet.
f76baf4

[Kurocon]

I do notice that the reported 'transaction count' 2142 is exactly 119 * 18, which is the amount of regular transactions times the amount of writeoff transactions. So probably somewhere an aggregation is going wrong and creating duplicate results. Perhaps a simple .distinct() on this query fixes the issue.

[SimplyPancake]

I cannot spot it yet either, I think it has to do with the Sum function, but I am still figuring it out as well.

[SimplyPancake]

That seems to be a good option to consider. I'll look into it :)