My Oracle Support Banner

E1: 42: Sales Update FAQ (R42800) (Doc ID 1401653.1)

Last updated on SEPTEMBER 19, 2023

Applies to:

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


This document provides answers to some frequently asked questions on Sales Update (R42800).

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
 Question 1 - Why would R42800 create F03B11 records with no F0911 records?
 Question 2 - Why did the order status advance to 999 with no F03B11, F0911, F41021, or F4111 records created?
 Question 3 - When Sales Update (R42800) is run, where are the Payment Terms and Payment Instrument retrieved from to create the Customer Ledger (F03B11) record?
 Question 4 - Why does the subledger still get populated on the F0911 even when the processing option is set to not create subledger entries?
 Question 5 - Is the consolidation of invoices an available option only for R42565 but not R42800?
 Question 6 - Why is sales update not purging data to F42019/F42119 even though the processing option values are set to purge the sales orders?
 Question 7 - How can zero price lines be prevented from generating a line in the AR table F03B11?
 Question 8 - Why is the hard commit in F41021 for new lot (created during ship confirmation) not getting relieved during sales update process for credit orders?
 Question 9 - How does Sales Update (R42800) process back orders? Is there any special logic for back orders in R42800?
 Question 10 - How does the F0911 Alpha Explanation (EXA) field get populated by Sales Update (R42800)?
 Question 11 - Why will Sales Update (R42800) terminate in memory violation / memory allocation failure when run against thousands of sales orders (DOCO numbers) with hundred thousands detail lines, but works fine when the same data is processed in small batches?
 Question 12 - Under what circumstances does the Purchase Order field on the A/R Ledger (F03B11.PO) get populated?
 Question 13 - Is it possible to process sales order detail lines at status 999 through sales update again or override next status to other than 999 and reprocess?
 Question 14 - When orders are processed for revenue recognition, why doesn't the Sales Update pdf show the revenue recognition entries?
 Question 15 - How does the F0911 Explanation - Remark (EXR) field get populated by Sales Update (R42800)?
 Question 1 - Why is the Tax File (F0018) not populating?
 Question 2 - Sales Update completes with a blank report, other than header information, and sends work center messages indicating Tax amount greater than gross and Taxable amount greater than gross when processing a sales order for a tax rate indicating a negative total amount. Why?
 Question 1 - Can we process a sales order without affecting inventory so only the revenue (4230) is affected and not the inventory (4240) or COGS (4220) account?
 Question 2 - Why are the 4240 (Inventory) and 4220 (COGS) AAIs used for non-stock Items?
 Question 3 - How can an Invoice Transaction from sales order go to a different AR account based on a unique sales order type/AR document type?
  Question 4 - Why does Sales Update error on the sales tax DMAAI 4250 if the order is set as tax exempt? 
 Question 5 - Can you change the G/L Class code in P4210 (Sales Order Entry) so the RC AAI will use that value instead of the value from P03013 (Customer Master) during posting (R09801)?
  Question 6 - With Product Cost Detail checked in the branch plant constants and the Automatic Accounting Instructions P40950 set to make the cost type field available for the AAI 4220 what happens when there isn't a standard A1 cost simulated and frozen in the P30026 cost components?
 Writing Units to Journal Entries
 Question 1 - How is the unit information captured for Journal Entries?
 Question 2 - Is there any way to avoid having units written multiple times to the F0911?
 Question 3 - How are units applied to journal entries for Kit orders?
 Question 4 - How is the UOM populated to Journal Entries (F0911)?
 Question 5 - Can Advanced Pricing Adjustments cause G/L Units to be doubled or tripled at Sales Update (R42800)?
 Question 6 - What is the default G/L document type created in P0911 from running R42800 for ST orders and is there an option to change this default document type?

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