My Oracle Support Banner

Netaccrual Engine Calculation Is Not Considering The Credit Memo From The Monthly Net Accrual Offer (Doc ID 1155373.1)

Last updated on FEBRUARY 23, 2019

Applies to:

Oracle Trade Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Checked for relevance in 29-APR-2011


Symptoms

Net Accrual Engine calculation is not considering the Credit Memo from the Monthly Net Accrual Offer

a) Create these Net Accrual Rule Sets:

Net Accrual Rule Monthly
-- Terms Discount
-- Credit Memo

Net Accrual Rule Quarterly
-- Credit Memo
-- Terms Discount
-- Monthly Discount

b) Book and Ship Order ORD1 - qty 1, price 100

c) Create Accrual Offer ACC1
- Activity = Terms Discount
- Discount = 10%
- Accruals
- ORD1 = 1 * 100 * 10% = $10


d) Create Net Accrual Offer NA1
- Activity = Monthly Discount
- Discount = 5%
- Accruals
- ORD1 = 1 * 100 * 5% = $5
--CRED = 1*-20 *5% = -$1
- ACC1 = -$10 * 5% = -$0.5

Net Accrual = $3.5 which is equivalent to ($100 - $10-$20) * 5%

e) Create Net Accrual Offer NA2
- Activity = Quarterly Discount
- Discount = 20%
- Accruals
- ORD1 = 1 * 100 * 20% = $20
--CRE = 1* -20 *20% = -$4
- ACC1 = -$10 * 20% = -$2
- NA1 = -$3.5 * 20% = -$0.7 -- This calculation is happening incorrectly. It’s not considering the Credit Memo from the Monthly Net Accrual Offer. For example it is calculating the discount on $4.5($5-$0.5) from Monthly Net Accrual offer instead of $3.5($5-$1-$0.5)

Net Accrual = $13.3 which is equivalent to ($100 - $20-$10 - $3.5) * 20%

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.