Page 1 of 1
Revenue Splitting in AR
Posted: Fri Sep 11, 2009 8:27 am
by 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
Posted: Fri Sep 11, 2009 8:47 am
by 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
Posted: Fri Sep 11, 2009 9:09 am
by 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 .
Posted: Sun Sep 13, 2009 4:11 am
by 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
Posted: Sun Sep 13, 2009 5:55 am
by 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
Posted: Mon Sep 14, 2009 1:12 am
by 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