Incorrect Offsetting Account in FAGLL03

We have an issue on the offsetting account field in FAGLL03, the note 1034354 - FAGLL03: Display of offsetting account information has already been implemented but some values are incorrect.

The issue occurs when there are multiple line items which uses different accounts.

Sample: current logic will make account C as default offsetting account

Debit - Account A - value 100

Credit - Account X - value -100

Debit - Account B - value 200

Credit - Account X - value -200

Debit - Account C - value 300

Credit - Account X - value -300

In FAGLL03 - the offsetting account for account X is set to account C since based on note 1034354 it will use the account with the highest value.

So, currently we're trying correct this issue but we have encountered scenarios that makes it difficult to get the correct offsetting account.

1. Multiple line items with same amount but with different account numbers (tried using assignment and text field but it is blank)

Sample: if the value is the same as 100, the current logic will use the first account encountered - account A will be defaulted

Debit - Account A - value 100

Credit - Account X - value -100

Debit - Account B - value 100

Credit - Account X - value -100

Debit - Account C - value 100

Credit - Account X - value -100

2. Multiple line items that offsets to only 1 line item.

Sample: which account should be the offsetting account of X? currently the first account (A) will be defaulted as offsetting account just like in scenario 1.

Debit - Account A - value 100

Debit - Account B - value 100

Debit - Account C - value 100

Credit - Account X - value -300

Thanks in advance for those who will answer on my inquiry