My Oracle Support Banner

E1: 45: Sales Order Batch Price/Cost Update (R42950) FAQ (Doc ID 1464164.1)

Last updated on JULY 21, 2020

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version XE and later
JD Edwards EnterpriseOne CRM Sales Order Entry - Version XE and later
JD Edwards EnterpriseOne Sales Order Processing - Version XE and later
JD Edwards EnterpriseOne Sales Order Entry - Version XE and later
Information in this document applies to any platform.

Purpose

This document provides answers to frequently asked questions about the setup and processing logic of Sales Order Batch Price/Cost Update (R42950). Please refer to Document 625619.1 E1: 42: R42950: Update Sales Price/Cost for a functional overview.

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
Purpose
Questions and Answers
 Cost Updates
 Question 1: Is there a way to run Sales Order Batch Price/Cost Update (R42950) to update the cost after Ship Confirm (P4205) to make sure the latest cost is on the sales order when Sales Update (R42800) is run?
 Question 2: How does Sales Order Batch Price/Cost Update (R42950) affect a Direct Ship Order (SD/OD)?
 Question 3: How does Sales Order Batch Price/Cost Update (R42950) affect a Transfer Order (ST/OT)?
 Question 4: Why is the SDKITID cleared or zeroed out when running R42950 to update the cost for an order containing a kit?
 Price Updates
 Question 1: How does Sales Order Batch Price/Cost Update (R42950) affect a Transfer Order (ST/OT)?
 Question 2: When running Sales Order Batch Price/Cost Update (R42950) to update the price on a transfer order, the system is using the Item Price (F4106) price instead of the Item Cost (F4105) cost. Why?
 Question 3: Is it possible for Sales Order Batch Price/Cost Update (R42950) to create a separate line for the price difference when a price has been changed?
 Question 4: A few customers want prices based on Ship Date. The other customer's prices are based on Order Date. The system constants are set with the Price Effective Date based on the order date. How can the two requirements be accommodated?
 Question 5: Is it possible to run the Sales Order Batch Price/Cost Update (R42950) program to update advanced pricing adjustments on a configured item?
 Question 6: If a unit price is not found in the base price table (F4106), will the Sales Order Batch Price/Cost Update (R42950) change the price on the line to ‘0’ or is no update made, leaving the existing price? 
 Question 7:  When Sales Order Batch Price/Cost Update (R42950) is run against orders which have Basket or Order Level Adjustments added by the Basket and Order Reprice program (R42750), are the Basket or Order adjustments cleared or recalculated?
 Question 8: When running Sales Order Batch Price/Cost Update (R42950) on a Transfer Order after the OT purchase order was received into receipt routing, why isn't the related OT purchase order cost  updated?
 Question 9: Does the Sales Order Batch Price/Cost Update (R42950) update price in the prepayment table (F004201) if the order is associated with pre-payment process?
 Exchange Rate Updates
 Question 1: How does the Sales Order Batch Price/Cost Update (R42950) affect a Direct Ship Order (SD/OD)?
 Question 2: How does the Sales Order Batch Price/Cost Update (R42950) affect a Transfer Order (ST/OT)?
 Question 3: What functionality is provided by the Intercompany Exchange Rate processing option (Process Tab Option 3) on the Sales Order Batch Price/Cost Update (R42950)?
 Subsystem Processing
 Question 1: What data selection should be used by Sales Order Batch Price/Cost Update (R42950) when it runs in subsystem?
 Question 2: How should the Sales Order Batch Price/Cost Update (R42950) subsystem version be set to run behind Ship Confirm (P4205)?
 Question 3: Can Sales Order Batch Price/Cost Update (R42950) subsystem version be called from Batch Shipment Confirmation (R42500)?
 Cost and Price Override Flags
 Question 1: How does the Cost Override (CSTO) field from Sales Order Detail (F4211) impact the Sales Order Batch Price/Cost Update (R42950)?
 Question 2: How does the Price Override (PROV) field in the Sales Order Detail (F4211) table impact the Sales Order Batch Price/Cost Update (R42950)?
 Question 3: How does the system populate value <1> on the Price Override (PROV) field in the Price Adjustment Ledger (F4074)? When this field is set to 1 the Sales Order Batch Price/Cost Update (R42950) does not update the price on the sales order detail line (F4211) that has the price adjustment. Is this functioned as designed?
 Other
 Question 1: Why is Sales Order Batch Price/Cost Update (R42950) calling the Commitments (R42997) program?
 Question 2: Does the Sales Order Batch Price/Cost Update (R42950) update prices on Sales Quote (type SQ) or Blanket Orders (type SB)?
 Question 3: After the R42950 is run over an order containing free goods line(s), it is possible for new free goods lines to be generated, due to a line split of the related 'saleable' lines on the sales order. Occasionally, the Next Status of the new free goods lines is not the same as the original free goods lines. Why does this happen?
 Question 4: If R42950 does not actually update a price, cost, or exchange rate on the sales order, is it possible to prevent the system from updating the F42199 Sales Order Detail Ledger File?
References

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