general ledger account parties problems
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)