WS: 42: Troubleshooting Sales Update (P42800)
(Doc ID 1547894.1)
Last updated on MAY 23, 2024
Applies to:
JD Edwards World Sales Order Management - Version A7.3 cume 4 and laterInformation in this document applies to any platform.
Purpose
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.
Details
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 |
| Details |
| 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 |
| References |