How to generate Cash at Bank Account with Location (seg2)

Dear Experts,

Need quick assistance to support the below business scenario.
In our current Bank Account setup, the bank account is associated with the flexfield: 11-010-14141.

When a receipt is created in AR, the accounting entries generated are as follows:
Dr. 11-101-14142 — Receipt Confirmation Account
Cr. 11-101-12101 — Receivable Account

Once the receipt is cleared in the bank, the system generates the following accounting entries:
Dr. 11-010-14141 — Cash at Bank Account
Cr. 11-101-14142 — Receipt Confirmation Account
However, the business requirement is to generate the Cash at Bank account as:
11-101-14141, where Segment 2 (101) should be inherited from the Receipt Confirmation Account.