My Oracle Support Banner

WS: 41: FAQ Inventory Cost (Doc ID 1582054.1)

Last updated on FEBRUARY 10, 2020

Applies to:

JD Edwards World Inventory Management - Version A7.3 cume 4 and later
JD Edwards World Product Data Management - Version A7.3 cume 4 and later
Information in this document applies to any platform.

Purpose

 This document contains the most Frequent Asked Questions related to Inventory Costs.

Questions and Answers

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
Questions and Answers
 Question 1: Why does Item Ledger/Cardex (P4111) show two Cost Change records (IB Document Type) with no Document (DOC) or Batch (ICU)  numbers, one with a positive amount and the other with a negative amount?    
 Question 2: How to recalculate the Weighted Average Cost (Cost Method = 02) for an inventory item over a specific period of time?
 Question 3:  Can you change the Sales/Inventory Cost Method (CSMT) for an inventory item, and not have an IB record (Cost Change record) written to the Cardex?
 Question 4: Cost Ledger file (F4105) shows multiple records for the same Item and/or Branch and/or Location and/or Lot with the same Cost Method (LEDG) value. How to remove the duplicated Cost Method records?
 Question 5: How to change the Unit Cost Amount (UNCS) of a Cost Method (LEDG) in batch mode to an existent Cost Method Unit Cost Amount value?
 Question 6: How to copy Cost Method Unit Cost Amount from an existing Cost Method to a new Cost Method?
 Question 7: What is the most common cause of corrupted Weighted Average Cost (Cost Method 02) values?
 Question 8: Can you use the Purchasing Cost Method (Cost Method 08) as Sales/Inventory Cost Method?
 Question 9: Is there a batch program to update Sales/Inventory Cost Method value (CSMT)  for all your items?
 Question 10: What Cost Method ABC Analysis Report (P4164) uses to calculate On-Hand Inventory value?
 Question 11: Item Cost Level Conversion program (P41815). Does this program update Cost Ledger file (F4105) Business Unit field (MCU) when you convert the Item Cost Level value from 1 (Item Level) to 2 (Item/Branch Level)?
 Question 12: Is it okay to purge the Average Cost Workfile (F41051) if you don't use average costs?
 Question 13: Is it possible to set up the system to process items with FIFO (first in, first out) Costing?
 Question 14: We would like to use Cost Method 03 within Cost Revisions (P4105) to monitor cost comparisons. Is this possible to use this Cost Method with no ramifications? 
 Question 15: Is there a limit to the number of Cost Methods that can be used?
 Question 16: Why is the Cost Revision (P4105) screen generating error 2682 - Inquiry Required Before Change or Delete?
References

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