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