E1: 41: Base Price and Cost FAQ (P4105/P4106/P4210/P4310) (Doc ID 1305443.1)

Last updated on JULY 21, 2020

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version XE and later
JD 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

Questions and Answers

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 3: Why are pricing records in the Item Base Price (F4106) table and the new Item Key ID Master Table (F40941) getting created with the Item Group Key ID field (IGID) set to 0 after converting the pricing records from an older release like World A7333 or Xe?

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 5: What are the ramifications of changing the decimals of data dictionary items UPRC (Unit Price) and UNCS (Unit Cost)? Should DTAD (File Decimals) and CDEC (Display Decimals) be changed as well?

Question 6: Is there a UBE that will retrieve the Sales Inventory Cost in the Item Cost (F4105) table, apply a markup percentage to the cost, and use the calculated cost plus markup value to update the corresponding Item Base Price (F4106) record for the item number?

Question 7: What fields in Sales Order Entry (P4210) are price sensitive?

Question 8: When attempting to copy a sales order having the Adjustment Pricing, why is the Unit price not re-calculated based on the changes made to the new order? Instead it retains the same Unit price of the Original order. Additionally, the adjustment definition(s) have the “Apply on Override Price” option checked AND the “Sales Pricing on Override Price” in the Pricing Constants is also set.

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?

Question 2: How to correct the Amount variances that appear between Item Balance (F41021) amount and the cumulative extended cost of all transactions from Item Ledger (F4111) that have occurred for an item?

Question 1: Is there a method to set up one item with multiple costs? For example, the same part/item number would have one cost for bulk, a different cost for box, which would include packaging expenses?

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 standard 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 5: When trying to change the standard cost (07) in P4105 for some items, the system takes a long time to process the change and sometimes an error message "Web Exception - There was a problem with the system while executing BSFN InventoryCostChangeEditGL" is displayed. Why does this happen?

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?

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