Debit Memo in ReIM Generated from Complex Deals Has the Total Quantity of the Debit Memo in Each Item Line (Doc ID 2170944.1)

Last updated on AUGUST 15, 2016

Applies to:

Oracle Retail Invoice Matching - Version 14.1.1 and later
Information in this document applies to any platform.

Symptoms

When creating a debit memo in ReIM based on the income generated from a complex deal bill back rebate, each item on the debit memo is considering the total quantity/cost of all the Items, instead of the individual qty/cost.


Steps to Reproduce:

  1. Create Bill Back Rebate Deal based on receiving of purchase orders (POs).
      a. Bill Back Method – Debit Memo
      b. Invoice Processing Logic “Automatic All Values”
      c. Bill Back Period “Month”
      d. The deal also only contains a component based on quantity, and will have a discount of 10%.

  2. During the first month of income calculation, a purchase order was received with 16 Items, each with a Qty of 100 and a Unit Cost of 189.8147. On the table DEAL_ACTUALS_ITEM_LOC, we can see the 16 Items, each one with the quantity of 100 Units, and a turnover of 18981.4700 (Unit cost on the purchase order was 189.8147), and an income of 1898.1470 (10% of 18981.4700). Until this point, the calculation is correct.

  3. Run process vendinvc.pc to generate into the staging tables in RMS the information to be sent to ReIM for the generation of the debit memo, based on the actuals calculated at the end of month of the deal. The information generated matches the information that was calculated in table DEAL_ACTUALS_ITEM_LOC.

  4. Run the process reimcomplexdealupload in ReIM for the generation of the debit memo, based on the information placed in the STAGE_COMPLEX_DEAL_xxx tables in RMS. Based on the information in the IM_DOC_DETAIL_REASON_CODES, we can see that each one of the 16 items has the quantity of the total units of the deal, and not the value specific for each line.

    For each Item, we have:
    ORIG_UNIT_COST = -18.9815
    ORIG_QTY = 1600
    Total unit cost for each Item = -18.9815 * 1600 = -30370.4

    Each item has the total quantity of the debit memo, instead of the corresponding quantity.

Cause

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