changeset becc2c65395d in modules/stock:default
details: https://hg.tryton.org/modules/stock?cmd=changeset&node=becc2c65395d
description:
Use left join on currency rate for margin report
issue11711
review421731003
diffstat:
stock_reporting_margin.py | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r c516c469500c -r becc2c65395d stock_reporting_margin.py
--- a/stock_reporting_margin.py Tue Sep 27 00:29:24 2022 +0200
+++ b/stock_reporting_margin.py Wed Sep 28 09:47:03 2022 +0200
@@ -86,7 +86,7 @@
query=Currency.currency_rate_sql())
from_item = (move
- .join(currency_rate,
+ .join(currency_rate, type_='LEFT',
condition=(move.currency == currency_rate.currency)
& (currency_rate.start_date <= move.effective_date)
& ((currency_rate.end_date == Null)
