• Jde General Ledger

What is a Chart of Accounts? A chart of accounts provides the structure for your General Ledger accounts. It lists specific types of accounts, describes each account, and includes account numbers. A chart of accounts typically lists asset accounts first, followed by liability and capital accounts, and then by revenue and expense accounts. An account is a title that defines the types of transactions that are contained within it. The Open Accounts Receivable Trade Account is where all of the unpaid Accounts Receivable transactions reside. Once they are paid, the same transactions are then recorded as Revenue and Cash.

Designing the Chart of Accounts To design your chart of accounts:. Begin your initial design with the major headings of your transactions. Then add your detailed transaction descriptions.

A Chart of Accounts is generally divided into major groups of accounts. The grossest grouping are the Balance Sheet and the Income Statement or Profit and Loss Statement. The Balance Sheet always precedes the Income Statement especially in JDE. Within those major groupings there are more groups, each defining the amounts into more detailed groups. The most common structure of a Chart of Accounts follows these major groups.

JD Edwards EnterpriseOne Documentation. Oracle's JD Edwards EnterpriseOne is an integrated applications suite of comprehensive enterprise resource planning software that combines business value, standards-based technology, and deep industry experience into a business solution with a low total cost of ownership. Oracle's JD Edwards EnterpriseOne General Ledger. Trial Balance with Ledger Comparison—Review a trial balance for any set of accounts, and compare balances with an alternate ledger such as a budget ledger. Work with Account Ledger—Review detailed transactions for an account by date range, subledger, and ledger type.

This is where the daily transactions of running the Company are recorded; Sales of goods or services and the cost, Expenses, incurred to make those goods or provide the services. These are broken down even more to be able to track the income and/or expenses for a particular product or service. Usually also related to a specific Department or Warehouse or Job. Obviously, the difference between Revenue and Expenses equals Profit.

Setting the Chart of Accounts up in JDE The Account Structure in JDE is Business Unit, period, Object Account, period, Subsidiary Account. Business Units describe where in your organization the transaction will have an impact. It represents the lowest organizational level within your business where you record all revenues, expenses, assets, liabilities, and equities. Business units typically represent a location, department, work center, or job, etc. The Object Account is the type of monies.

It could be Cash or Open Accounts Receivable or Transistor Sales. It will be used as the description of the transaction.

It is strongly recommended that the same numbering and description be consistent for all companies and business units for consolidation roll ups. More on that later. The Subsidiary Account is the optional part of the Account Number. It is used in the General Ledger as a further breakdown of the Object Account; Cash as the Object with a subsidiary dividing up the different bank accounts, for example, Cash in Bank of America. In Job Costing, the Subsidiary is used to define the Phase of a Job and that discussion is out of the scope of this document. Here is a portion of a well-defined Balance Sheet. In JDE there are two other fields that can be used to further define the account: Alternate Account and Subledger.

Alternate Object.Subsidiary (obj.sub) can be used to comply with a regulatory chart of accounts, parent company requirements, a third-party coding scheme, or as the account number from a prior system used as a cross reference. Subledgers – Another further division of data. Subledger values must be defined to the system as the values used in the subledger are validated by type. If the subledger is an Address Book Number, that Address Book Number must exist in the Address Book Master before it can be used. There is a unique system-assigned Short Account ID assigned to each unique combination of Business Unit, Object, and Subsidiary. Balances are stored by this unique key. However, subledgers are an additional field which equates to an additional balance.

In other words, the unique combination in the table above, 1.3005.004, would have a Short Account ID of, for example, 00801045 (this is an alphanumeric value so leading zeros are significant). That has a single balance record per Fiscal Year per Ledger Type. However, if I were to decide to use a subledger with that account, the Short Account ID would still be 00801045 and there would be an additional balance per Fiscal Year per Ledger Type for 1.3005.004 subledger xxxxxxxx.

There are two more very important fields in the JDE Chart of Accounts: Posting Edit Codes and Levels of Detail. POSTING EDIT CODES (PEC) Posting Edit Codes are used to indicate the different usages of the accounts for functions such as headings, accounts reserved for budgeting only or system-generated amounts only. Assign a posting edit code to every object or object.subsidiary account in the chart of accounts. This code determines whether the account posts to the General Ledger and whether it updates the Account Balances table (F0902).

Jde General Ledger

Valid Posting Edit Codes and their purpose are defined in this table: JDE Help Text explaining the Codes listed above. Revenues. Direct costs. General and administrative expenses.

Other income and expenses EXAMPLES OF LOD 3: Assets, Liabilities, Revenues, Expenses. 4: Current Assets, Fixed Assets, Current Liabilities, and so on.

5: Cash, Accounts Receivable, Inventories, Salaries, and so on. 6: Petty Cash, Cash in Banks, Trade Accounts Receivable, and so on.

7: Petty Cash – Corporate, Petty Cash – Branch, and so on. REQUIREMENTS. Balance Sheet must be first.

Last Balance Sheet account must be Net Income with a Posting Edit Code of ‘N’, Non-posting. The system calculates Net Income on the Balance Sheet.

Next to last Balance Sheet account needs to be Retained Earnings. This must have a Posting Edit Code of ‘M’, Machine Generated.

Account Numbers are sequential – Balance Sheet from 1000 – 4999, Income Statement from 5000 on up, for example RECOMMENDATIONS. Provides reporting flexibility without changing the Chart of Accounts. Record Category Code usage in the Model and in documentation available to personnel that will be responsible for maintenance of the COA UNDERSTANDING A MODEL CHART OF ACCOUNTS Create one master model business unit that includes the complete chart of accounts or create a model business unit for every business unit type and assign object accounts to it. You can then use these models as a basis for your actual chart of accounts. By creating a model chart of accounts, you ensure that when you copy the accounts from the model business units into your actual (or production) business units, the accounts are standardized across business units and companies. You should create your model chart of accounts using a consistent numbering scheme for your object accounts so that they can be copied across all business units.

After you enter the business unit, object account, and subsidiary information for a new account, you can add a comment, memo, or other text. Carefully proofread your model chart of accounts to ensure that the descriptions, spelling, level of detail assignments, and posting edit codes are accurate.

The model chart of accounts provides the basis for your entire chart of accounts. Revise accounts as needed to correct errors before you copy the model accounts to business units. Copying the model reproduces any errors in multiple business units. Some businesses need an alternate way to set up a chart of accounts. For example, some countries require businesses to submit reports using a government-defined (statutory) chart of accounts. You can use account category codes to set up an alternate chart of accounts that accommodates government requirements. UNDERSTANDING ALTERNATE CHART OF ACCOUNTS Using an alternate chart of accounts, you can:.

Roll up (summarize) accounts. Display subtotals. View several companies at one time. View accounts that make up an alternate account. View different levels of detail in other JD Edwards EnterpriseOne inquiry programs. You can display account balances by alternate or statutory accounts from the General Ledger Account Balance table. To do this, use one of the category codes that are set up for a statutory chart of accounts.

An account category code indicates your statutory account number and the category code description indicates the account description. You can assign one or more alternate account numbers to category codes 21, 22, and 23 (User Defined Code table (UDC) 09/21–09/23). These category codes allow up to ten characters. The system rolls up accounts that are based on the digit that you specify.

All accounts in which the digit matches are rolled together. For example, if you specify the third digit, then accounts from 1040000 through 1049999 are rolled together. You can review alternate accounts and account ledgers for one category code at a time. You specify the category code in the processing options. You can also review alternate accounts by company or organization structure, and you can review their balances online by company or organization structure. By doing this review, you can see several companies that comprise one legal entity. Watch the Video Tutorial!

Processing Online Consolidations Processing Online Consolidations This chapter provides an overview of organization report structures and discusses how to:. Create hierarchical organization report structures. Add organization report structures without using category codes. Review and rearrange organization report structure. Create additional business units and copy report structures. Create online consolidations.

Review online consolidations. See Also Understanding Organization Report Structures An organization report structure is a method of grouping business units for reporting purposes. It provides more flexibility in using online consolidations and reporting, which enables you to display summary-to-detail income statement information. It also facilitates printing subtotals and roll-up totals. Hierarchical Organization Report Structures You can create hierarchical structures for each business unit and across companies.

Each structure can contain multiple levels of parent, child, and grandchild relationships. For reporting purposes, you can organize the parent/child hierarchies based on structures that you define for financial, geographical, or responsibility reporting.

Parent/child hierarchies can be as simple or complex as you require. To create organization report structures, you create parent/child relationships for business units. Any business unit that is designated as a parent must be associated with a complete chart of accounts.

A parent business unit does not have to be a posting business unit. With organization report structures, you can:. Organize business units into multiple levels of parents and children. A business unit can be both a parent and a child, and each business unit can have multiple children.

However, a business unit cannot have a parent that is also a child of the same business unit. Add or revise parent-child structures at any time. For example, you can add children to an existing parent/child structure. Organization Report Structures Without Category Codes Alternatively, you can create an organization report structure by directly selecting business units for the structure. This method does not use category codes to create parent/child relationships for the business units. Prerequisites Before you complete the tasks in this section:. Determine the organization report structures to use for your business.

Set up the structure codes in UDC table 00/TS. Determine the business unit that is associated with each structure level. For each organization report structure that you want to create, create a pseudo consolidation company and determine the hierarchy to use for the category codes. Creating Hierarchical Organization Report Structures This section provides an overview of how to define and build organization report structures and discusses how to:. Define organization report structures.

Build organization report structures. Set processing options for Business Unit Structure Build. Understanding How to Define and Build Organization Report Structures To define an organization report structure, you assign category codes to business units using the Organization Structure Definition program (P0050B). The values of the category codes that you assign determine where the business unit appears in the hierarchy.

This program updates the Business Unit Structure Build File table (F0050B). After you define your organization report structure, run the Organization Structure Build program (R10450) to build it. You can run the Organization Structure Build program in proof or final mode. In proof mode, the system prints a report that shows the changes that will occur when you run the report in final mode. In proof mode, any business units that are dynamically created appear on the report as a concatenation of category codes, regardless of the setting of the BU Creation processing options.

In final mode, the system dynamically creates business units either by using next numbers or by concatenating category codes, depending on the setting of the BU Creation processing options. In final mode, the system updates the Organization Structure Master File table (F0050). Forms Used to Create Hierarchical Organization Report Structures Form Name FormID Navigation Usage Work With Structure W0050BB Advanced Organization Setup (G094111), Organization Structure Definition.

Locate organization report structures. Structure Setup W0050BA On Work With Structure, click Add. Define a hierarchical organization report structure. Defining Organization Report Structures Access the Structure Setup form. Type Sequence Enter a structure from UDC table 00/TS that identifies the type of organization structure, such as financial or responsibility.

Each type of organization structure can have a separate hierarchy. Sequence Enter the order in which the child business units appear when listed under their parent.

If you leave this field blank when you set up the organization structure, the system assigns the sequence number. Building Organization Report Structures Select Advanced Organization Setup (G094111), Organization Structure Build. Setting Processing Options for Business Unit Structure Build (R10450) Processing options enable you to specify the default processing for programs and reports.

Mode Specify the mode in which to process the consolidations: 0: Proof mode with report. 1: Final mode with update and report 2: Final mode with update and no report Structure Name 1. Structure Name Enter the name of the business unit structure type. BU Creation 1. Business Unit Creation Specify whether to dynamically create business units.

Values are: Blank: No dynamic business unit creation. 1: Dynamic business unit creation with concatenation of category code values to determine the new business unit. 2: Dynamic business unit creation with next numbering to determine the new business unit. Business Unit Type Enter the business unity type to use to create business units.

Pseudo Consolidation Company Enter the pseudo consolidation company to use for business unit creation. Adding Organization Report Structures Without Using Category Codes This section provides an overview of organization report structures without category codes and discusses how to add an organization report structure without using category codes. Understanding Organization Report Structures Without Category Codes You can add an organization report structure by selecting the structure type and then selecting the business units that appear in the structure. When you select a business unit for the structure, the system assigns a display sequence that you can change. This approach does not use category codes for sequencing and, therefore, does not require that you run the Organization Structure Build program to build the structure. The Organization Structure Inquiry/Revision. Program updates the F0050 table.

Forms Used to Add Organization Report Structures Without Category Codes Form Name FormID Navigation Usage Parent/Child Browse W0050C Advanced Organization Setup (G094111), Organization Structure Inquiry/Revision Review and rearrange organization report structures. Headerless Detail W0050B On Parent/Child Browse, click Add. Add an organization report structure by selecting business units. Adding an Organization Report Structure Without Using Category Codes Access the Headerless Detail form.

(display sequence) Enter the order in which the child business units appear when listed under their parent. If you leave this field blank when you set up the organization structure, the system assigns the sequence number. Reviewing and Rearranging Organization Report Structures This section provides an overview of organization report structure revisions and discusses how to review and rearrange organization report structure components. Understanding Organization Report Structure Revisions When you use the Organization Structure Inquiry/Revision program to review your report structure, the system displays your organizational structures in a tree format that you can expand or collapse at each level. Folder and document icons represent the levels of the structure.

A folder can contain folders or documents. Documents are the lowest level of the structure. You can revise an organizational structure by moving components of the structure to different locations within the hierarchy. You can move individual business units by dragging the corresponding documents and dropping them under a different parent. You can also move higher levels of the structure by dragging the folder that represents a parent business unit and its children. When you move a component of the structure, the system updates the F0050 table. Form Used to Review and Rearrange Organization Report Structures Form Name FormID Navigation Usage Parent/Child Browse W0050C Advanced Organization Setup (G094111), Organization Structure Inquiry/Revision Review and rearrange organization report structures.

Reviewing and Rearranging Organization Report Structure Components Access the Parent/Child Browse form. Creating Additional Business Units and Copying Report Structures After reviewing your organizational structure, you might decide to create additional business units or copy organizational report structures.

Use the Organization Structure Inquiry/Revision program (P0050) to perform these tasks and update the F0050 table. This section discusses how to:. Set processing options for Organization Structure Inquiry/Revisions. Create additional child business units. Copy report structures.

Forms Used to Create Additional Business Units and Copy Report Structures Form Name FormID Navigation Usage Parent/Child Browse W0050C Advanced Organization Setup (G094111), Organization Structure Inquiry/Revision Review and rearrange organization report structures. Headerless Detail W0050B From the Parent/Child Browse form, select the business unit to which you want to add a child business unit. Create additional business units. Copy Organizational Structure W0050F From the Parent/Child Browse form, select the business unit that you want to copy and then click Copy. Copy all or a portion of an existing organization report structure into a new organization report structure. Setting Processing Options for Organization Structure Inquiry/Revisions (P0050) Processing options enable you to specify the default processing for programs.

Structure Type 1. Initial Selection Values Enter values in the processing options to preload the corresponding fields on the Headerless Detail form. Manager Name 1. Display Manager's Name Specify whether to display the manager's name in the organizational structure tree.

Values are: 0: Do not display the manager's name. 1: Display the manager's name. Creating Additional Child Business Units Access the Headerless Detail form. When you add child business units, the system verifies that the parent and the child are not the same, and ensures that the business unit child is not also the parent. Parent Select this check box to see the parent of the business unit to which you are adding children. The parent business unit appears in the detail area. Select the Parent check box again to continue adding children.

Child Business Unit Enter the business unit of the child. (display sequence) Enter a number that represents the order in which the child business unit appears when listed under their parent. If you leave this field blank when you set up the organization structure, the system assigns the sequence number.

Copying Organization Report Structures Access the Copy Organizational Structure form. Ensure that the organization report structure to which you are copying exists in UDC table 00/TS but does not exist as a structure in the F0050 table. To Type Structure A code from UDC table 00/TS that identifies the type of organization structure, such as financial or responsibility.

Each type of organization structure can have a separate hierarchy. Copy Entire Structure or Copy Selected Tree Only Specify whether to copy an entire organization report structure or only a portion of the structure. Select the Copy Entire Structure option to copy every level of the From Type Structure value to the To Type Structure value, regardless of the level that you selected on the Parent/Child Browse form. Select the Copy Selected Tree Only option to copy only the selected parent business unit and its children from the From Type Structure value to the To Type Structure value. Creating Online Consolidations This section provides an overview of online consolidations creation and discusses how to consolidate business units. Understanding Online Consolidation Creation After creating your organization report structures, you can create your online consolidation.

In addition to creating an online consolidation based on an organization report structure (parent business unit method), you can also create one using the category code method. The category code method enables you to consolidate business units by company, category code, and value.

However, this method enables you to use only 4 category codes for the structure. Example: Consolidating Business Units by Category Code This graphic illustrates how you can consolidate business units by category code: Consolidation by category code Example: Consolidating Business Units by Organization Report Structure This graphic illustrates how you can consolidate business units by organization report structure: Consolidation by report structure Forms Used to Create Online Consolidations Form Name FormID Navigation Usage Work With Online Consolidations W09218D Consolidations (G1011), Online Consolidations. Locate and review online consolidations. Review Online Consolidation W09218B On the Work With Online Consolidations form, click Add.

Create online consolidations. Consolidating Business Units Access the Review Online Consolidation form. Consolidation Enter the name that corresponds to the consolidated business unit (up to 10 characters). To consolidate business units by organization report structure, enter values in the Type Structure and Parent Business Unit fields. Company and Category Code (optional) Enter a company and a category code (01–30) in these fields to consolidate business units by company and category code. Type Structure and Parent Business Unit Enter the type structure from UDC table 00/TS and the primary business unit in the hierarchy to consolidate business units by organization report structure.

Category Code Method, Parent Business Unit Method, or Masked Business Unit Method Select one of these options: Category Code Method. This method consolidates based on business unit category codes. Parent Business Unit Method.

This method consolidates based on organization type structure and a parent business unit. Masked Business Unit Method. This method consolidates based on business units that match character position values.

Menu Selections After you determine your choices for consolidation, access these menu selections from the Form menu: Store Inquiry Save your criteria. This information is stored in the Online Consolidations Set-up table (F09218). Refresh BU (refresh business units) Process account balances. The processing time depends on the number of business units and associated accounts that you are consolidating. This information is stored in the F09218 table. Online Statements Create consolidated financial statements. Reviewing Online Consolidations After a consolidation has been created, you can review consolidated information online without recreating the consolidation criteria.

Using the consolidations that you created, you can review consolidated information for a trial balance, balance sheet, or income statement. This section provides discusses how to:. Set processing options for Online Consolidations. Review consolidated financial statements online. Forms Used to Review Online Consolidations Form Name FormID Navigation Usage Work With Online Consolidations W09218D Consolidations (G1011), Online Consolidations.

Locate online consolidations. Online Consolidated Financial Statements W09218J On the Work With Online Consolidations form, select the consolidation that you want to review and then select Online Statements from the Row menu. Review online financial statements for consolidations. Setting Processing Options for Online Consolidations (P09218) Processing options enable you to specify the default processing for programs. Ledger Type 1. Ledger Types Enter the default ledger types in these processing options.

Ledger Type - Column 1. If you leave this processing option blank, ledger type BA is used. Ledger Type - Column 2. If you leave this processing option blank, ledger type AA is used. Exit With Ledger Type Specify the ledger type to use when exiting to another application: Blank or 1: Ledger Type 1. 2: Ledger Type 2.

Suppress Zero Balances Specify whether to display accounts with zero balances if the Business Unit Detail option is not selected. Values are: Blank or N: Display accounts with zero balances. Y: Do not display accounts with zero balances. Calculation Method Specify the calculation method to use for calculating variances.

Values are: A: Addition Blank or S: Subtraction M: Multiplication D: Division. Additional LT 1. Additional Ledger Types Specify additional ledger types to use for calculating account balances for Ledger Types 1 and 2. If you leave these processing options blank, no additional ledger types are used. Subledger Subledger and Subledger Type Enter the subledger and subledger type to use for calculating account balances. If you leave these processing options blank, the system uses a subledger and subledger type of blank.

Account LOD Account Level of Detail Enter the account level of detail (3–9) to use. If you leave this processing option blank, 9 is used. Currency Code 1. Currency Code Enter the currency code to use for calculating account balances.

If you leave this processing option blank, all currencies are used. Use this processing option only if you use multicurrency processing.

Business Unit Detail Specify whether to display business unit detail. Values are: Blank or N: Do not display business unit detail. Instead, combine business units. Y: Display business unit detail. Process Mode 1. Financial Statement Processing Mode Specify the processing mode for the consolidated financial reports.

Values are: Blank or T: Trial Balance. B: Balance Sheet. I: Income Statement Date Effective 1. Date Effective and 2. Date Effectivity For future use. Exclude Blank Object Account Specify whether to exclude blank object accounts: Values are: Blank or 0: Exclude blank object accounts from the consolidation. This value should improve processing time.

1: Include blank object accounts in the consolidation. Reviewing Consolidated Financial Statements Online Access the Online Consolidated Financial Statements form. Trial Balance, Balance Sheet, and Income Statement Select the type of online statement to review and click Find to perform the calculation. For the balance sheet, the system calculates net income or loss based on AAI item GLG5 and includes the description for that item on the form. For the income statement, interim totals for gross margin, operating income, and so on the system uses AAI item FS xx. Level of Detail or Business Unit Detail Enter a value in one of these fields to review detail or summary amounts or to review a different level of detail. If you select Business Unit Detail, you can access additional detail fields from the Row menu.