changeset 9e33cce53628 in modules/sale:6.0
details: https://hg.tryton.org/modules/sale?cmd=changeset&node=9e33cce53628
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 d2d3746072c5 -r 9e33cce53628 sale_reporting.py
--- a/sale_reporting.py Fri Jun 03 19:19:45 2022 +0200
+++ b/sale_reporting.py Wed Jun 15 22:03:38 2022 +0200
@@ -84,14 +84,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, withs