[tryton-commits] changeset in modules/sale:6.2 Join with a unique currency rate

[Cédric Krier]

changeset e13105a9a0cc in modules/sale:6.2
details: https://hg.tryton.org/modules/sale?cmd=changeset&node=e13105a9a0cc
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 105f796bbfdf -r e13105a9a0cc sale_reporting.py
--- a/sale_reporting.py Fri Jun 03 19:17:50 2022 +0200
+++ b/sale_reporting.py Wed Jun 15 22:03:38 2022 +0200
@@ -81,14 +81,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