JD Edwards EnterpriseOne General Accounting Preface

JD Edwards EnterpriseOne Products

JD Edwards EnterpriseOne Application Fundamentals

About This Documentation

Common Fields Used in This Implementation Guide

Getting Started with JD Edwards EnterpriseOne General Accounting

JD Edwards EnterpriseOne General Accounting Overview

JD Edwards EnterpriseOne General Accounting Business Processes

JD Edwards EnterpriseOne General Accounting Integrations

JD Edwards EnterpriseOne General Accounting Implementation

Understanding the General Accounting System

General Accounting Features

Setting Up the General Accounting System

Understanding General Accounting System Setup

Prerequisite

Setting Up Constants for General Accounting

Setting Up User-Defined Codes for General Accounting

Setting Up Ledger Types for General Accounting

Setting Up Ledger Type Rules for General Accounting

Setting Up AAIs for General Accounting

Setting Up Business Unit Supplemental Data

Setting Up Vertex Sales Tax

Setting Up Burdening

Understanding Burdening Setup

Setting Up Segment Information

Setting Up Pool Information

Setting Up Burdening Rates

Setting Up Advanced Variable Numerator Allocations

Understanding Setup for Advanced Variable Numerator Allocations

Setting Up Business Unit Overrides

Setting Up Versions for Account Balance-Based Allocations

Setting Up Versions for Burdening-Based Allocations

Setting Up Specifications for Advanced Variable Numerator Allocations

Setting Up Account Reconciliation

Understanding Account Reconciliation

Setting Up AAIs for Account Reconciliation

Setting Up Reconciliation Codes

Setting Up Automatic Bank Statement Processing

Setting Up UDCs for Automatic Bank Statement Processing

Setting Up Cross References

Setting Up Automatic Bank Account Reconciliation

Setting Up Budget Forecasting and Planning

Understanding Budget Forecasting and Planning Setup

Setting Up Growth Patterns

Setting Up Cash Forecasting

Understanding Cash Forecasting Setup

Understanding Cash Type Codes

Setting Up Cash Type Rules

Defining a Cash Forecast Report Structure

Setting Up Statements of Cash Flow

Understanding Cash Management

Understanding Cash Flow Statements

Setting Up Cash Flow Activity Codes

Setting Up Normal Balance Codes

Setting Up Cash Flow Rules

Setting Up Cash Basis Accounting

Understanding Cash Basis Accounting Setup

Setting Up Cash Basis Document Types

Setting Up AAIs for Cash Basis Accounting

Setting Up 52 Period Accounting

Setting Up 52 Period Fiscal Date Patterns

Setting Up 52 Period Reporting Dates

Changing to 52 Period Accounting

Processing Journal Entries

Understanding the Journal Entry Process

Understanding Other Methods of Entering Journal Entries

Working with Journal Entries

Working with Reversing Journal Entries

Working with Model Journal Entries

Reviewing Journal Entries

Posting Journal Entries

Revising and Voiding Posted Journal Entries

Processing Batch Journal Entries

Understanding Journal Entry Batch Processing

Uploading Batch Journal Entry

Working with Batch Journal Entries

Posting Processed Batch Journal Entries

Purging Processed Batch Journal Entries

Processing Allocations

Understanding Allocations

Understanding the Process for Creating Allocations

Understanding Multitiered Allocations

Common Elements Used in This Chapter

Processing Recurring Journal Entries

Processing Indexed Allocations

Processing Advanced Variable Numerator Allocations

Processing Burdening

Understanding the Burdening Process

Creating Burdening Transactions

Processing Reburdening

Understanding the Reburdening Process

Processing Reburdening

Reviewing, Approving, and Deleting Reburdening Transaction Groups

Updating the Billing Detail Workfile Table with Reburdening Transactions

Processing Actual Rate Calculation

Understanding Actual Rate Calculation

Prerequisite

Calculating Actual Rates

Reviewing Actual Rate Calculation Reference IDs

Reconciling Bank Account Transactions

Understanding Bank Account Reconciliation

Reconciling Voided Payments and Receipts

Refreshing Account Reconciliation Information

Reconciling Bank Account Transactions Manually

Changing a Reconciled Transaction to Unreconciled

Reconciling Debit and Credit Amounts

Understanding the Debit and Credit Reconciliation Process

Prerequisites

Reconciling Debit and Credit Transactions

Reconciling Bank Tapes

Understanding the Bank Tape Reconciliation Process

Reformatting the Bank Tape

Refreshing Account Reconciliation Information

Matching the Bank Tape to the Reconciliation Workfile

Verifying the Bank Tape Reconciliation

Processing Bank Statements Manually

Understanding Manual Bank Statement Processing

Understanding Transaction Codes

Understanding Transit Accounts

Entering Bank Statement Transactions

Refreshing Account Reconciliation Information

Running the Bank Journal Statement Process Program

Processing Bank Statements Automatically

Understanding the Automatic Bank Statement Process

Processing Flat Files from the Bank

Revising Data in the Staging Tables

Loading Data into the Bank Statement Tables

Revising Data in the Bank Statement Tables

Processing Automatic Bank Statements

Reconciling Unreconciled Bank Statement Transactions

Purging Bank Statement Tables

Creating Budgets

Understanding Budgets

Understanding Budget Patterns

Creating Budget Pattern Codes

Changing Budget Pattern Codes for a Group of Accounts

Entering Annual Budgets

Spreading Annual Budget Amounts to Periods

Generating Budget Worksheets

Reviewing Budget Comparisons Online

Managing Budget Overages

Entering Detailed Budget Amounts

Entering Journalized Budgets

Uploading Budget Data

Understanding the Budget Upload Process

Importing Budget Data from Spreadsheets

Importing Budget Data from Text Files

Revising Imported Budget Data

Uploading Budget Data to the F0902 Table

Purging Processed Records in the F0902Z1 Table

Forecasting and Planning Budgets

Understanding Budget Forecasting and Planning

Defining Accounts and Retrieving Basis Amounts

Revising Accounts and Basis Amounts

Generating Budget Forecast Amounts

Revising Budget Forecast Amounts

Updating Budget Forecast Records

Purging Budget Forecast Records

Processing Cash Forecast Data

Refreshing Cash Forecast Data

Analyzing Cash Forecast Information

Purging Forecast Data

Creating Cash Basis Entries

Understanding Cash Basis Accounting

Understanding Accrual Entries

Understanding Cash Basis Entries

Running the Cash Basis Program from the Menu

Running the Cash Basis Program from the Post

Reviewing Exception Reports

Reviewing Cash Basis Entries

Posting Cash Basis Entries

Using 52 Period Accounting

Posting 52 Period Accounting Entries

Closing a 52 Period Year

Producing a 52 Period Income Statement

Understanding Account Consolidations

Account Consolidations

Processing Online Consolidations

Understanding Organization Report Structures

Prerequisites

Creating Hierarchical Organization Report Structures

Adding Organization Report Structures Without Using Category Codes

Reviewing and Rearranging Organization Report Structures

Creating Additional Business Units and Copying Report Structures

Creating Online Consolidations

Reviewing Online Consolidations

Processing High-Volume Consolidations

Understanding High-Volume Consolidation Processing

Deleting Prior High-Volume Consolidations

Creating High-Volume Consolidations

Reviewing High-Volume Consolidations

Processing Multisite Consolidations

Understanding Source and Target Site Tasks

Understanding Multiple Consolidation Tiers

Understanding Multisite Consolidation Structures and Tables

Running Control File Reports

Creating Organizational Structures

Creating Account Structures

Revising and Printing Account Structures

Defining Multisite Consolidation Rules

Creating Consolidated Balances

Running the Multisite Consolidations Reports

Reviewing Consolidation Statuses

Sending Consolidated Balances by Batch to the Target Company

Sending Consolidated Balances Interactively to the Target Company

Processing Consolidated Balances from Non-EnterpriseOne Source Sites

Revising Inbound Consolidations

Purging Inbound Consolidations Data

Generating Multisite Batch Journal Entries

Processing and Purging Multisite Batch Journal Entries

Reviewing Balances and Transactions

Understanding Online Inquiries

Understanding Statutory Inquiries

Understanding Trial Balance Inquiries

Understanding Account Ledger and Balance Inquiries

Reviewing Trial Balances, Ledgers, and Subledgers

Reviewing Trial Balances

Reviewing Account Ledgers

Reviewing Account Balances by Month

Generating Financial Reports

Understanding Financial Reports

Setting Up Data Selection and Data Sequence for the Simple Income Statement and Simple Balance Sheet

Generating a Simple Income Statement

Generating a Simple Balance Sheet

Generating a Statement of Cash Flow

Generate Consolidated Financial Reports

Generating Monthly Spreadsheets

Generating Variance Analysis Reports

Verifying Data Integrity for General Accounting

Understanding General Accounting Integrity Reports

Running the Transactions to Batch Headers Report

Running the Batch to Detail Report

Running the Unposted Batches Report

Running the Batches Out of Balance Report

Running the Company by Batch Out of Balance Report

Running the Companies in Balance Report

Running the Intercompany Accounts in Balance Report

Running the Account Balance to Transactions Report

Running the Accounts without Business Units Report

Running the Account Balance without Account Master Report

Running the Transactions without Account Master Report

Maintaining Batch Headers

Understanding Batch Header Revisions

Prerequisite

Working with Batch Headers

Reposting the Account Ledger and Recalculating a Fiscal Year

Understanding the Repost Programs

Prerequisites

Reposting the Account Ledger

Recalculating the Fiscal Year and Period

Revising an Organization

Understanding Organization Revisions

Understanding Account Structure Revisions

Understanding Tables Affected by Account Structure Revisions

Prerequisite

Changing a Business Unit on Multiple Accounts

Changing Accounts by Object

Changing Accounts by Subsidiary

Updating the F0911 and F0902 Tables

Changing the Company Number on a Business Unit

Changing Account Information

Updating the Model/Consolidated Field

Updating Category Codes for Business Units

Closing Accounting and Reporting Periods

Understanding Period-End Close Tasks

Closing the Accounting Period

Changing Financial Reporting Periods

Closing the Fiscal Year

Understanding the Fiscal Year Close

Understanding Setup Requirements and Common Tasks

Closing a Fiscal Year

Closing a Fiscal Year for Budgets

Summarizing Records and Purging Records

Understanding Summarizations, Deletions and Purges

Summarizing Account Ledger Records

Purging Prior-Year Records

Purging Prior-Year Account Balances

Deleting Account Master Records

Deleting Business Units and Companies

General Accounting Tables

Primary Tables

Supplemental Tables

Mapping Fields for Journal Entry Batch Processing

Mapping Fields in the F0911Z1 Table

Mapping Fields in the F0911Z1 Table for Burdening

Mapping Fields in the F0911Z1 Table for Advanced Cost Accounting

Mapping Fields in the F0911Z1 Table for Externally Reconciled Transactions

Field Mapping for Automatic Bank Statement Processing

Mapping BAI2 Fields to the F09610 and F09611 Tables

Mapping SWIFT Fields to the F09610 and F09611 Tables

Mapping Fields for Budget Data Import

Mapping Fields in the F0902Z1 Table

Mapping Fields for Inbound Multisite Consolidations

Mapping Fields in the F1001Z1 Table

Mapping Fields in the F1002Z1 Table

Delivered Workflow for JD Edwards EnterpriseOne General Accounting

Delivered Workflow for JD Edwards EnterpriseOne General Accounting

JD Edwards EnterpriseOne General Accounting Reports

Types of General Accounting Reports

JD Edwards EnterpriseOne General Accounting Reports: A to Z

JD Edwards EnterpriseOne General Accounting Reports: Selected Reports