Revenue Splitting in AR

[aanchan_001]

Hi

We want to split the revenue account in AR , after receipts are created into three revenue account. How can we do the same in AR

[tgs100]

Go to the invoice --> Lines --> Distribution. Then change the percentage or amount and then add new lines. But you should do this line by line.

Did you face any issue?

Cheers,
Saravanan TG

[aanchan_001]

Hi Saravanan,


Thanks for your prompt reply. But this is nto the issue. We have an external system from where the revenue generated by that system is sent to AR. But actually this comes in one account, in AR. We need to split this into three accounts. For eg. the interface bring the account to Rev Account A, we need to split this to Rev b , Rev C and Rev D in some percentage .

[hiszaki]

Hi aanchan

If you use R12, you can use the SLA (according to my knowledge) to make the revenue account split to 3 accounts but this process will be effected only when you make create process but the AR distribution will still 1 AR revenue account.

Thanks
Hisham

[anjan123]

[quote]Hi Saravanan,


Thanks for your prompt reply. But this is nto the issue. We have an external system from where the revenue generated by that system is sent to AR. But actually this comes in one account, in AR. We need to split this into three accounts. For eg. the interface bring the account to Rev Account A, we need to split this to Rev b , Rev C and Rev D in some percentage .

<i><div align="right">Originally posted by aanchan_001

[tgs100]

<b>Thanks for your prompt reply. But this is nto the issue. We have an external system from where the revenue generated by that system is sent to AR. But actually this comes in one account, in AR. We need to split this into three accounts. For eg. the interface bring the account to Rev Account A, we need to split this to Rev b , Rev C and Rev D in some percentage.</b>

Few Questions
==========
1. Do you know the revenue accounts and amounts before creating the AR Invoice (In your case, 3 revenue accounts and amounts)
a) If Yes, You can populate these details in RA_INTERFACE_DISTRIBUTIONS_ALL Table. (I have brought the debtors and revenue accounts from external system, but with only one revenue account. I think you can bring multiple revenue lines too)
b) If no, then do you want to modify these revenue accounts manually in AR invoice?
3. Is it required all the invoices?

Cheers,
Saravanan TG