My Oracle Support Banner

E1: 45: Advanced Pricing FAQ (P4070/P4071/P4072/P4210/R42750) (Doc ID 1366505.1)

Last updated on APRIL 18, 2024

Applies to:

JD Edwards EnterpriseOne Advanced Pricing - Sales - Version XE and later
Information in this document applies to any platform.


This document provides answers to various questions on the General Advanced Pricing applications.

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
  Adjustment Schedule (P4070)
 Question 1: Can an Advanced Pricing schedule be returned based on the Ship To or Bill To address instead of the Sold To Address?
 Question 2: Why isn’t the Advanced Pricing schedule being automatically populated into the Sales Order Header even though the schedule is valid and has been added to the Customer Billing Instructions for the Sold To Customer/Address Number ?
 Question 3: If there are multiple adjustments in a schedule, in which sequence are they applied?
 Question 4: In the Price Adjustment Schedule (P4070) Grid, the Sequence Number (OSEC) only allows up to 999 lines even though OSEC shows as four digits in the data dictionary.  Is it possible to enter more than 999 adjustments on a schedule?
 Question 5: Can an Adjustment Schedule that defaults into the Sales Order Header be deleted/cleared?
 Adjustment Definition (P4071)
 Question 1: What is the purpose of the Line Type in the Adjustment Definition (P4071)?
 Question 2: What is the purpose of the Manual Add/Change option (alias MDED) in the Adjustments Options?
 Question 3: Does Advanced Pricing recognize simple groups in the Price Adjustment Definition (P4071)?
 Adjustment Details (P4072)
 Question 1: What is the Price Adjustment Detail Work File (F4072W) and can the data be purged?
 Question 2: If a new adjustment detail record is added with the same expiration date as an existing record, a hard error is given. However, if the expiration date is different even by only one day, but the two records have overlapping dates there is no error. Why isn't an error displayed?
 Question 3: When the Preference Hierarchy is defined to include the item and customer group, why is the item number field not displayed on the Grid of the Adjustment detail versus the header? This makes it impossible to upload prices by item into the grid using a spreadsheet import.
 Question 4: When adding and saving an adjustment (or preference) detail record (P4072) why does the system return to the Preference Hierarchy Selection form?  
 Question 5: Can a price adjustment be defined using the "parent" item number in a Apparel or Matrix Item?
 Question 6: Does the pricing adjustment detail revision program (P4072) allow the user to blank out the Threshold UM field, or not populate it with a value?
 Price Sensitive Fields
 Question 1: What fields in Sales Order Entry (P4210 and P42101), are price sensitive and impact Advanced Pricing?
 Question 2: What fields in Purchase Order Entry (P4310), are price sensitive and impact Advanced Pricing?
 Adding an Adjustment Line to a Sales Order
 Question 1: Is it possible to use a line level price adjustment based on a percentage that will add a line to the order? 
 Amount Level Breaks
 Question 1: If the Price Adjustment Definition has the Override Price Checkbox checked can the Override Price be used to determine whether the Amount Level Break has been reached?
 Question 2: Why is an amount level break, line level adjustment, with from level = 1,  not applied for an item that has no base price? Warning 2394 "No Base Price In Effect"  is seen during order entry.
 Question 1: Can Advanced Pricing be applied to Non-stock items?
 Question 2: What Next Numbers are used for Advanced Pricing?
 Question 3: Can Advanced Pricing be used to set up a zero unit price for a specific currency?
 Question 4: If there are price records setup in domestic currency but not in a foreign currency is it possible to automatically generate the foreign currency pricing records?
 Question 5: Can a procurement price adjustment be retrieved based on a specific value in the agreement number field?
 Question 6: A customer requires that the adjustment use the extended price, not the unit price, to calculate the discount. How can this be done?
 Question 7:  Selecting the "Delete" button (Trash Can icon) in the Price History application does not remove the selected adjustment. Why?
 Question 8: Can a sales adjustment be set up to use an item's cost (P4105) as the price? 
 Question 9: We have a discount adjustment that works properly for positive quantities but does not apply to negative quantity orders. Why?
 Question 10: If customer is set in a different currency then company base currency and no valid adjustments exist in P4072 for the foreign currency, the system will apply the base currency adjustment with the corresponding exchange rate. Can this be avoided in such way that if no foreign adjustment exists, nothing gets applied?
 Question 11: Why is  P4074 Check Price and Availability showing error "Status flow not setup" when there is no status involved for this application?
 Question 12: Does the ‘Item Price Group’ on the adjustment always have to match the ‘Item Price Group' on the Item/Branch record?
 Question 13: Does the World program ‘Advanced Pricing - Price Book’ (P45510) have an equivalent in E1?
 Question 14: How can a mass delete of price adjustment records be performed?
 Question 15: What is the importance of F4074 table?
 Intercompany orders with Advanced Pricing
 Question 1: Why is the Cost or Base Price Markup processing option (Process Tab #10)  being ignored on an Intercompany Order with a Basis Code 3 (% of Cost) Price Adjustment?
 Data Conversion and Batch Upload of Data
 Question 1: Adjustments are not applied as expected to orders after an upgrade from XE (or ERP8) to 9.1 (or 9.0, etc). What could be the cause of the problem?
 Question 2: Are there interoperability Z files for Advanced Pricing for uploading advanced pricing tables such as, Adjustment Schedules (F4070), Adjustment Definition (F4071), Adjustment Detail (F4072) and Price History (F4074)?
 Unit of Measure and Price Adjustments
 Question 1:  Is there a way to use a different unit of measure to calculate the adjustment than what is used to retrieve the adjustment. For example the item is ordered in EA but the calculation of freight charges needs to be based on LB?
 Price Adjustments for Orders Created from Blankets or Quotes
 Question 1: Is it possible to apply price adjustments to sales order lines generated from a blanket or quote order?

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