Best practice to change and split the revenue account in AR accounted invoice

Summary:

Our client has a requirement to change the revenue account generated for an AR invoice and split the revenue amount across multiple revenue accounts.

For example, an invoice currently has the following accounting:

• Revenue account: 4000-****
• Revenue amount: 10,000

The business requirement is to reallocate this amount as follows:

• 4100-****: 4,000
• 4200-****: 3,500
• 4300-****: 2,500

The total revenue remains unchanged at 10,000. Only the revenue account distribution needs to be changed.

The invoice has already been accounted.

We are aware that in Fusion Receivables, the revenue account cannot simply be modified after the transaction has been accounted. We are therefore looking for a standard functionality or recommended approach to