My Oracle Support Banner

E1: 42: Sales Update (R42800) Does not Use G/L Offset From the Customer Master (F03012) and Ends in Distribution AAI Number 4245 Invalid Error (029P) (Doc ID 2975581.1)

Last updated on NOVEMBER 01, 2023

Applies to:

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

Symptoms

When processing Sales Updated (R42800) with the Processing Option "Bypass Update to Accounts Receivable" active, the system creates the following error in the Work Center:

Distribution AAI Number 4245 Invalid (Error ID 029P)
The Automatic Accounting Instruction (AAI) number 4245 used by this application is not defined in the Distribution/Manufacturing AAI table.


The Customer Master (P03013) has a G/L Offset value, but the Work Center message shows that the system does not fetch this value. Instead, Sales Update appears to be validating against a GL Category Code that does not exist in DMAAI 4245.

Steps to Duplicate:

  1. Inquire on the Customer Master (P03013) for the default company; verify the G/L Offset value that is used.
  2. Inquire on DMAAI 4245 (Accounts Receivable Trade).
    1. Filter on the company, Order Document Type and G/L Category (offset) value used in step 1.
    2. Make sure there is a valid account for they keys.
  3. Create a Sales Order (P4210) for the customer used in step 1.
  4. Run Sales Update (R42800) where processing option 2 in the Update tab is active: Bypass Update to Accounts Receivable (F0311).
  5. Inquire on the Work Center and note the following error:
Distribution AAI Number 4245 Invalid (Error ID 029P)
The Automatic Accounting Instruction (AAI) number 4245 used by this application is not defined in the Distribution/Manufacturing AAI table.

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.