The accounting return validation checks have been adjusted for VAT returns and Belgian partner VAT listings. This helps businesses receive more accurate warnings or errors before filing, reducing the risk of incorrect tax submissions.

Add, update, or delete some checks done on the accounting returns for the vat return and the partner vat listing reports.

task-4627315

This change updates internal Spanish reporting tests so they no longer rely on demo data, which is not allowed in this context. It helps keep automated checks compliant and reliable without changing day-to-day user functionality.

This is illegal.

https://runbot.odoo.com/odoo/error/161658

This change makes the Indian payroll test setup create its own department data instead of depending on optional sample records. It helps keep automated checks reliable in standard test configurations without changing payroll features for users.

`hr.dep_rd` is demo data, it's not available anymore during tests in the default configuration. So replace it by creating a department on the fly. And remove the resolution of `employee_al` which is also demo data *and* seems unused.

While at it, nuke a bunch of instance variables which don't seem used outside of `setUp`.

https://runbot.odoo.com/odoo/error/161648

This update fixes an internal test setup so Amazon marketplace-related tests run with the required sales administrator access. It helps keep automated validation reliable for Amazon sales integrations without changing day-to-day user behavior.

Interaction with the amazon marketplace models requires sales admin access. Furthermore, these accesses are also necessary during the `l10n_es_sale_amazon` tests (which use this setup), so adding then removing the group for the setup or locally using `sudo` doesn't seem like a great option.

https://runbot.odoo.com/odoo/error/163666

The VAT return draft-check now focuses only on customer invoices and vendor bills. This prevents unrelated miscellaneous journal entries from blocking VAT return preparation, reducing false warnings for accounting teams.

In the VAT report return, we check that there are no draft moves in the period. However, we only want customer invoices and bills, MISC entries should not be included in the check.

task-4627315

Spreadsheet pivot tables now generate DATE formulas without extra spaces before the day and month values. This prevents formatting issues and makes generated spreadsheet formulas cleaner and more reliable for users.

Removed extra spaces in front of the day and month in DATE function.

Task: 4725023

Appointment pages with no available staff or resources now show the unavailable-slot message only once. This avoids a confusing duplicate message for visitors trying to book an appointment.

Reproduce:
Check the front page of an appointment type with no resources or staff users.

This commit avoids duplicating the ‘No slot’ message on the front page of appointment types for which there is no slot available.

Task-4750234