E1: 41: Base Price and Cost FAQ (P4105/P4106/P4210/P4310)
(Doc ID 1305443.1)
Last updated on APRIL 05, 2022
Applies to:
JD Edwards EnterpriseOne Sales Order Processing - Version XE and laterJD Edwards EnterpriseOne Inventory Management - Version XE and later
JD Edwards EnterpriseOne CRM Sales Order Entry - Version XE and later
JD Edwards EnterpriseOne Sales Order Management - Version XE and later
JD Edwards EnterpriseOne Procurement and Subcontract Management - Version XE and later
Information in this document applies to any platform.
Purpose
This document provides answers to a number of commonly asked questions on the Base Price and Cost topics.
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 |
Price |
General |
Question 1: When setting the unit price for an item using complex groups, where is the price amount held, as it cannot be found in the Base Price (F4106) table based on the item number? |
Question 2: Standard Pricing is used to calculate the item Unit Price based on cost method 02, but the system still retrieves the item base price. Why does this happen? |
Question 4: Is there any way to calculate the order price at order entry based on the Promised Ship Date for a specific Branch Plant only? |
Question 5: Is there a way to set unit price to be inclusive of tax? |
Question 6: What is the difference between (Unit Price) UPRC and (List Unit Price) LPRC in F4211 SO Detail File? |
Question 7: Is there any program or UBE that can perform mass upload of data in the Base Price table (F4106)? |
Question 8: Why doesn't the paper clip icon appear automatically in P4106? Why does the user need to click the paper clip icon in the grid area in order for paper clip to indicate attachments exists? |
Pricing Business Functions |
Question 1: Which business function is used by Sales Order Entry (P4210) to fetch the Base Price (F4106) record? |
Price Update/Change |
Question 1: How to check if the price was overridden or not on a Sales Order, and if a base price was previously retrieved by the system, but manually changed by a user? |
Question 2: Can a Sales Order generated from a Blanket Order be repriced? |
Question 3: Is there any way to override the unit price on the sales order after the line has been entered? |
Question 4: Is there a way to add or change an adjustment in the Price History window if the P4210 processing option (Display tab #2) is set to disable or hide the price fields? |
Question 7: What fields in Sales Order Entry (P4210) are price sensitive? |
Question 9: Is branch markup cost/price applicable on direct ship sales order (SD/OD)? |
Cost |
Weighted Average Cost |
Question 1: Does Batch Ship Confirm (R42500) need a record in the UDC 40/AV table in order to update average cost in the Item Cost (F4105) table? |
General |
Question 2: Is there a program to copy the F4105 from one branch plant to another? |
Question 3: Is there an easy way to zero out the cost on a large quantity of items? |
Question 4: Why is the Record Invalid (Error ID 0002) error message displayed when trying to add a cost in P4105? |
Question 5: Are there any considerations that need to be made before disabling the cost fields in Sales Order Entry? |
Cost Changes |
Question 1: How to change the Purchase Price Level (PPLV) on items from 3 to 1? |
Question 2: What accounting entries are created when the Standard Cost of an item is changed in F4105? |
Question 3: What causes the SO to have a different unit cost as compared to the cost in the F4105? |
Question 4: Is there a batch application that will update the cost on a purchase order if there has been a cost change in either the F4105 or F41061 tables? |
Question 6: Why does Batch Cost Maintenance (R41802) print 'Invalid AAI Code' error on the output? |
Question 7: When the Process tab in the Processing Options is set to a value of '1' for P4105, why can users still add the 07 Standard Cost? |
References |