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 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 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