Reporting Bug: Filter function

milagino
milagino
Offline
0
Hello,

My aim: Set a filter for e.g. 01.01.2015 to 01.07.2015 and check what my Total Income is.

The problem: As you can see in the attached image, the displayed Total Income is calculated wrongly; too low.

Could you give me a suggestion of fixing this bug? In which file can I find the mysql queries?

Thank you very much!
Attachments:
Responses (3)
  • Accepted Answer

    milagino
    milagino
    Offline
    Tuesday, July 28 2015, 04:46 AM - #Permalink
    0
    Sorry, wrong image. Here is the correct one.
    Attachments:
    The reply is currently minimized Show
  • Accepted Answer

    Joan Vilà
    Joan Vilà
    Offline
    Tuesday, July 28 2015, 10:31 AM - #Permalink
    1
    Hello,

    The total income is calculated wrongly because to calculate it, it takes into account the payment datetime.
    The payment datetime must be set between the two dates you spcify in the filter to see its amount added to the Total income.

    If you leave the payment datetime blank, it will not be considered unless there is no filter to calculate the Total income.

    So if you add the payment datetime to the payments of your invoices, the Total income will be correct.

    Thank you,
    Joan
    The reply is currently minimized Show
  • Accepted Answer

    milagino
    milagino
    Offline
    Tuesday, July 28 2015, 12:01 PM - #Permalink
    0
    I am sorry, that I didn´t think of that.

    Thank you for your fast response!
    The reply is currently minimized Show
Your Reply