My Oracle Support Banner

E1: 12: Overview Fixed Assets Automatic Accounting Instructions (AAIs) (P0012) (Doc ID 626062.1)

Last updated on JULY 10, 2023

Applies to:

JD Edwards EnterpriseOne Fixed Assets - Version XE and later
Information in this document applies to any platform.

Purpose

Overview

Many JD Edwards EnterpriseOne programs need information about the account structure and specific account values to process business transactions properly. You define the account structure and specific account values using AAIs. The system stores the AAI values that you define for the company in the Automatic Accounting Instructions Master table (F0012). Whenever a program performs an accounting function, it accesses this table.  Make sure that the object accounts are either 4 or 5 digits but not both.  If there is left over demo data that doesn't fit into your structure make sure and remove it.  Object accounts like 2310 are seen as object account 23100 when the system is setup to use a 5 digit object.

Some of the fixed assets AAIs can be set up as specific to the company, based on ranges of account numbers. The system includes predefined ranges. You must specify the business unit, object, and subsidiary accounts for the ranges as necessary.

The system uses single AAI values to find individual accounts and AAI ranges to find account ranges. When you set up AAI ranges, note that:

For example, do not set up FX range 01-02 and FX range 05-06, and leave FX range 03-04 blank for later use. If the system searches the AAIs for an account and finds a gap in a range, it stops searching.

Set up these AAI ranges for the JD Edwards EnterpriseOne Fixed Assets system:

AAIs
AAI RangeDescription

FX

Identifies accounts that post to fixed assets and equipment.

FA

Identifies accounts for which the system can automatically create any necessary asset master records when you run a post to fixed assets.

FC

Identifies asset cost accounts.

FD

Identifies accumulated depreciation accounts.

AT

Identifies accounts and descriptive text that define totals for summary reporting.

SDA

Identifies the secondary accumulated depreciation account.

SDE1

Identifies the secondary depreciation expense account.

SDE2

Identifies the tertiary depreciation expense account.

DS1 - DS4

Identifies depreciation statistics accounts.

DSA

Identifies the asset balance for the specified ledger type.

FR1 - FR3

Identifies revaluation offset accounts.

 

Important! Many programs in the JD Edwards EnterpriseOne Fixed Assets system use specific AAIs and AAI ranges.  It is recommend that these not be changed unless a clear understanding of the system exists.  Please be very familiar with the use of an AAI or AAI range before changing any of the AAI values. 

TRY NOT TO MAKE RANGES LARGER THAN NEEDED. INCLUDE ONLY THE FIXED ASSET ACCOUNTS!  The object accounts that are included in the fixed assets AAI ranges are assumed to be fixed asset accounts, therefore, make sure they relate to fixed assets and not other systems. 

 

Important! If Changes are made to any of the AAIs!

Please have the IT department clear cache, then sign back onto the system.

Clearing HTML Cache

  1. Sign in to the Server Manager

    2. Select the appropriate EnterpriseOne HTML Server link

    3. Under the section Runtime Metrics on the left-hand side, select: JDBj Database Caches

    4. Select all option, then deselect Serialized Objects, and press the Clear Cache button

Table cache

1. Sign in to the Server Manager

2. Select the appropriate EnterpriseOne Enterprise Server option for the correct enterprise server

3. In the top-left hand corner, select the link Table Cache

4. Input the appropriate table and environment name and press the Clear Table Cache button

Run the R12920-Balance Character Code Update if changes were made to the SDA, SDE1 or SDE2.

Scope

Automatic Accounting Instructions (AAIs) are set up on the Fixed Asset System Setup menu (G1241).  Fixed Asset AAIs must be set up before asset masters are added or any other fixed asset transactions are processed.  This document discusses each fixed asset AAI and the correct setup.

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
 Overview
Scope
Details
 FX AAIs
 FA AAIs
 FC AAIs
 FD AAIs
 AT AAIs
 AAIs for User-Defined Depreciation
 FR1 - FR3 AAIs
References

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