Issue 7993

Title
problems with start balance in general ledger
Priority
bug
Status
resolved
Nosy list
ced, reviewbot, risto3, roundup-bot
Assigned to
ced
Keywords
review

Created on 2019-01-13.09:38:28 by risto3, last changed 29 months ago by roundup-bot.

Messages

New changeset d4225830f471 by Cédric Krier in branch '5.0':
Test contextual period_ids against None in Move.query_get
https://hg.tryton.org/modules/account/rev/d4225830f471

New changeset b3067bec5035 by Cédric Krier in branch '4.8':
Test contextual period_ids against None in Move.query_get
https://hg.tryton.org/modules/account/rev/b3067bec5035

New changeset 5c7f9e5044f7 by Cédric Krier in branch '4.6':
Test contextual period_ids against None in Move.query_get
https://hg.tryton.org/modules/account/rev/5c7f9e5044f7
New changeset 774483bad188 by Cédric Krier in branch 'default':
Test contextual period_ids against None in Move.query_get
https://hg.tryton.org/tryton-env/rev/774483bad188
New changeset 8c4c1c2808f6 by Cédric Krier in branch 'default':
Test contextual period_ids against None in Move.query_get
https://hg.tryton.org/modules/account/rev/8c4c1c2808f6

New changeset a20e0e48064a by Cédric Krier in branch 'default':
Add test for GL with empty period list
https://hg.tryton.org/modules/account/rev/a20e0e48064a
Author: [hidden] (risto3)
Date: 2019-01-17.18:27:58
seems much better!
Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2019-01-17.17:59:03
It was introduced by issue7628.
In review58481002, I ensure that empty period_ids list filter out all moves.
Author: [hidden] (risto3)
Date: 2019-01-13.09:38:27
I'm noticing since recent serious reporting problems on the 5.0 branch, notably after balancing non-deferrals.

First I'll mention the simple case from scratch:
- created a base and activate account_fr
- created company e.g. DUPONT   cur: euro   timezone: Europe/Paris
- created charts with company DUPONT and Plan Comptable (French),
      default receivable account 4111; default payable account 4011
- created fiscal years 2017 & 2018 with 12 periods and closing adjustment period
- created journal CLO for closing adjustment
- created move 1/12/17 in expense journal 
     6226 D100
     5121       C100
- created move 1/02/18 
     6226 D200
     5121       C200

in reports->general ledger  {NB:creating filter helps: "Start Balance": !0 or (Debit: !0 or Credit: !0)}
in 2017: start balance should all be zero, but they are already set
"5121"	"Comptes en monnaie nationale"	"-100.00"	"0.00"	"100.00"	"-100.00"
"6226"	"Honoraires"	"100.00"	"100.00"	"0.00"	"100.00"
in 2018: 
"5121"	"Comptes en monnaie nationale"	"-300.00"	"0.00"	"200.00"	"-300.00"
"6226"	"Honoraires"	"300.00"	"200.00"	"0.00"	"300.00"

if I then balance non deferrals for 2017 to 120/129 and look in reports GL again
2017: still problem
"129"	"Résultat de l'exercice (perte)"	"100.00"	"0.00"	"0.00"	"0.00"
"5121"	"Comptes en monnaie nationale"	"-100.00"	"0.00"	"100.00"	"-100.00"
"6226"	"Honoraires"	"0.00"	"100.00"	"0.00"	"100.00"
2018:
"129"	"Résultat de l'exercice (perte)"	"100.00"	"0.00"	"0.00"	"100.00"
"5121"	"Comptes en monnaie nationale"	"-300.00"	"0.00"	"200.00"	"-300.00"
"6226"	"Honoraires"	"200.00"	"200.00"	"0.00"	"200.00"
History
Date User Action Args
2019-02-10 23:48:28roundup-botsetmessages: + msg46912
2019-01-30 09:43:56roundup-botsetmessages: + msg46583
2019-01-30 09:43:47roundup-botsetstatus: testing -> resolved
nosy: + roundup-bot
messages: + msg46582
2019-01-17 18:27:58risto3setmessages: + msg46045
2019-01-17 18:09:22reviewbotsetnosy: + reviewbot
messages: + msg46044
2019-01-17 17:59:03cedsetstatus: unread -> testing
messages: + msg46043
keyword: + review
nosy: + ced
component: + account
reviews: 58481002
assignedto: ced
2019-01-13 11:58:36cedsetpriority: urgent -> bug
2019-01-13 09:38:28risto3create

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