A few issues with Reports


I have a few issues in the reports section :

  1. Date columns won’t filter by ASC or DESC when arrow is clicked
    see screenshot at https://drive.google.com/open?id=1TBWX6R2NUTcOaeknb3GtxuD3_ic48cWj)

  2. There seem to be an inconsistency between Paid amount totals in reports.
    see screenshots
    2 : https://drive.google.com/open?id=1lrA3qbXZJn2QDRBsazKXtgSghMW0OFID
    3 : https://drive.google.com/open?id=19fdyTiNhOBI1ObWAHqLcPU0koKPN9Q7u


  1. This looks like a bug, the reports uses a string comparison sort method which is failing due to the date format.

  2. Hard to tell what the problem is from the totals, I’d suggest checking the details to see which rows are different. The reports won’t necessarily match as one filters by the invoice date whereas the other uses the payment date.

  1. Ok, thanks. Do you plan fixing that on next release ?

  2. My bad. 1 invoice was issued and half paid in 2016. The balance was paid in 2017, thus the difference


  1. We’ll look into fixing it in a future release


I know you’re in a major overhaul on IN, but an old issue is still without a fix. I have posted an issue about date filter not working correctly on Reports due to date format (fr-CA in my case).
Do you have any plan fixing this issue in v4 or in newer v2 ?