changeset 84e1993e0595 in modules/sale:5.0
details: https://hg.tryton.org/modules/sale?cmd=changeset&node=84e1993e0595
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 88913b8117e6 -r 84e1993e0595 sale_reporting.py
--- a/sale_reporting.py Tue Mar 01 19:29:54 2022 +0100
+++ b/sale_reporting.py Wed Jun 15 22:03:38 2022 +0200
@@ -79,14 +79,14 @@
condition=(sale.currency == currency_sale.currency)
& (currency_sale.start_date <= sale.sale_date)
& ((currency_sale.end_date == Null)
- | (currency_sale.end_date >= sale.sale_date))
+ | (currency_sale.end_date > sale.sale_date))
)
.join(company, condition=sale.company == company.id)
.join(currency_company,
condition=(company.currency == currency_company.currency)
& (currency_company.start_date <= sale.sale_date)
& ((currency_company.end_date == Null)
- | (currency_company.end_date >= sale.sale_date))
+ | (currency_company.end_date > sale.sale_date))
))
return from_item, tables