changeset e076958f9f42 in modules/sale:default
details: https://hg.tryton.org/modules/sale?cmd=changeset&node=e076958f9f42
description:
Join with a unique currency rate
issue11255
review435291004
diffstat:
sale_reporting.py | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diffs (20 lines):
diff -r 4d7d93d2d546 -r e076958f9f42 sale_reporting.py
--- a/sale_reporting.py Tue May 31 23:57:32 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
