About Analytical Accounting

When you activate Analytical Accounting by selecting the Use Analytical Ledger check box on the General Parameters form, the system changes its journal posting and reporting mechanisms in important ways to support the second accounting system.

Posting

These read-only journals always post to the General Ledger:

AP Dist - Accounts Payable Ledger Distribution
AR Dist - Accounts Receivable Ledger Distribution
BNK Dist - Banking Distribution
FA Dist - Fixed Assets Ledger Distribution
FS Dist - Service Distribution
PR Dist - Payroll Ledger Distribution

These read-only journals always post to the Analytical Ledger:

CO Dist - Order Entry Ledger Distribution
IC Dist - Inventory Control Ledger Distribution
PC Dist - Project Control Ledger Distribution
PO Dist - Purchasing Ledger Distribution
SF Dist - Shop Floor Control Ledger Distribution
WC Dist - Work Center Ledger Distribution

User-defined journals post to the Analytical Ledger if the Analytical Ledger field is selected. If this check box is cleared, they post to the General Ledger.

You can display transactions posted to the Analytical Ledger using the A/L Posted Transactions form. You can obtain more detailed information by framing searches using the A/L Posted Transactions Query utility.

Caution:

The system does not post an analytical account or journal to the General Ledger and does not post a non-analytical account or journal to the Analytical Ledger. It is important that you carefully define all default accounts so that analytical accounts do not post to journals that will later post to the General Ledger, and non-analytical accounts do not post to journals that will later post to the Analytical Ledger. For more information, see Analytical Ledger Setup.

Reporting

Several General Ledger reports have been modified so that they can track information from the Analytical Ledger when you select the Analytical Ledger field. They are:

Trial Balance
General Ledger
General Ledger Check Information Report
General Ledger Transaction Report

Printing Financial Statements

Use the Financial Statement Definition form to print all financial statements. If you want the statement to reflect data in the Analytical Ledger, select the Analytical check box.

Multi-Site

You can use a separate Analytical Ledger in a multi-site environment, but the Analytical Ledger itself is not consolidated.

The Chart of Accounts is created at the entity level and is automatically copied to all sites reporting to the entity.

The General Ledger is created at the site level. A map allows the General Ledgers of several sites to be consolidated to create a single financial statement at the entity level.

The Analytical Ledger may be created at either the entity or the site level, but is never consolidated. Some sites may use Analytical Ledgers, while other sites do not. If the Analytical Ledger is created at the entity level, the analytical accounts (Type Y) must be copied only to sites where the Use Analytical Ledger check box is selected on the General Parameters form.

Budget consolidation transaction takes place at the site level and should not be consolidated for analytical accounts.

Other

The following system functions support the Analytical Ledger:

Compress General Ledger Transactions Utility
Chart of Accounts - Budgets and Plan
Copy Balances to Budgets
Year-End Procedure Utility
Rebalance Ledger Period Totals

A/L Posted Transactions

You cannot directly delete a ledger transaction. However, you can enter a journal transaction for an opposite amount (and the same date as the transaction to delete) and then post that transaction to the ledger to cancel out the previous transaction. Then, compress the Analytical Ledger.

Note: If you compress the ledger, control numbers will be deleted.

You can display the transactions in these three ways:

in the order in which they were posted
sorted by account number
summarized by account for each accounting period

Note: If you have deleted material transactions, any Ledger or Journal records that reference them will have their references cleared. If you try to view detail on a ledger or journal and the specific material transaction has been deleted, you will be told the record is not available.