My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2020

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 P4108, 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?
References

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