There should to be an option to output only unreconciled entries in the general ledger, which upon closing the fiscal year will be primarily for the non-reconciled accounts payables/receivables deferred to N+1, although not limited to these.
Also, it would be useful to have as well a report of the auxiliary general ledger which could output either or both clients and suppliers or all third parties.
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Child items
0
No child items are currently assigned. Use child items to break down this issue into smaller parts.
Linked items
0
Link issues together to show that they're related.
Learn more.
As part of revision/control/audit, and subsequently for archival,
it is usage in France (at least for many/most certified accountants and auditors) to have complete general ledgers (reconciled and non-reconciled entries) as well as only non-reconciled entries (which is hugely collapsed as hundreds (even thousands) of reconciled move lines are eliminated.
It is absolutely not a question of balance as that gives no detail.
Cédric Krieradded 1 deleted label and removed 1 deleted label
In accounting, reconciliation.date needs to be taken in account.
For example, If a movement line from 2019 is reconciled with a payment in 2020, then in a view limited to 2019 the line is not yet reconciled (such as used in the FEC).
What we've been using now for quite a while is something like:
diff -r 526872f539fa -r 115433988fc5 account.py--- a/account.py Sun Dec 15 09:20:28 2019 +0100+++ b/account.py Sat Mar 31 09:13:59 2018 +0200@@ -1928,6 +1928,7 @@ 'invisible': ~Eval('party_required', False), }, depends=['party_required'])+ reconciliation = fields.Char('Reconciliation') party_required = fields.Boolean('Party Required') company = fields.Many2One('company.company', 'Company') debit = fields.Numeric('Debit',@@ -1960,16 +1961,20 @@ @classmethod def table_query(cls): pool = Pool()+ FiscalYear = pool.get('account.fiscalyear') Line = pool.get('account.move.line') Move = pool.get('account.move') LedgerAccount = pool.get('account.general_ledger.account') Account = pool.get('account.account')+ Period = pool.get('account.period')+ Reconciliation = pool.get('account.move.reconciliation') transaction = Transaction() database = transaction.database context = transaction.context line = Line.__table__() move = Move.__table__() account = Account.__table__()+ reconciliation = Reconciliation.__table__() columns = [] for fname, field in cls._fields.items(): if hasattr(field, 'set'):@@ -1989,6 +1994,8 @@ column = Column(move, 'description').as_(fname) elif fname == 'party_required': column = Column(account, 'party_required').as_(fname)+ elif fname == 'reconciliation':+ column = Column(reconciliation, 'name').as_(fname) elif (not field_line or fname == 'state' or isinstance(field_line, fields.Function)):@@ -2001,9 +2008,23 @@ period_ids = list(end_period_ids.difference(start_period_ids)) with Transaction().set_context(periods=period_ids): line_query, fiscalyear_ids = Line.query_get(line)+ # reconciliation date précedence is period's end_date+ # else by default fiscalyear's end_date+ # unless overridden by a 'to_date'+ if context.get('to_date'):+ end_date = context.get('to_date')+ elif context.get('end_period'):+ end_period, = Period.browse([context.get('end_period')])+ end_date = end_period.end_date+ else:+ fiscalyear, = FiscalYear.browse([context.get('fiscalyear')])+ end_date = fiscalyear.end_date return line.join(move, condition=line.move == move.id ).join(account, condition=line.account == account.id- ).select(*columns, where=line_query)+ ).join(reconciliation, 'LEFT',+ condition=(line.reconciliation == reconciliation.id)+ & (reconciliation.date <= end_date)+ ).select(*columns, where=line_query) def get_party_required(self, name): return self.account.party_required
This allows things to work in account plan (where multiple fiscal years can be displayed) as well as GL reports where only a single fiscal year is selected.
There may certainly be a better way to do it, though.
? but a filter will remove records, not display them as not [yet] reconciled, no?
That is, there are [at least] two frequent use cases:
1 - all records with accounting reconciliation status
2 - only unreconciled records (with begin balance, and amount movements reconciled entries)
I don't believe either of these can be done with a simple filter.
If this is not the case, please give real world example.