My Oracle Support Banner

E1: 45: 42: Penny Variances Between Account Ledger (F0911) and Rebate Volume History (F4078) on Rebate Entries After Sales Update (R42800) (Doc ID 2813004.1)

Last updated on OCTOBER 08, 2021

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version 9.2 and later
JD Edwards EnterpriseOne Sales Order Processing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Under certain conditions, when an Advanced Pricing Adjustment rebate exists on a single Sales Order detail line, the Sales Update will create journal entries (F0911) that have penny variance to what is reported in the Rebate Volume History (F4078).

Steps to Duplicate:
1. Create a Base Price (P4106) record for an item with Unit Price = 86.3465 EA.
2. In Price Adjustment Revision (P4071), create a rebate adjustment
3. In Price Adjustment Details (P4072), create a record for an item with a Factor Value Numeric = -10 and Basis Code = 1.
4. In the Rebates row exit from P4072 (P4077), create a Rebate Type = 1 (Percentage), Threshold Value = 100 and Rebate Factor = 10.0000.
5. Create an Advanced Price Schedule (P4070) and attach the rebate adjustment.
6. Add a Sales Order where the header is called first; make sure that the Adjustment Schedule is entered.
7. Enter an order quantity of 200 EA of the item with the rebate adjustment. In the row exit to Price History, note that the system finds the rebate adjustment.
8. Process the Sales Order all the way to Sales Update (R42800). Note that the 4270 and 4280 DMAAIs have entries.
9. Inquire on the customer in Rebate Volume History (P4078). Note the Open Rebate Amount (1,726.93).
10. In databrowser, inquire on the IB batch in table F0911 and filter on the 4270 account. Notice that the Amount in the account ledger has a penny variance (1,726.94) from what was updated in the Rebate Volume History table.

Changes

 

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
Changes
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.