This update ensures that mandatory analytic distribution requirements are properly enforced when reconciling bank statements. Previously, users could bypass these requirements during reconciliation, which could lead to incomplete financial records. The fix also resolves an issue where the reconciliation interface would become unresponsive if an error occurred during the process.

Mandatory Analytic Plans should be mandatory. This was not checked when reconciling a bank statement. This commit adds a check to ensure that the analytic distribution is correct when reconciling a bank statement.

Task: 3864633

The aged payable accounting report has been optimized to load significantly faster. Previously, the system was processing unnecessary data that was filtered out later, causing timeouts on large databases. The fix streamlines the data retrieval process, reducing load times from over 15 minutes to just seconds for large companies.

# Issue:

The query for constructing the aged_payable accounting report takes too long to load.

# Analysis:

When a database has lots of companies, it's likely to have a huge number of rows in the account_partial_reconcile table. Currently, the entire account_partial_reconcile table is being iterated in the report generation, only to be filtered out later on in the query. This superfluous computation is extremely inefficient and it could be easily avoided by correctly using LATERAL JOIN syntax to make use of the filters applied later on.
![image](https://github.com/odoo/enterprise/assets/44981290/b5d8874c-f845-4483-b6d9-fcd96cccd91a)

# Fix:

Use the correct condition inside the lateral join to filter on account_move_lines that are already filtered later on.

# Benchmark:
### Report loading time
| # account partial reconcile lines | # account move lines | Company size | Before |  After |
| --- | ------ | ------ | ------| ----- | 
| 588503 | 2339215 | Large | 15m+ (timeout) | ~14.02s |
| 5761 | 27635 | Medium | 15m+ (timeout) |  ~3s  |
| 11 | 1513 | Small | 7.69 | ~1.6s |
#### Total number of account partial reconcile:
3279438
#### Total number of account move lines:
10688953

# Related ticket: 
opw-3819017

Forward-Port-Of: odoo/enterprise#61036

This improvement enhances the Latin American check payment module to support handling multiple checks within a single payment transaction. Users can now edit and manage multiple checks more efficiently when processing payments, streamlining the payment workflow for businesses operating in Latin American markets.

Description of the issue/feature this PR addresses:

Current behavior before PR:

Desired behavior after PR is merged:




---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr

This update adds automated testing for the drag-and-drop functionality when rearranging website columns on mobile devices. Following a previous improvement to support mobile ordering, this change ensures the feature works correctly by adding a test tour that validates the drag-and-drop flow for mobile-ordered columns.

Commit [1] improved the drag and drop to also consider elements having a mobile order.

As a follow-up, this commit adds a tour testing the drag and drop flow when moving mobile ordered columns.

[1]: https://github.com/odoo/odoo/commit/7b27385dba36c2e741d96e76ad5d847d09f2b084

task-3744643
related to opw-3697962

The internal note feature, previously limited to restaurant POS systems, is now available for all shop types. This improvement allows POS users to add internal notes to order lines in any shop configuration, making the feature more widely accessible and useful across different business models.

Allow pos users to have the "internal note" button available even in non-restaurant shops.

Task-ID: 3878947

**Before:** Internal note button is only for restaurant.

<img width="1800" alt="Screenshot 2024-04-22 at 15 56 44" src="https://github.com/odoo/odoo/assets/3245568/b923a1f5-e7fe-4a8a-b624-c0c31135c4fb">

**After:**

<img width="1800" alt="Screenshot 2024-04-22 at 15 55 28" src="https://github.com/odoo/odoo/assets/3245568/fc82f296-7598-46b7-bbe0-0eb199872515">