Extra $0.01 Remained With A Full Refund Using Event Adjustment With Tax
Last updated on SEPTEMBER 26, 2016
Applies to:
Oracle Communications Billing and Revenue Management - Version: 7.4.0.0.0Information in this document applies to any platform.
Symptoms
Extra $0.01 remaining in account when doing a full refund.Here is the scenario -- an account with a monthly fee of $5 with taxes. Tax rate is 17.5% which comes up to .88
1. The customer gets billed on Dec 27th and the charge is $5 + .88 = $5.88
2. On Jan 17th the customer cancels the subscription which will result in a prorated refund -$1.89 (1.61 net and .28 tax)
3. Now per business rules for some customers, the remaining portion of the charge has be refunded as well (Note: this adjustment is not applicable to all customers)
4. An event level adjustment with taxes is created for the remaining amount (5 - 1.61 = 3.39). BRM will proportionate the tax and calculate it as .59
Now look at that account it has a $0.01 balance.
1. Charge was 5.88
2. Cycle fee Refund was -1.89
3. Event Adjustment was -3.98
So the total refunded amount becomes 5.87 which is 0.01 less than the charged amount.
The net amount remaining is 0.01 instead of 0. Also there is not a way to adjust just the tax component of 0.01.
Steps to Reproduce
1. Create an account on Nov 27 using a price plan that prorates on cancel. Paytype must be credit card.
The charge amount should be 5.
The tax should be 17.5% flat tax
The total charge should be 5.88
2. Move the date to Dec 27 and bill the account and apply a CC payment.
The total charge should be 5.88
3. Move the date to Jan 17 2011
4. Cancel the service
A cycle forward event will apply:
Net: 1.61
Tax: .28
5. Apply an event level adjustment on the Dec 27 cycle fee to effectively reverse the 5.88 charge. Include tax in the calculation
Event level adjustment amount: 3.39
Event level adjustment tax amount: .59
6. Bill the account. The Refund issued will be 5.87, which is 0.01 less than the charges amount
The charge amount should be 5.
The tax should be 17.5% flat tax
The total charge should be 5.88
2. Move the date to Dec 27 and bill the account and apply a CC payment.
The total charge should be 5.88
3. Move the date to Jan 17 2011
4. Cancel the service
A cycle forward event will apply:
Net: 1.61
Tax: .28
5. Apply an event level adjustment on the Dec 27 cycle fee to effectively reverse the 5.88 charge. Include tax in the calculation
Event level adjustment amount: 3.39
Event level adjustment tax amount: .59
6. Bill the account. The Refund issued will be 5.87, which is 0.01 less than the charges amount
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms