E1: 45: Cost-Based Rebate Calculated Using Price Instead of Cost
Last updated on DECEMBER 12, 2016
Applies to:JD Edwards EnterpriseOne Advanced Pricing - Sales - Version 9.0 and later
Information in this document applies to any platform.
On : 9.0 version, Advanced Pricing
Sales Update (R42800)
A Rebate Adjustment is setup with Basis Code 3 (Percent of Cost). The adjustment is calculated as a % of Extended Cost in the Price History (F4074) but the Open Rebate Amount in the Rebate Transaction Summary (F4078.RBAM) is calculated as a % of Extended Base Price by Sales Update (R42800).
The Open Rebate Amount (RBAM) is calculated at 20.00 (2% of 1,000.00 Extended Price). It should be $4.00 (2% of 200.00 Extended Cost).
The issue can be reproduced at will with the following steps:
- Setup a new Item with Cost of 100.00 and Base Price 500.00.
- Create a Rebate Adjustment Definition (P4071). Control Code 5. Line Level Adjustment. Hierarchy IA. Click on Additional Options Tab.
- Rebate Beneficiary is 7 (Address Number 1)
- Create a Rebate Customer
- Create an Adjustment Schedule with the Cost-Based Rebate Adjustment.
- Populate the schedule on the Rebate Customer Billing Instructions
- Create an Adjustment Detail Record for Customer and Item, using Basis Code 3 (% of Cost) and Factor Value of -2.000.
- Take the Rebates Row Exit
- Rebate Type is 1 (Percentage) Rate Method 1 (Single Rate) Rebate Factor 2.000 (%)
- Enter the Sales Order for the Customer and make sure the adjustment schedule is populated in the header.
- Enter a quantity of 2 items. Extended price is 1,000, Extended Cost is 200.00. Rebate should be $4.00 (2% x 200.00)
- Go to Price History. It shows -2% of cost, but no amount is extended.
- Process the Order through Sales Update. The accrual adjustments were $4.00 which is 2% of the cost of 200.00. Journal Entries are correctly calculated on cost.
- Check the Rebate Transaction Summary (F4078). The Open Rebate Amount (RBAM) is calculated at 20.00 (2% of 1,000.00 Extended Price). It should be $4.00 (2% of 200.00 Extended Cost).
- Incorrect Open Rebate Amount will cause Rebate Claims to be incorrect and out of synch with Journal Entries.
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