OCA / account-reconcile

Odoo account reconciliation modules (statements, data completion...)
https://odoo-community.org/psc-teams/banking-10
GNU Affero General Public License v3.0
128 stars 371 forks source link

Bank Statement reports have all Zero values - Odoo11 CE #331

Closed niyshah closed 2 years ago

niyshah commented 3 years ago

Bank Statement reports have all Zero values except for Initial Balance in the Detail Report.

Recently upgraded client to Odoo11 CE. The bank reconciliation process works fine. It's just that the reports are blank in terms of amount. The detail report has every item, but zero values.

Install version of addon - 11.0.1.0.0

Screenshot_20200814_112440 Screenshot_20200814_112413

niyshah commented 3 years ago

Update - Removing the field options displays values.

<span t-field="o.starting_balance" t-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: o.account_id.currency_id}"/>

to

<span t-field="o.starting_balance" />

Python is not my strength, so can't debug further. The currency in use is AUD. It appears the formatting function is failing for some reason.

niyshah commented 3 years ago

By updating the formatting lines from

t-options='{"widget": "monetary", "display_currency": o.account_id.currency_id}'

to

t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"

The reports now produce valid results. Updated reports attached report_bank_statement_summary.txt report_bank_statement_detail.txt

pedrobaeza commented 3 years ago

Which module?

niyshah commented 3 years ago

Apologies, just noticed that, the account_banking_reconciliation module

pedrobaeza commented 3 years ago

@max3903 this one seems to be yours

github-actions[bot] commented 2 years ago

There hasn't been any activity on this issue in the past 6 months, so it has been marked as stale and it will be closed automatically if no further activity occurs in the next 30 days. If you want this issue to never become stale, please ask a PSC member to apply the "no stale" label.