AR: SLA Customization to split the Revenue line to multiple based on percentage

Summary:

We have a specific requirement to split a revenue line into two separate revenue lines, with an 80/20 split, when the revenue is recognized over 3, 6, 9, or 12 months using the Invoicing Rule - In-advance. (Based on the memo line selection)

Example:

Revenue schedule 3 months

Month 1:

Receivables- 300 Dr

Unearned Revenue- 200 Cr

Revenue line 1- 80 Cr

Revenue line 2 - 20 Cr

Month 2:

Unearned Revenue- 100 Dr

Revenue line 1- 80 Cr

Revenue line 2- 20 Cr

Month 3:

Unearned Revenue- 100 Dr

Revenue line 1- 80 Cr

Revenue line 2- 20 Cr

Unfortunately, we were not able to do the revenue split even after writing the custom formulas and assigning it to the JLR