My Oracle Support Banner

E1: 39: Taxes from Receipt Reversal Not Reversed By Advanced Stock Period Build (R39120) (Doc ID 2544939.1)

Last updated on SEPTEMBER 25, 2020

Applies to:

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

Symptoms

When Period Build (R39120) is run against PO Receipt (OV) transactions in the Item Ledger (F4111) that include taxes as well as the received item, and some of the receipt transactions were reversed, the reversed tax is not subtracted from the Inventory Valuation causing the valuation to be overstated.

Steps to replicate

  1. The Item Ledger (F4111) contains three lines for PO Receipts for the same item and three additional lines for the item’s taxes
    1. 15422 OV Item +36.00 units @ 91.00 = +3,276.00
    2. 15422 OV Taxes = 220.32
    3. 15424 OV 15422 OV -36.00 units @ 91.00 = -3,276.00
    4. 15424 OV Taxes = -220.32
    5. 15425 OV Item +36.00 units @ 91.00 = +3,276.00
    6. 15425 OV Taxes = 220.32
  2. After running the Period Build (R39120) the Valuation Period Table (F39061) shows +36 quantity with valuation of 3,963.96 (36 x 110.11).
  3. This is because the unit cost includes the taxes three times (110.11 = 91.00 + 6.37 + 6.37 +6.37)
  4. The valuation should be 35,05.32 (36 units x 97.37 (91.00 + 6.37))

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.