E1: 39: Advanced Stock Valuation FAQ (Doc ID 1401211.1)

Last updated on MAY 24, 2023

Applies to:

JD Edwards EnterpriseOne Advanced Stock Valuation - Version XE to 9.2 [Release XE to 9.2]
Information in this document applies to any platform.

This document answers frequently asked questions regarding the advanced stock valuation module system code 39.

	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

Purpose

Question 1: Document types are used by both the DCT Document Type and DCTO Order Type fields. Should the DCT, DCTO or both types be setup in P40040 Document Type Maintenance to be used in Advanced Stock valuation?

Question 2: Does Advanced Stock Valuation update the F4105 Cost Method(s) by Item?

Question 3: Why is standard cost not supported with Advanced Stock Valuation?

Question 4: Why do we need to include the document type PV in advanced stock valuation?

Question 5: How are PV voucher document variances that use the 4332 Cost of Sales AAI accounted for in Advanced Stock Valuation?

Question 6: Is there a batch process to add items to Item Pool Valuation Maintenance (P3904)?

Question 7: The PDF for Stock Valuation Extraction (R39600) shows the message See Work Center. The Work Center shows Error: Insert Unsuccessful. What causes the Insert Unsuccessful error and how can it be corrected?

Question 8: When attempting to review the results of running Stock Valuation Extraction (R39600) a message is displayed indicating "Retrieve of UBE file failed. The file may not exist on Enterprise Server." Why?

Question 9: The PDF for Period Build (R39120) shows Blanks Invalid for many items. What causes the warning/error and how can it be corrected?

Question 11: The PDF for the Stock Valuation GL Update (R39130) shows 029P Distribution AAI Number &1 Invalid. What causes the error and how can it be corrected?

Question 12: When the Stock Valuation GL Update (R39130) is run, how does the Item Ledger File (F4111) get updated?

Question 13: How do you reconcile the Item Ledger at the end of the month to the GL if there is not a corresponding entry to the Item Ledger?

Question 14: Using Dual Currency (XA ledger) functionality, Stock Valuation GL Update (R39130) was run using a weighted average valuation method. Why were the correct weighted average and also the opening and closing balance information were not calculated for the XA ledger?

Question 15: Upon reviewing period results in Stock Valuation Review (P39060), several items have a negative opening inventory. What caused those items to show negative balances?

Question 16: Does Advanced Stock Valuation support negative balances for weighted average cost?

Question 17: The PDF for Purge Stock Valuation Records (R39900) shows error Records from the current year or future years may not be deleted. What causes the error and how can it be corrected?

Question 18: Company wants to be able to do FIFO without lot control for inventory commitment. Can Advanced Stock Valuation - FIFO be used for inventory commitment?

Question 19: With IB Item Cost Changes document type setup as Incoming, it does not add Incoming value to Detail methods. Why does it only add Incoming value to Summary methods?

Question 20: Can Advanced Stock update the Sales Order Detail cost for that Item in the F4211?

Question 21: Why would Error 025B, No Records Found, be received on the R39130 PDF?

Question 22: Are we able to use flex accounting with the Advanced Stock Valuation DMAAIs?

Question 23: Can IB item cost update documents from Freight Update (R4981) update a detail method layer?

Question 24: We ran R39130 in final mode. Now we need to change the values. The journal entry batch was voided. Can we rerun R39130?

Question 25: What additional setup is needed in Advanced Stock Valuation when changing from an item from Manufactured to Purchased?

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