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.
This document provides answers to frequently asked questions regarding Item Ledger - Cardex (F4111).
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
|Questions and Answers|
|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?|