Tryton - Issues

 

Issue7628

Title Filter error on Account General Ledger
Priority bug Status testing
Superseder Nosy List ced, perilla, risto3
Type behavior Components account
Assigned To ced Keywords review
Reviews 60421002
View: 60421002

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

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
msg44750 (view) Author: [hidden] (risto3) Date: 2018-11-03.09:52:08
seems to work for me again with filter :
"Balance de départ": !0 or (Débit: !0 or Crédit: !0)"
msg44732 (view) Author: [hidden] (ced) (Tryton committer) (Tryton translator) Date: 2018-11-02.21:56:09
Here is review60421002
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-11-03 09:52:09risto3setnosy: + risto3
messages: + msg44750
2018-11-02 21:56:10cedsetstatus: chatting -> testing
keyword: + review
messages: + msg44732
reviews: 60421002
assignedto: ced
type: behavior
2018-10-25 00:03:55cedlinkissue7772 superseder
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

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