### Steps to reproduce the issue:

1. Create two Companies, one in EUR, the other in USD
2. In EUR Company, create two Invoices with the following settings:
    - Total price of 1000
    - Invoice date: today and one month ago
    - You must be able to isolate them using Partner Ledger filters (not date)
3. In USD Company, add EUR Rates as follows:
    - Today: 1USD = 1EUR
    - One month ago: 1USD = 0.9EUR
4. In USD Company, open General Ledger and isolate the Invoices
5. First, set the timeframe from beginning last month to end of this month
6. The Invoice of last month is using the current rate, with an amount of 1000$
7. Second, set the timeframe to the current month only
8. The Initial Balance is using the previous rate, with an amount of 1111.11$

### Explanation:

The initial balance is the balance of the company before the start of the currently reviewed timeframe. To calculate it, we must update the options to target the time before the current timeframe. Since we retrieve the rate used for this calculation using the updated options, we use the last rate before the current timeframe instead of the rate used in the current timeframe.

### Fix reasoning:

Since every amount must be calculated using the current rate, we will retrieve it using the main options and not the updated ones.

opw-4299153

Original task: 4288080
Related PR: 187476

# Background

In Mexico, all accounts need to follow a pattern XXX.XX.XX or XXX.XX.XXX where additionally the first five digits must belong to a list of prefixes published by the SAT.

At the moment, several accounts created by default don't match the CoA pattern:

- 999000001 Cash Difference Gain
- 999000002 Cash Difference Loss.
- 999300000 Cash Discount Loss
- 999400000 Cash Discount Gain
- 999999 Undistributed Profits/Losses

This issue is related to the Trial Balance Report (download COA SAT) for Mexican localization when some accounts are not correctly configured. For users that request the COA SAT XML file for the first time no warning/error is thrown but the client will face some errors when uploading the file to the SAT because the accounts are not configured properly; When the COA SAT XML file has already been downloaded then a warning error blocks the action.

# Fix

Given correct codes to the existing accounts and modifying data for some records:

---
| Account                             | New code  | New name                                                                     | New Account type |    
|-------------------------------------|-----------|------------------------------------------------------------------------------|------------------|
| 999000001 Cash Difference Gain      | 403.01.01 | Other Income                                                                 |  ~               |
| 999000002 Cash Difference Loss      | 601.84.02 |  ~                                                                           |  ~               |
| 999300000 Cash Discount Loss        | 402.01.01 | Returns, discounts or bonuses over sales and/or services at the general rate | other income     |
| 999400000 Cash Discount Gain        | 503.01.01 | Returns, discounts or bonuses over purchases                                 |  ~               |
| 999999 Undistributed Profits/Losses | 305.01.01 | Uncut Result                                                                 |  ~               |

---

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

**Issue:**
Accountants cannot create products through Customer Invoice or Vendor Bill product lines.

![image](https://github.com/user-attachments/assets/fde7d8de-354f-46fa-861d-bfe55dcabfbd)

**Expected:**
Accountants should be allowed to manage the products database.

**Steps to reproduce:**
- Activate Accounting app;
- Configure a branch to the company;
- Create a user with an accounting `Accounting` role and set the branch company as only entry in Allowed Companies and as Default Company;

![Capture d’écran 2024-12-10 à 18 04 55](https://github.com/user-attachments/assets/bc0fae3f-cff4-4e73-9eb9-f86d5285ba6d)

- Log in as that new user;
- Try create a new product through a Customer Invoice or a Vendor Bill.

**Cause:**
The `Accountants` role itself has no right on products.

**Fix:**
Add a new access right on `product_template` for group `group_account_manager`.

![Capture d’écran 2024-12-10 à 18 14 38](https://github.com/user-attachments/assets/8902ceee-6b97-4522-8505-3f72a0260226)


opw-4293151