My Oracle Support Banner

WS: 41: FAQ General Inventory (Doc ID 1552905.1)

Last updated on JANUARY 31, 2020

Applies to:

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

Purpose

To document the frequently asked questions about general inventory.

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
 Buyers Information
  Question 1: Do the Reorder Point (ROP) and Economic Order Quantity (EOQ) calculations that display on Buyer's Information (P4115) update to the F4102?
 Question 2: How does the system calculate the Trend Percentage and the Quantity Projected Total (12PD>) that displays on the Buyers Information video?
 Auditing
 Question 1: You want to audit the price file (F4106) to track who makes changes what changes are made.
 Question 2: You want to audit the AAI file (F4095) to track who makes changes what changes are made, however the F4095 does not contain audit fields like USERID, WORKSTATION, DATE and TIME.
 Question 3: You want to set up the audit logs for changes to business units in the branch/plant constants (F41001) to see when someone makes a change to a business unit.
 Question 4: We would like to begin auditing changes made to both the Item Master (F4101) and Item Branch Master (F4102) files. How can this be setup?
 Reports
 Question 1: How to create a report for item notes.
 Question 2: Is it possible to run the Inventory Valuation report (P41590) as of a certain date? For example, can you generate a June 30th inventory valuation on August 1st?
 Question 3: When you have multiple item cross reference records for the same cross reference type, item number, and address number combination, which customer item number will print on a report such as the P42565 Sales Acknowledgement?
 Question 4: Is there a report that will show the quantity on-hand for an item as of a particular date?
 Question 5: The P41540 - Item Ledger Detail Report has a BF (Balance Forward) record showing no quantity with a value in the Extended Amount column.  What does this BF record represent?
 
Miscellaneous
 Question 1: Using the item search programs for non-stock items.
 Question 2: Is it possible to access links attached to an item through Catalog Detail Information (P41903) while using green screen (5250 display emulation?)
 Question 3: How can you derive the creation date for an inventory item?
 Question 4: What programs update the Item History File (F4115)
 Question 5: Is there any way to set up security for Profile Data Entry (P41091)?
 Question 6: How do you set up business unit security for Supplier/Item Price Revisions (P41061) when prices are set up by supplier only (Item Master Purchase Price level equals 1)?
 Question 7: Is there a Batch program available to load the F41002 Units of Measures Conversion Factors?
 Question 8: We have all our supplemental data set up without the branch plant specified. I have a new group I would like to set up by branch plant. Is it possible to do both?
 Question 9: You are upgrading to A9.1. The UPC and SCC data that used to show in your UCC info screen V41020 (F18 from the Item Master) is no longer visible.
 Question 10: What is data item SUTM in the F4101 (Item Master) used for?
 Question 11: Some of the records in the F4104 have a blank Branch/Plant field (IVMCU) and want to know if that will cause a problem.
 Question 12: How to Correct or Delete UPC/SCC Code Information in V41020
 Question 13: You wish to add additional information to inventory items and want to know about the user reserved fields.
 Question 14: From where do Item Notes (P4016) effective dates default?
 Question 15: F4115 Quantity on Hand Prior Month Fields IHPQ1 - 14
 Question 16: Catalog Detail Information (P41903). How to add a link?
 Question 17: What are the risks/issues in changing the Commitment Method (CMGL) to commit inventory from locations with the least on-hand to locations with the most on-hand?
 Question 18: Can you remove an item that is no longer valid from appearing in item cross reference and how do you delete an item or multiple items at one time?
 Question 19: Can nonstock items have an Item Branch/Plant Information (P41026) master record created?
 Question 20: Does JDE have a field in the Item Master (F4101) or Item Branch Master (F4102) that can be used for Producer Price Index (PPI)? This field needs to be 10 characters long.
 Question 21: Is there an area or place in World Inventory to add 'item dimensions'?
 Question 22: When deleting a secondary location from Item/Location Information (P41024) why does error 000EL generate?
References

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