changeset bd73e46ad032 in modules/stock:6.4 details: https://hg.tryton.org/modules/stock?cmd=changeset&node=bd73e46ad032 description: Join with a unique currency rate
issue11255 review435291004 (grafted from c2f056739e4856f2530b491653dfe8e5a8cb0461) diffstat: stock_reporting_margin.py | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diffs (21 lines): diff -r 790b6a51684a -r bd73e46ad032 stock_reporting_margin.py --- a/stock_reporting_margin.py Wed Jun 15 09:22:16 2022 +0200 +++ b/stock_reporting_margin.py Wed Jun 15 22:03:38 2022 +0200 @@ -90,7 +90,7 @@ condition=(move.currency == currency_rate.currency) & (currency_rate.start_date <= move.effective_date) & ((currency_rate.end_date == Null) - | (currency_rate.end_date >= move.effective_date)) + | (currency_rate.end_date > move.effective_date)) ) .join(company, condition=move.company == company.id) @@ -100,7 +100,7 @@ condition=(company.currency == currency_rate_company.currency) & (currency_rate_company.start_date <= move.effective_date) & ((currency_rate_company.end_date == Null) - | (currency_rate_company.end_date >= move.effective_date)) + | (currency_rate_company.end_date > move.effective_date)) ) .join(from_location, condition=(move.from_location == from_location.id))