OCA Financial Reports
Account Bank Statement Line Reconciliation
The wizard provides the ability to specify bank statement line when it needed. The only users from security group “Settings” can use it.
This module is for you if you work with Odoo enterprise and you messed up the bank reconcile report.
The bank reconciliation report is accessible from the hyperlink ‘Difference’ which appears on bank journals cards when the GL balance differs from the bank statement balance.
There are only 2 situation handled from field filter (from bank reconcile view) but there are more in real life:
1 - Blue lines appear if account_move_lines have these values:
statement_id = false AND payment_id = true AND account_id = current bank
-> This means that if you post a payment journal entry manually (meaning that you do not use the register payment button) the payment_id will not be populated then the payment_id will not be populated. When this happens, your entry won’t match: you are stuck and you need this module to prevent this situation.
Same issue in case of migration of payment entries with no payment_id
2 - If 1st request is not applicable then Odoo will look up for account_move_lines with:
reconcile_id = false account_id = flagged as 'Allow reconciliation" = true excluding the line in the move with the bank account.
-> This means that if you have created entries on a reconciliable account but you never reconcile it (ie: a cut-off entry or a correction) this line will appear forever in the list of possible matches -> so you may need this module to clean it up.
To use this module, you need to:
- Go to Accounting > Adviser > Journal Entries
- Select one or more Journal Entry items
- Press ‘Action > Bank reconcile report change’
- Select required value in ‘New value’ field. Leave empty if you want to set empty value.
- Press ‘Set value’
By doing this, you will create/delete the link between Journal entry and bank statement lines hence you will make corrections on the bank reconcile report which would be impossible to do through the Odoo interface.
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smash it by providing detailed and welcomed feedback.
- Odoo Community Association: Icon.
- Camptocamp SA
This module is maintained by the OCA.
OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.
To contribute to this module, please visit https://odoo-community.org.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size||File type||Python version||Upload date||Hashes|
|Filename, size odoo10_addon_account_bank_statement_line_reconciliation-10.0.1.0.0.99.dev4-py2-none-any.whl (23.4 kB)||File type Wheel||Python version py2||Upload date||Hashes View hashes|
Hashes for odoo10_addon_account_bank_statement_line_reconciliation-10.0.1.0.0.99.dev4-py2-none-any.whl