Tryton - Issues

 

Issue7628

Title Filter error on Account General Ledger
Priority bug Status chatting
Superseder Nosy List ced, perilla
Type Components account
Assigned To Keywords
Reviews

Created on 2018-08-16.14:31:30 by perilla, last changed by ced.

Files
File name Uploaded Type Edit Remove
filter_by_dates.png perilla, 2018-08-16.14:36:43 image/png
filter_by_periods.png perilla, 2018-08-16.14:36:55 image/png
Messages
msg42928 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2018-08-16.15:59:12
I think it is because in get_period_ids period_ids is always filled with 0 for the start. So the period clause is added in query_get that match no period.
msg42926 (view) Author: [hidden] (perilla) Date: 2018-08-16.14:38:54
An better sample is get General Ledger with periods from: 2018-04 to 2018-12
And then get General Ledger with dates: from 2018-04-01 to 2018-12-31

I upload screenshots with results, on two cases.
msg42924 (view) Author: [hidden] (perilla) Date: 2018-08-16.14:31:29
When I use only from_date and to_date on general ledger,
result data never return start_balance.

To reproduce on http://demo4.8.tryton.org/
1.- Go to General Ledger Accounts
2.- Filter by Periods -> Start Period: 2018-06
3.- Click reload

Repeat with start date:
1.- Go to General Ledger Accounts
2.- Filter by Periods -> Start Date: 2018-06-01
3.- Click reload

IMHO results in two cases must be the same, but
only when filter by period, I get start_balance.
History
Date User Action Args
2018-08-16 15:59:12cedsetnosy: + ced
messages: + msg42928
2018-08-16 14:38:54perillasetstatus: unread -> chatting
messages: + msg42926
2018-08-16 14:36:55perillasetfiles: + filter_by_periods.png
2018-08-16 14:36:43perillasetfiles: + filter_by_dates.png
2018-08-16 14:34:06perillasetfiles: - with_start_date.png
2018-08-16 14:34:03perillasetfiles: - with_start_period.png
2018-08-16 14:32:10perillasetfiles: + with_start_date.png
2018-08-16 14:31:49perillasetfiles: + with_start_period.png
2018-08-16 14:31:30perillacreate

Showing 10 items. Show all history (warning: this could be VERY long)