My Oracle Support Banner

E1: 43: Understanding Purchase Price Retrieval (P4310 / P41061 / P4105 / P43090) (Doc ID 625594.1)

Last updated on MARCH 26, 2024

Applies to:

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


When entering a Purchase Order, as long as Advanced Procurement Pricing is not active, the program looks at two files in order to locate a price for the item, Supplier Price/Catalog (F41061) and Item Cost (F4105) tables.

The program takes the Purchase Price Retrieval UOM setting in the System Constants and uses that unit of measure when looking at the Supplier Price/Catalog (F41061) file. The System Constants is accessed by going into the Branch/Plant Constants (P41001) off menu G43A41, and then take the System Constants form exit. If there is no match for that unit of measure, the primary unit of measure is used to locate a price within the Supplier Price/Catalog (F41061) file. If a price is found, the program will take that price and multiply it by the unit of measure conversion. If no matches are found in the Supplier Price/Catalog (F41061), the program then uses the purchasing cost from the Item Cost (F4105) file and multiplies it by the unit of measure conversion.

If a multi-currency environment is used, the Supplier Price/Catalog (F41061) record will have to have a match for not only the unit of measure but also the currency.

It is not possible to identify if the F4105 or F41061 is used to retrieve the price. If the purchase price level is set to 3, inventory cost level, the price is always retrieved from the F4105. If the purchase price level is set to a value other than 3, the order entry application looks first to the F41061 for a valid price. If a valid price is not found, the application searches the F4105 for a valid price. In order for cost to default into a purchase order from the Item Cost (F4105) file, a record with COCSPO = P must exist for that item.

Note: In Standard pricing there is no hierarchy to search supplier catalogs by the Parent supplier in addition to the Child supplier entered on the order. See the existing Enhancement Bug 10951131: ENTER PRICES ONLY FOR THE SUPP - SAR: 8384854.


This documentation describes how the price is defaulted in for an item during Purchase Order entry when Advance Pricing is not active.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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