E1: 45: SO Entry (P4210) Retrieves SI Cost From SI Customer Price Adjustment Instead of SK Customer Price Adjustment (Doc ID 2874064.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Symptoms

When using Advanced Pricing for the Cost or Base Price Markup, Sales Order Entry (P4210) pulls the cost of the SI order from a Price Adjustment for the end-Customer address when it should come from a Price Adjustment for the Selling Branch address.

Steps to duplicate:

1. Header Branch is 70, Header Company is 70, Address for Header Branch is 70 and Currency is EUR (P0010/P41001).
2. Detail Branch is 77, Detail Company is 77, Address for Detail Branch is 77 and Currency is CAD (P0010/P41001).
3. The end Customer is Address 7059 and their Currency is EUR (P03013).
4. Item Number 7077 is in Selling Branch Plant 70 (EUR currency) and Supply Branch Plant 77 (CAD currency).
   1. There is no inventory in the EUR Branch 70 but there is supply available to sell in Branch 77. (P41202).
5. A version of Sales Order Entry (P4210) is created for Intercompany (SI) Sales Orders.
   1. Order Type = “SI”
   2. Cost or Base Price Markup = 3 (Use Advanced Pricing on Base Price)
   3. Create Interbranch Invoices
   4. Interbranch Order Type = “SI”
6. The Supply Branch (77) has a Base Price (P4106) record of 0.0001 CAD setup.
   1. The record is required for JD Edwards when Cost or Base Price Markup = 3 (Use Advanced Pricing on Base Price).
7. Setup a Price Adjustment Definition (P4071) named SKBASE which will be the Price Adjustment used to calculate the SI Cost and SK Price.
   1. Check the Override Price checkbox so this price adjustment can be used to override the Base Price (P4106) record of 0.0001.
8. The Preference Hierarchy (P40073) for the Adjustment SKBASE picks the combination of Sold To Customer and Item Number first.
9. Setup a Price Adjustment Schedule (P4070) with the SKBASE adjustment on it.
10. The European Branch Plant Address 70 (SK Customer) will have Canadian Line of Business Record (0077) with CAD Currency (P03013)
11. The Customer 70 Line of Business Record 00077 has the Price Adjustment Schedule (SKSCH) populated that will be used for calculating the Cost on the Customer Order (SI) and the Price on the Interbranch Order (SK). (P03013)
12. The Price Adjustment Detail (P4072) for adjustment SKBASE has two records setup as follows:
    1. Item 7077, Customer 70 (SK Interbranch Customer) Factor Value 16.080 CAD (SK Price)
    2. Item 7077, Customer 7059 (SI Actual Customer) Factor Value 30.000 EUR (SI Price)
    3. The client wants the 16.80 CAD price to be selected to determine the SI Cost and SK Price.
13. Create a SI Order (P4210) using an EUR Customer (7059) and EUR Branch Plant (70) in the header and the CAD Branch Plant 77 in the detail.
    1. The price of 30.00 for Customer 7059 is populated in the Unit Cost for the SI Order, which will be the Unit Price of the SK Order.

Cause

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