1. Sales Order Management Implementation Guide
  2. Understanding Flexible Account Numbers

Understanding Flexible Account Numbers

You use flexible sales accounting to create a flexible format for account numbers in the chart of accounts. Flexible account numbers use the standard JD Edwards EnterpriseOne format, which has three segments:

  • Business unit

  • Object

  • Subsidiary

The account number is displayed as Business Unit.Object.Subsidiary.The flexible format lets you configure each segment of the account number.

For example, you can use a format that includes more information, such as salesperson, branch, sales territory, and other address book category codes. Or you can set up the structure of the flexible account number based on how you track the performance of items and customers through sales detail and the general ledger.

The standard account structure is formatted with these segments:

  • Business unit

  • Object account

  • Subsidiary account

  • Subledger

Flexible format accounts have the same segments. The length of all segments cannot exceed 34 characters. Each segment of the flexible format account has a character limit:

  • Business unit: 12 characters.

  • Object account: 6 characters.

  • Subsidiary account: 8 characters.

  • Subledger: 8 characters.

To create a flexible account number, you define one or more of these segments. Each of these fields is hard-coded in UDC table 40/DI. You can view valid fields in the Flexible Sales Accounting program (P40296). You associate one or more pieces of information with each segment. Each piece of information is associated with a field and is stored in a table. The tables are different for each application.

To associate information with a segment, you must know the data item name, or alias, that is associated with the corresponding field in the table.

Note:

To use a field that is not included in these tables, you must develop custom programming.

You cannot define an object segment. You must define the object account through automatic accounting instructions (AAIs).

The subledger account is not visible online, but is stored in the Account Ledger table (F0911).

You activate flexible sales accounting through the processing options for the Sales Update program (R42800).

Before you create a flexible account number, consider these points:

  • Use a consistent account structure.

    You must use the same account structure for all companies and all business units in the organization. This is necessary for multicompany consolidations and automated intercompany settlements.

    If you use flexible accounting in JD Edwards EnterpriseOne Financial Management from Oracle, the business unit and subsidiary account that you define through distribution flexible sales accounting must have the same number of characters as the business unit and subsidiary account that you define through financial flexible accounting.

  • Define one subledger per account.

    You can define only one subledger type for each account. You should review the account structure before you set up flexible accounts to determine how you use subledgers.