My Oracle Support Banner

WS: 42: Troubleshooting Sales Update (P42800) (Doc ID 1547894.1)

Last updated on JANUARY 24, 2023

Applies to:

JD Edwards World Sales Order Management - Version A7.3 cume 4 and later
Information in this document applies to any platform.


This document provides assistance in troubleshooting common issues encountered when running Sales Update (P42800).  Includes details on how to correct errors and issues encountered when running Sales Update.


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
 Sales Update Issues
 Issue 1: Duplicate F0311 and F0911 Records or the Amounts in the F0311 and F0911 are Doubled
 Issue 2: F0311s, with no F0911s
 Issue 3: F0911s, with no F0311s
 Issue 4: Sales update stopped in the middle of running
 Issue 5: Tax File (F0018) Not Populating
 Issue 6: Status went to 999 but no F0311, F0911, F41021, or F4111 records were created.
 Issue 7: Sales Detail Not Purged To History
 Issue 8: Some batches post with summary AEs and some with detail AEs. A/R constants is set to summarize AEs (Offset Method equals B).
 Issue 9: P42800 Sales Update creates a joblog (or job log).
 Issue 10: Journal entries are out of balance because Free Goods are not writing to A|R.
 Issue 11: P42950 Cost Update does not run from Sales Update.
 Issue 12: Sales Update creates a zero dollar JE for a zero dollar SO even though the XT0911Z1 is set to Not create zero dollar JEs.
 Issue 13: Sales Update is creating additional line items on the invoice in the Accounts Receivable system for an amount in excess of the sales order.
 Issue 14: The Application Constants were set to not require Management Approval for Sales batches; however, the batches are marked pending instead of approved.
 Issue 15: Consolidated Invoice is Not Summarized by Sales Update
 Issue 16: Item Ledger records (F4111) created by Sales Update have zero quantity and extended cost.
 Issue 17: Duplicate pay items in the F0311 AR file for one invoice.
 Issue 18: After running Sales Update (P42800), the cost of an item is zero. 
 Issue 19: Receiving Error 2369 - Tax Service Date is Invalid or Missing at Sales Update P42800 for two freight lines.
 Miscellaneous Errors
 Error 0002: DCT DOC SFX
 Error 0025:  Data Dictionary Values
 Error 2362:  Document Type Invalid
 Error 2514:  Alpha Explanation Cannot be blank  (double byte only)
 Error 0027:  User Defined Code Error
 Error 009U:  Agreement Number is Required
 Error 3208:  Inactive Subledger Entered
 Error 3490:  AN8 - Customer Master Information Missing
 Error 3482:  AN8 - Address Cannot Vary Data Type: 0311 Data Item: AN8 - Address Number
 Error 1837:  Suspend A/R Code Active Data Type: 0311 Data Item: AN8 - Address Number
 Error 0085:  The discount amount is greater than the gross amount
 Error 0069:  Posting Edit Code Does Not Allow Entry
 Error 3475:  Key Company Cannot Vary
 Error 3479:  Exchange Rate Cannot Vary
 Error 3740:  Customer Amounts Server Call Invalid.
 Error 2362:  The entered Document Type is Invalid
 Error 0726:  You are not authorized to the Business Unit entered
 Error 1837:  Suspend A/R Code Active
 Error 2486:  Payment Instrument is Invalid
 Error 4668:  Trade Account Currency Incorrect
 Error 4382:  Non-posting Business Unit
 Error 4161:  Unit of Measure Conversion Error
 Error 0388:  Subledger Invalid
 Error 2405: Discount Taken/Lost Currency Incorrect
 AAI Errors
 Error 0028:  Account Number Invalid
 Error 2976:  AAI for G/L Class Code Invalid.
 Error 0381:  AAI Account Not Setup Data Type: 0911 Data Items: AAI/CO/DCT/GL Class
 Error 2977:  The Account Number associated with the Automatic Accounting Instruction (AAI) for the G/L Class Code is invalid
 Error 2973:  Gain/Loss and/or Discount AAIs Invalid
 Error 2974:  AAI Account for Discount Invalid
 Error 1115:  Company Currency Code Invalid
 Date Errors
 Date Error: 0000 -  Date is in Future Fiscal Year
 Date Error: 0272 2367 2368 2369 2370
 Date Error: 3481 3483 DG DI 0311
 Date Error: 0066 DGJ 0311
 Date Error: 0064 - Prior End Balance Forward Invalid
 Date Error: 0065 - Date is in this Yr but Prior Month
 Date Error: 3355 and 3356
 Tax Errors
 Tax Error: 1002 2106 1480
 Tax Error: 1829 TXA1 0311
 Tax Error: 0272 TXA1 0311
 Tax Error: 2527 2528 AG 0311
 Tax Error: 2528 - Taxable Amt Greater Than Gross (AG and ATXA)
 Tax Error: 0748 -  Tax Explanation Code Invalid
 Tax Error: 0812 - Tax Amount Invalid  WARNING
 Tax Error: 1002 - Tax Amount is Understated 
Tax Error: 2106 - Tax Amount Invalid
 Tax Error: 1614 - Tax must be 0 for tax exempt
 Tax Error: 012M - Taxable Amount Must Be Entered

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