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 01, 2022

Applies to:

Oracle Trade Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
 


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.