Merge lp:~julie-w/unifield-server/US-9813 into lp:unifield-server

[jftempo]

Unmerged revisions

6201. By Julie Nuguet on 2022-03-24

US-9813 [FIX] Journal inactivation: fix the check on the last register's balance (make sure the register checked is the last one)

6200. By jftempo on 2022-03-23

Release UF25.0dev

6199. By jftempo on 2022-03-22

US-9671 [FIX] Pick / PPL import: prevent modification on closed documents
   + prevent modifications of lines/qty/RT on OUT/Pick coming from workflow

lp:~dorian-kemps/unifield-server/US-9671

6198. By jftempo on 2022-03-22

US-9567 [IMP] Financing Contract: perfomance on quad reporting lines and account only display

lp:~jfb-tempo-consulting/unifield-server/US-9567

6197. By jftempo on 2022-03-22

US-9736 [IMP] Users: added filter to see non-synchronized users

lp:~dorian-kemps/unifield-server/US-9736

6196. By jftempo on 2022-03-22

US-6475 [IMP] PO: VAT corner

lp:~jfb-tempo-consulting/unifield-server/US-6475

6195. By jftempo on 2022-03-21

US-9604 [IMP] FO / PO perf: use sql join between lines and document, sql indexes, use sql instead of browse

lp:~jfb-tempo-consulting/unifield-server/po-confirmation

6194. By jftempo on 2022-03-09

Release UF24.0

6193. By jftempo on 2022-03-04

[FIX] Claim: forward to supplier in French

6192. By jftempo on 2022-03-03

Release UF24.0rc3

=== modified file 'bin/addons/account/account.py'
--- bin/addons/account/account.py	2022-02-10 15:35:09 +0000
+++ bin/addons/account/account.py	2022-03-29 15:45:41 +0000
@@ -822,8 +822,17 @@
                                              _("Please post all the manual Journal Entries on the journal %s before inactivating it.") %
                                              journal.code)
                     if journal.type in ['bank', 'cash']:
-                        last_reg_id = reg_obj.search(cr, uid, [('journal_id', '=', journal.id)],
-                                                     order='period_start_date DESC', limit=1, context=context)
+                        last_reg_sql = """
+                            SELECT reg.id
+                            FROM account_bank_statement reg
+                            INNER JOIN account_period p ON reg.period_id = p.id
+                            INNER JOIN account_journal j ON reg.journal_id = j.id
+                            WHERE j.id = %s
+                            ORDER BY p.date_start DESC LIMIT 1
+                        """
+                        cr.execute(last_reg_sql, (journal.id,))
+                        last_reg_id = cr.fetchone()
+
                         if last_reg_id:
                             balance_end = reg_obj.browse(cr, uid, last_reg_id[0], fields_to_fetch=['balance_end']).balance_end or 0.0
                             if abs(balance_end) > 10**-3:

=== modified file 'bin/addons/account/account_bank_statement.py'
--- bin/addons/account/account_bank_statement.py	2022-01-21 15:35:54 +0000
+++ bin/addons/account/account_bank_statement.py	2022-03-29 15:45:41 +0000
@@ -129,8 +129,6 @@
         'date': fields.date('Date', required=True, states={'confirm': [('readonly', True)]}),
         'journal_id': fields.many2one('account.journal', 'Journal', required=True, readonly=True),
         'period_id': fields.many2one('account.period', 'Period', required=True),
-        'period_start_date': fields.related('period_id', 'date_start', type='date', string='Period Start Date',
-                                            store=False, write_relate=False),
         'balance_start': fields.float('Starting Balance', digits_compute=dp.get_precision('Account'),
                                       states={'confirm':[('readonly',True)]}),
         'balance_end_real': fields.float('Closing Balance', digits_compute=dp.get_precision('Account'), states={'confirm':[('readonly', True)]},

=== modified file 'bin/addons/msf_profile/i18n/fr_MF.po'
--- bin/addons/msf_profile/i18n/fr_MF.po	2022-03-22 10:40:31 +0000
+++ bin/addons/msf_profile/i18n/fr_MF.po	2022-03-29 15:45:41 +0000
@@ -113656,11 +113656,6 @@
 msgstr "Statut du journal"
 
 #. module: account
-#: field:account.bank.statement,period_start_date:0
-msgid "Period Start Date"
-msgstr "Date de Début de la Période"
-
-#. module: account
 #: code:addons/account/account.py:798
 #, python-format
 msgid "Please close the registers linked to the journal %s before inactivating it."