My Oracle Support Banner

E1: 45: Open Rebate Amount (F4078) Does Not Match Rebates Payable (F0911) Amount (Doc ID 2654716.1)

Last updated on APRIL 01, 2020

Applies to:

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

Symptoms

When Sales Update (R42800) calculates a rebate adjustment and the Threshold Unit of Measure in the Price Adjustment Detail (P4072) does not match the Rebate Factor Unit of Measure on the Rebate Threshold Revisions (P4077) screen, the Open Rebate Amount in the Rebate Transaction Summary (F4078) will not match the Rebates Payable Journal Entry (F0911) Amount. Sales Update is calculating the Open Rebate Amount as the Factor Value Numeric on the Threshold Unit of Measure times the Quantity in the Threshold Unit of Measure.

The issue can be reproduced at will with the following steps:

  1. On the Price Adjustment Detail (P4072) the Threshold UM is CA (Cases) and Factor Value UM is NT (Net Weight)
    1. Adjustment is -0.3000 Basis Code 5 (-0.3 x Net Weight)
  2. Rebate Theshold Revision (P4077) is set as follows
    1. Rebate Type = 3 (per unit amount)
    2. U/M = CA
    3. Rate Method = 1 (Single Rate)
    4. Threshold Value = 1
    5. Rebate factor = 0.3000
  3. Enter Sales Order for 21 CA
    1. Base Price = 40.5400
    2. Rebate adjustment is calculated as 3.2813 which is correct
    3. Full Rebate Amount is 68.91 (3.2813 x 21 CA)
  4. Process Order through Sales Update (R42800)
    1. Rebate Payable G/L Account = 68.91 as expected.
  5. Check Rebate History Inquiry (P4078)
    1. Open Rebate is calculated as 6.30 (21 CA x 0.3000)
    2. Open Rebate should be the same as Rebates Payable (68.91) in G/L

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.