This update resolves a potential issue where tracking numbers in the POS Self Order module could collide. Because we couldn't add new fields directly to the main Odoo version, a simple method was used to generate unique tracking numbers by adding a random letter prefix. This ensures order tracking remains accurate and reliable.

Since we cannot add fields in stable we use a little trick to avoid collisions in tracking numbers for POS Self Order module.

We do a modulo operation on the ID of the PoS config to select a random letter from A-Z and prepend it to the tracking number.

Forward-Port-Of: odoo/odoo#245476

This update resolves an issue where gift cards were being printed repeatedly during point-of-sale transactions. Now, gift cards are only printed once when initially created, streamlining the process and preventing unnecessary printing. This improves efficiency and reduces potential printing costs.

*: pos_loyalty

Gift card are now printed only one time at the creation not after each use.

Forward-Port-Of: odoo/odoo#244089

This update expands Odoo's language support to include Spanish, recognizing the significant Spanish-speaking population. This enhancement improves usability for a wider range of customers and aligns with Odoo's commitment to global accessibility. The change focuses on adding Spanish translations within the l10n_us module.

The official language is English, but Spanish is spoken by ~41 million.

task-5247124

Forward-Port-Of: odoo/enterprise#105494
Forward-Port-Of: odoo/enterprise#105246

This update resolves an issue in Odoo's Web Studio where it could incorrectly link fields to non-searchable data types. This caused warnings and errors, particularly in business settings. The change ensures that Web Studio only creates relational fields with searchable data, improving stability and reliability.

Before this commit studio allowed to make a related field with a non-searchable field (ie standard computed fields) in the the chain.

This triggered a warning at creation (at fields.py:resolve_depends) and errors when using in a business setting.

After this commit, the filter to build the relational field is modified to take into account this.

opw-5436158

Forward-Port-Of: odoo/enterprise#105607

This update ensures that LNA (a key technology) is consistently used for IoT devices across all Point of Sale systems, including Kiosks. Previously, LNA was only active in the POS, limiting functionality. This change improves the overall performance and reliability of IoT-enabled Kiosk POS operations.

Before this commit, LNA was being used for IoT devices in the POS but not in the Kiosk when `point_of_sale.use_lna` was enabled.

After this commit, LNA will also be enabled for IoT devices in the Kiosk.

task-5874663

Forward-Port-Of: odoo/enterprise#105520
Forward-Port-Of: odoo/enterprise#105460

This update enables users to create returns for previously archived accounting periods without needing to reactivate or overwrite existing archived returns. This provides greater flexibility in managing returns and simplifies the reporting process. A new test case has been added to ensure the functionality works as expected.

Archived returns are ignored when manually creating returns, allowing a new return to be created for the same period without reactivating or overwriting the archived one.
Also a test case has been added for the same

task-5440965

Forward-Port-Of: odoo/enterprise#102928

This update fixes a visual inconsistency in the Helpdesk dashboard by extending the conditional formatting and aligning border styles to match other Odoo dashboards. This ensures a more uniform and professional appearance for users accessing the Helpdesk data.

## Description

- The Top Customers pivot shows 10 rows, but the conditional format covered only 9. Extend the CF range so the last row is formatted.

- Adjust border ranges so the helpdesk dashboard matches the styling used in other dashboards.

Task: [5448434](https://www.odoo.com/odoo/project/2328/tasks/5448434)

Forward-Port-Of: odoo/enterprise#103793
Forward-Port-Of: odoo/enterprise#103019

This update resolves a technical issue that could cause errors when generating Peruvian VAT (PE) reports. The fix ensures that the system handles cases where a required text field is missing, preventing a traceback and ensuring accurate report generation. This improves the reliability of the odoo Enterprise module for businesses operating in Peru.

Forward-Port-Of: odoo/enterprise#105462

This update addresses a potential issue where deleted records in Odoo could still be accessed, leading to errors. The fix ensures that related records are checked for existence before accessing data from deleted records, primarily due to how cascade deletions are handled in the database. This enhances data integrity and stability.

In order to be defensive we have to check records linked to messages, notifications or activities exist before checking related information like display_name, or even to skip them in various flows.

This happens notably due to DB-level cascade deletion that does not remove side records linked through (model, res_id) pairs.

It implies some additional exist queries.

Task-5138556

Forward-Port-Of: odoo/enterprise#104538
Forward-Port-Of: odoo/enterprise#101185

This update adapts the French FEC import process to recent changes in the Odoo community. The system now streams data from the FEC file instead of using a previous field, ensuring compatibility and improved efficiency. This change supports ongoing compliance with French accounting regulations.

This commit aims to adapt the usage of 'account.fr.fec' to the changes made in community.

In particular `fec_data` field is not used any more. and we use `_get_fec_stream` to stream the content of the file.

task-5404142

Forward-Port-Of: odoo/enterprise#102783