diff options
| author | qdp-odoo <qdp@odoo.com> | 2017-03-29 11:56:42 +0200 |
|---|---|---|
| committer | qdp-odoo <qdp@odoo.com> | 2017-03-29 13:55:14 +0200 |
| commit | 26938da071e77b853d09d512b4812dd2ba645afb (patch) | |
| tree | 0c13978b4ae6a6a73557a90d914fef1dd0145708 /addons/web/static/src/js/views/basic/basic_controller.js | |
| parent | 79975f7cec897887408d5921139399a3c3467d5e (diff) | |
[FIX] account: fix statement_line_id on bank statement processing.
Since ee2c76a43111acdf9b1ccfc132d1a8a97912e55d, a new field 'statement_line_id' has been added on account.move.line object and the field 'statement_id' became a related... but this statement_line_id on the bank account aml was, by mistake, not set. That created aml that were wrongly appearing in blue in the reconciliation widget.
If this error occured in a DB, the following SQL query can fix it:
$ UPDATE account_move_line l SET statement_line_id = s.id FROM account_bank_statement_line s
WHERE l.statement_line_id IS NULL
AND l.statement_id = s.statement_id
AND l.name = s.name
AND coalesce(s.partner_id, 0) = coalesce(l.partner_id, 0);
Diffstat (limited to 'addons/web/static/src/js/views/basic/basic_controller.js')
0 files changed, 0 insertions, 0 deletions
