My Oracle Support Banner

E1: AAI 4226 and 4228 Errors (029P) During Sales Update (R42800) for Non-Stock Line (Doc ID 2778759.1)

Last updated on JULY 14, 2021

Applies to:

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

Symptoms

After upgrading to 9.2, when attempting to process a sales order line with a non-stock line type through Sales Update (R42800) some jobs fail and send errors to the work center as follows:

WORK CENTER ERRORS
AAI Number 4226 Invalid (Error ID 029P)
CAUSE : The Automatic Accounting Instruction (AAI) number 4226 used by this application is not defined in the Distribution/Manufacturing AAI table.
RESOLUTION : Review the AAI that is not set up correctly using the Distribution/Manufacturing AAI maintenance application and set up or modify the required data.
Check the information for Company XXXXX , Order Type XX and GL Class code XXXX.

AAI Number 4228 Invalid (Error ID 029P)
CAUSE : The Automatic Accounting Instruction (AAI) number 4226 used by this application is not defined in the Distribution/Manufacturing AAI table.
RESOLUTION : Review the AAI that is not set up correctly using the Distribution/Manufacturing AAI maintenance application and set up or modify the required data.
Check the information for Company XXXXX, Order Type XX and GL Class code XXXX.

The issue can be reproduced in the Oracle Support Test Environment with the following steps:

  1. Create a new Item Master (P4101) record (NS-59-ZBA) with Stocking Type and Line Type to S (Stock Inventory Item).
  2. Set the Item Cost (P4105) Sales/Inventory Cost Record to 25.00 with Cost Method (02 – Weighted Average Cost).
  3. Perform an Inventory Adjustment (P4114) for a quantity of 1 item at a cost of 25.00.
  4. Setup Line Type Constants (P40205) for Line Type NM with Inventory Interface = N (Non-Stock) with the Edit Item Master For Non-Stock Items checkbox checked.
  5. Create Order Activity Rules (P40204) for Order Type S1 Line Type NM.
  6. DMAAI 4226 (Inventory – Zero Balance Adjustment) has no G/L information setup for the S1 Order Type.
  7. DMAAI 4228 (COGS - Zero Balance Adjustment) has no G/L information setup.
  8. Create a version of SO Entry (P4210) with S1 Order Type and NM Line Type.
  9. Create a version of Powerforms SO Entry (P42101) that calls the P4210 Version.
  10. Create the S1 Sales Order with NM Line Type. Price is 140.00. Unit Cost is defaulted as 25.00.
  11. Take the Zero Cost Row Exit to Zero out the cost and save the order.
  12. Run Invoice Print (R42565) and note the Invoice Number.
  13. Process the Invoice through Sales Update (R42800). Sales Update (R42800) PDF shows the job failed.
  14. The Work Center shows the error Distribution AAI Number 4226 Invalid (Error ID 029P). Since the line is non-stock, the program should not be checking the  DMAAI 4226 (Inventory – Zero Balance Adjustment) because the quantity in inventory should not be reduced to zero by the non-stock transaction.
  15. The work center also has Distribution AAI Number 4228 Invalid (Error ID 029P) error.

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
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.