Message 61401

Author
risto3
Date
2020-10-25.17:20:50
Message id
61401

Content

unfortunately, we tried to use this on a copy of our production base to generate auxiliaire GL & balance reports but it seems they're not yet implemented (nor is l10n yet)... cannot select multiple accounts GL accounts (perhaps that's TBD too)

But there is a problem with filters once in the account parties screen to filter out all the zero records.
(what could these possibly mean in an auxiliairy report anyway?)

With the following filter line : "Start Balance": !0 or Debit: !0 or Credit: !0

Traceback (most recent call last):
  File "/opt/trytond/trytond/protocols/dispatcher.py", line 181, in _dispatch
    result = rpc.result(meth(*c_args, **c_kwargs))
  File "/opt/trytond/trytond/model/modelsql.py", line 1268, in search
    tables, expression = cls.search_domain(domain)
  File "/opt/trytond/trytond/model/modelsql.py", line 1454, in search_domain
    expression = convert(domain)
  File "/opt/trytond/trytond/model/modelsql.py", line 1451, in convert
    return And((convert(d) for d in (
  File "/opt/trytond/trytond/model/modelsql.py", line 1451, in <genexpr>
    return And((convert(d) for d in (
  File "/opt/trytond/trytond/model/modelsql.py", line 1451, in convert
    return And((convert(d) for d in (
  File "/opt/trytond/trytond/model/modelsql.py", line 1451, in <genexpr>
    return And((convert(d) for d in (
  File "/opt/trytond/trytond/model/modelsql.py", line 1449, in convert
    return Or((convert(d) for d in domain[1:]))
  File "/opt/trytond/trytond/model/modelsql.py", line 1449, in <genexpr>
    return Or((convert(d) for d in domain[1:]))
  File "/opt/trytond/trytond/model/modelsql.py", line 1442, in convert
    expression = field.convert_domain(domain, tables, cls)
  File "/opt/trytond/trytond/model/fields/function.py", line 79, in convert_domain
    return getattr(Model, self.searcher)(self.name, domain)
  File "/opt/trytond/trytond/modules/account/account.py", line 1719, in search_account
    ids = [a.id for a in accounts
  File "/opt/trytond/trytond/modules/account/account.py", line 1720, in <listcomp>
    if operator_(getattr(a, fname), operand)]
  File "/opt/trytond/trytond/model/fields/function.py", line 130, in __get__
    return super().__get__(inst, cls)
  File "/opt/trytond/trytond/model/fields/field.py", line 339, in __get__
    return inst.__getattr__(self.name)
  File "/opt/trytond/trytond/model/modelstorage.py", line 1585, in __getattr__
    read_data = self.read(list(index.keys()), list(ffields.keys()))
  File "/opt/trytond/trytond/model/modelsql.py", line 859, in read
    getter_results = field.get(ids, cls, field_list, values=result)
  File "/opt/trytond/trytond/model/fields/function.py", line 106, in get
    return dict((name, call(name)) for name in names)
  File "/opt/trytond/trytond/model/fields/function.py", line 106, in <genexpr>
    return dict((name, call(name)) for name in names)
  File "/opt/trytond/trytond/model/fields/function.py", line 99, in call
    return method(records, name)
  File "/opt/trytond/trytond/modules/account/account.py", line 1358, in get_balance
    return Account._cumulate(
  File "/opt/trytond/trytond/modules/account/account.py", line 1034, in _cumulate
    previous_result = func(accounts, names)
  File "/opt/trytond/trytond/modules/account/account.py", line 1357, in func
    return {names[0]: cls.get_balance(records, names[0])}
  File "/opt/trytond/trytond/modules/account/account.py", line 1344, in get_balance
    id_ = account_party2id[(account_id, party_id)]
KeyError: (588, 713)
History
Date User Action Args
2020-10-25 17:20:50risto3setmessageid: <1603642850.4238517.OB7HFRMG2ZI2JRVP.issue9762@tryton.org>
2020-10-25 17:20:50risto3linkissue9762 messages
2020-10-25 17:20:50risto3create

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