My Oracle Support Banner

E1: 41: FAQs for Item Ledger - Cardex (P4111/ P4108/F41021/F4102) (Doc ID 1320934.1)

Last updated on DECEMBER 07, 2023

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version XE to 9.0 [Release XE to 9.0]
JD Edwards EnterpriseOne Inventory Management - Version 9.1 to 9.1 [Release 9.1]
Information in this document applies to any platform.

Purpose

This document provides answers to frequently asked questions regarding Item Ledger - Cardex (F4111).

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
 Video
 Question 1 - G/L Class Code in the Item Ledger (F4111) and Item Branch (F4102) files do not match. How is this possible?
 Question 2 - During Order Entry (P4210, P4310), where is the G/L Class Code retrieved from?
 Question 3 - If the G/L Class Code is changed in the Item Location (F41021), will this affect existing open orders?
 Question 4 - Is it possible to sort the grid by Location in Item Ledger Inquiry (P4111)?
 Question 5 - What is the IZ document type used for in Item Ledger (F4111) file?
 Question 6 - When a Lot is updated using Speed Lot Status (P4108), why isn't the Reason Code for a Lot Status saved?
 Question 7 - Is there a purge program for Item Ledger (F4111) file?
 Question 8 - Is it possible to sort and filter the records in Item Ledger Inquiry (P4111) by Time of Day?
 Question 9 - Where does the system store Quantity On Hand (PQOH) and Value (ECST) in the Item Ledger, P4111?
 Question 10 - In the header of the P4111 Item Ledger Inquiry, the Secondary Quantity On-Hand field is blank although the item has on-hand balances and a secondary UOM setup in the Item Master.
 Question 11: Is it possible to change the default sorting for the grid in P4111?
 Question 12: What is the function of field "Document Number Desc" in Item Ledger (P4111)?
 Question 13: When putting a lot on hold or releasing from hold in Lot Master (P4108) or using Hold Expired Lots (R41082), two IZ records were written to the item ledger instead of one.  One was for the primary location and another for a secondary location.  Why were two records written?
 Question 14:  In a Multi-Currency Environment, how will the Unit Cost and Extended Cost be displayed in the Item Ledger  (P4111) and Cardex (F4111 )?
 Question 15: Is it possible to sort the Item Ledger (P4111) grid by Unique Key ID (UKID)?
 Question 16:  If an inventory cost change is made to a stock item (Inventory interface = Y), should a record of this change exist in Item Ledger (P4111)?
 Question 17:  When filtering records via QBE, by fields such as Location or Branch, the Quantity on Hand differs than when filtering via the header fields.  Is this functioning correctly?
 Question 18: What is the purpose of the Business Unit - Alt (MCUZ) field in the Item Ledger (F4111)?
 Question 19:  When reviewing an item in the Item Ledger, there are numerous 'IB 41021' transactions.  What is the importance of these transactions?
 Question 20: Is it possible to inquire for item ledger records without searching by the item number field?
 Question 21: Why are IB records not written to the Item Ledger for a cost change on an item with Cost Level 1?
 Question 22: Why do records in the Cardex sometimes have differing "Creation Date' (CRDJ) and 'Order Date' (TRDJ) values?
References

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