WS: 42: Pricing (UPRC) Is Based On Order Entry Date Despite System Contants = 2 Sales Price Based on Date (Promised Ship Date) in Sales Order Entry - P4211 (Doc ID 2809400.1)

Last updated on DECEMBER 20, 2024

Applies to:

Symptoms

Despite having the System Constants (P4009W) Sales Price Based on Date = 2 (Promised Ship Date), the sales order is picking up the price based on the order date (TRDJ). This occurs in test for upgrade to latest release A9.4.0.2 and if the preference profiles processing option = 1 in Sale Order Entry (P4211).

Steps to Duplicate
1. Create an Item with a UOM Conversion, Defaults UOM, and different pricing for September and October, i.e. $77.90 and $80 dollars respectively. – G4111 / Item Master P4101 and exits for UOM (F8), Conversions (F8) and Pricing (F9) information.
2. Set the System Constants – G4241/5 BP Constants / F10 – System Constants P4009W field Sales Price Based on Date = 2 for Promised Ship Date
3. Set processing option for Preference Profiles = 1 in Sales Order Entry -P4211. Note: It does not matter what is set up in Preferences. It only matters that the processing option is flagged.
4. Enter a sales order (P4211) for a requested date (DRQJ) of Oct 15, 2021, and Order Date for Sept 22, 2021.
5. Enter the item on the sales order with a quantity of 1, press enter.  Note: The price = September’s value $77.90 and is not based on the Promised Ship Date field = Oct 15, 2021 for $80.00.
6. Run another test with the Preference Profile option in P4211 = blank.
7. Enter a sales order for the same dates and notice the price has defaulted based on the Promised Ship date of Oct 15, 2021 for $80.00. This is correct.

Cause

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