GL Chart of accounts mapping and SLA Account rules

Summary:

Hi Experts,

Need your help or suggestion for the below design requirement.

Currently customer has configured Primary and Secondary ledgers with below options

Primary ledger => Global COA (10 segments)
Secondary Ledger => Local COA (10 segments)

The structure of primary and secondary ledger COA is same and the only difference is the natural accounts segment where primary contains Global COA Natural accounts and secondary contains Local COA Natural accounts.

We have already created COA Mapping between Primary (Global COA) to Secondary (Local COA). However, we have one to many scenarios which cannot be handled in GL COA Mapping as we need to use some source values to post one Global COA Natural account to different Local COA Natural Account. For E.g.,