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

Last updated on JUNE 08, 2022

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.