Defining Flexible Account Numbers
Access the Flexible Sales Account Revisions form.
- AAI Table Number
Enter a number used to specify sequence and retrieve accounting information.
- AAI-Financials
Review the hard-coded field that defines an account or range of accounts used for a particular function. For example, item GLG4 defines the retained earnings account that the system uses for annual close purposes. During processing, programs use the item number and company number to find the correct account to debit or credit. Along with company, the item (or range) is the key to the AAI table.
- Object Acct From/To (object account from/to)
Enter the beginning and ending object accounts to represent a range of accounts. The system allocates only amounts posted to accounts in this range.
- Adjustment Name
Enter a value from UDC 40/TY that identifies an adjustment definition. You define adjustments in the Price Adjustment Definition program (P4071).
For JD Edwards EnterpriseOne Agreement penalty schedules, add a definition for each of the four types of penalties:
Minimum quantity
Maximum quantity
Under commitment
Over commitment
- Subledger Type
Enter a value from UDC 00/ST that the system uses with the Subledger field to identify the subledger type and how the system performs subledger editing.
On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include:
A: Alphanumeric field, do not edit.
N: Numeric field, right justify and zero fill.
C: Alphanumeric field, right justify and blank fill.
- Business Unit
Enter an X to indicate that this segment of each general ledger account number is stored as part of the Business Unit field in the database. For flex account numbers, you can define up to six segments and use a total of 12 characters for the Business Unit field.
If you define multiple segments for the business unit, the system concatenates them left to right in ascending order according to their assigned sequence numbers. The resulting number is right-justified in the database field.
- Subsidiary
Enter an X to indicate that this segment of each general ledger account number is stored as part of the Subsidiary Account field in the database. For flex account numbers, you can define up to four segments and use a total of eight characters for the Subsidiary Account field.
If you define multiple segments for the subsidiary account, the system concatenates them left to right in ascending order according to their assigned sequence numbers. The resulting number is left-justified in the database field.
- Subledger
Enter an X to indicate that this segment is stored as part of the Subledger field in the database.
If you define multiple segments for the subledger, the system concatenates them left to right in ascending order according to their assigned sequence numbers. The resulting number is left-justified in the database field.
- Item
Enter an X in the item column to associate a flex rule with the item number.
- Cost Object
Enter a value that indicates which cost object is populated with a particular segment. Values are 1, 2, 3, and 4.
- Cost Type
Enter a code that specifies the type of cost object and the type of editing. The system stores valid types in the Cost Object Types table (F1620). You can add or modify the cost types using the Cost Object Types program (P1620).
- File Name
Enter the number of a specific table. For example, the Account Master table name is F0901.
- Data Item
Enter a code of a specific data item from the table specified in the File Name field. For example, if you enter F0901 in the File Name field, you can enter any field within the table, such as R001, in the Data Item field.
- Data Type
Enter a code that identifies the address that the system uses in flexible sales accounting. Valid values are:
1: Bill To
2: Ship To
3: Parent
The system uses this code with the Data Item field.
If the value in the Data Item field is from the Address Book Master table (F0101), then the Data Type field is required.