changeset b9ebf0ef08f0 in modules/sale:6.4
details: https://hg.tryton.org/modules/sale?cmd=changeset&node=b9ebf0ef08f0
description:
Join with a unique currency rate
issue11255
review435291004
(grafted from e076958f9f429733a0636d892fb505800bc99f85)
diffstat:
sale_reporting.py | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (20 lines):
diff -r eb260fb0ef2e -r b9ebf0ef08f0 sale_reporting.py
--- a/sale_reporting.py Fri Jun 03 19:16:50 2022 +0200
+++ b/sale_reporting.py Wed Jun 15 22:03:38 2022 +0200
@@ -112,14 +112,14 @@
condition=(line.currency == currency_sale.currency)
& (currency_sale.start_date <= line.date)
& ((currency_sale.end_date == Null)
- | (currency_sale.end_date >= line.date))
+ | (currency_sale.end_date > line.date))
)
.join(company, condition=line.company == company.id)
.join(currency_company,
condition=(company.currency == currency_company.currency)
& (currency_company.start_date <= line.date)
& ((currency_company.end_date == Null)
- | (currency_company.end_date >= line.date))
+ | (currency_company.end_date > line.date))
))
return from_item, tables, withs
