My Oracle Support Banner

E1: 42: Sales History Summary (F4229) Records do not Balance to Sales Order Detail History (F42119) (Doc ID 2913319.1)

Last updated on DECEMBER 03, 2022

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Customer is trying to figure out why their Sales Order History File (F4229) quantity plus the summarized fields do not balance to their Sales Order Detail History (F42119) by item number, fiscal date/year, order type. Their processing options in Sales Update (R42800) are set to update F4229.  A review of records show the F4229 records are missing for a specific document type.


The issue can be reproduced at will with the following steps:

  1. In Sales Order Entry, P4210, create a sales order.
  2. Process the order through Sales Update, R42800, with the processing option active to Update Sales History Summary (F4229), option 5 on the Update tab.
  3. On the R42800 version, also ensure the Purge to Sales Detail History (F42119) processing option is set.
  4. Review the F4229 compared to the F42119. Note the quantities do not balance.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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