Splitting the receivable account based on unearned revenue account using SLA in R12
We have new requirement from our business on splitting the receivable account based on unearned revenue account in the SLA.
For eg:
If there are two unearned revenue lines in specific invoice with different GL Code Combination (having different Geography segment or trading partner, gold id etc) then the receivable amount should be able to split into two accounting lines to reflect two different Geography segment.
RECEIVABLE S065.1129107000.S024.000000.000.0000000000.OGTX95.OGS21B.P.000000000.000000
RECEIVABLE S065.1129107000.S024.000000.000.0000000000.OGTX95.OGS314.P.000000000.000000
UNEARNED REVENUE S065.5110201000.0000.OG1012.000.0000000000.OGTX95.OGS21B.P.000000000.000000
UNEARNED REVENUE S065.5110201000.0000.OG1012.000.0000000000.OGTX95.OGS314.P.000000000.000000
Can anyone please help me here.