My Oracle Support Banner

E1: 41: Inventory Transactions FAQ (P4112/P4113/P4114/P4116) (Doc ID 2003450.1)

Last updated on MARCH 12, 2021

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version XE and later
Information in this document applies to any platform.

Purpose

This document covers how to use each of the Inventory Transactions and frequently asked questions regarding these programs.

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
 General
 Question 1: Where is the G/L Class Code retrieved from when performing inventory transactions (transfers, adjustments, issues)?
 Question 2: No batch number is being assigned when completing transactions in Inventory Issues (P4112) and Inventory Adjustments (P4114). Why?
 Question 3: Have the processing option for all of the Inventory Transaction programs to disallow negative quantity available but the quantities are still going negative, why?
 Question 4: Inventory Transactions do not allow negative availability of Serialized Items even through the processing option for negative availability is set to 1. Why?
 Question 5: What is the meaning of the Branch/Plant field on the header part of the Inventory Adjustments/Issues applications? Is it possible to do adjustments/issues for multiple branch/plants in the same transaction?
 Question 6: How to Set Up Batch Approval and Post Security (P00241) for Inventory batches?
 Question 7: Is it possible to allocate the cost for inventory transactions between multiple companies? Will that result in out of balance error at post?
 Question 8: Which inventory applications have the processing option to prevent Inventory balances from going negative?
 Question 9: In Work with Batches (P0011), ALL Batch Type N records are displayed with Status U - In Use. Why does this happen and how can this be cleared?
 Question 10: When the user enters Work with Inventory Transfers (P4113 W4113A) and clicks Find, a wide open inquiry is launched against the Item Ledger (F4111) table impacting performance for users throughout the enterprise. What can be done to prevent these runaway queries?
 Question 11: When adding a transaction via P4112, P4114 or P4113, the Explanation field is populated with the document type description from UDC 00/DT as the default if left blank.  However, in the P4116 why does the value default as "Reclassification"?
 Question 12: When revising the Item Branch G/L Class (F4102.IBGLPT), the Item Locations G/L Class (F41021.LIGLPT) remains unchanged. Is this functioned as designed?
 Question 13: Can the branch plant creation on the fly for an item be blocked?
 Question 14: Inventory Transfers (P4113) and Adjustments (P4114) allow phantom items to be transacted. Since there is no inventory for this type of item, why is this allowed?
 Question 15: Does the Supplier number (F4108.VEND) gets updated in the Lot Master with inventory transactions such as reclassification, inventory adjustment, transfers?
 Transfers
 Question 1: For Inventory Transfer (IT), what cost will be assigned 'To' when using Standard Cost versus Weighted Average Cost?
 Question 2: Some Inventory Transfers create records in F4106. Should the Base Price be transferred?
 Question 3: When transferring inventory to a new location within a Branch/Plant (or to another Branch/Plant), the GL Class code on the item is changing to match the 'To' location. Is it possible to have the 'From' G/L class code carry over to the new location for an item?
 Question 4: When transferring inventory, "To Lot" Field is disabled? How can this be enabled
 Question 5: When the user is performing the Inventory Transfer , using the quantity in KG, in the availability he is seeing the quantity on hand in GM.
 Adjustments
 Question 1: When adding an entry into the Inventory Adjustments (P4114) the information entered into the Memo Lot 1 and Memo Lot 2 fields is not retained. Why?
 Question 2: Client is doing an Inventory Adjustment (P4114) affecting the Cardex (F4111) not affecting the Item Location (F41021). Why?
 Question 3: When an Inventory Adjustment (P4114) is done for a cost level 3 item, setup with 09 Actual Cost as the Sales/Inventory Cost Method and a quantity is added to a new location for an existing lot number, the cost on the transaction is defaulted in as zero from the Primary Location Record Item Cost Record. Why?
 Question 4: An item is setup in Item Master (P4101) with Sales price level = 3. There is a base price record in the Item Base Price file (F4106) for this item and the primary location of the BP. However when entering an Inventory Adjustment (P4114) for this item, BP and a new location or lot, the system does not create any record in the F4106 file. Why is this happening?
 Question 5: Why does Inventory Adjustments (P4114) allow stock to be updated to Blank Lot for lot-controlled item without errors?
 Question 6:  In E1 when creating a new Inventory Adjustments (P4114) it creates 2 lines in F4111.  What is the meaning of the 2 lines and how can we setup the system so that (when inventory adjustment brings total quantity to zero) the line Standard Cost Change in table  F4111 is not created?
 Issues
 Question 1: Why is the account number entered in the Inventory Issues not stored in the F4111, Item Ledger?
 Question 2: In case of promotional items, there is a reason code that can be entered. Is there a way to direct inventory items that are used in promotional purposes to a different GL account?
 Question 3: How can the Lot assignment be setup so that it will follow "First in First Out" (FIFO) process when issuing items during Inventory Issues (P4112)?
 Reclassification
 Question 1: When reclassifying one item to another item in the same cost center, is there a way to create a COGS variance to account for difference in cost between the two items?
 Question 2: What is the functionality of  processing option #5. Quantity Validation - P4116 --> Process Tab?
 Question 3: How are Lot Status Codes (alias LOTS) handled during the Reclassification process? 
 Question 4: If using Last In 01 cost method will the TO location write a cost record in the F4105 if it is overridden and there is not already a cost? 
 Question 5: Using 06 lot cost method will the FROM lot/location cost default its lot cost to the TO Lot/Location?
 
 Dual UOM 
 Question 1: When entering in an inventory transaction for a dual unit of measure item does the secondary UOM automatically get populated?
References

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