Creating Statistical Journal Entries Using Statistics

This section discusses how to:

  • Create statistical journal entries using statistical accounts.

  • Create statistical journal entries using statistics codes.

Page Name

Definition Name

Usage

Create/Update Journal Entries - Lines Page

JOURNAL_ENTRY2_IE

Record both monetary and statistical debit and credit amounts.

A ledger group of at least two ledgers is required in the following scenario. One ledger is dedicated to monetary entries and the other ledger is dedicated to statistical entries.

  1. Access the Create Journal Entries - Lines page (General Ledger, Journals, Journal Entry, Create/Update Journal Entries, Lines).

  2. To debit and credit the statistical account ChartFields, enter the amount based on the UOM that you set up for the account ChartField.

  3. Create a second journal entry for the monetary accounts and amounts associated with the previous statistical journal entry.

  4. When you process these journal entries, the statistical data is posted in the statistical ledger associated with the business unit and the monetary amounts are posted to the appropriate monetary ledgers associated with the business unit.

When you create the journal entry using the statistical ledger and statistical account ChartFields, enter the information for the following fields on the journal line:

Field or Control

Description

Account

Enter the statistical account number in the same field that you would enter any account number. The statistical account is recognized by the system from the statistical account indicator that you selected on the Account page when creating the account.

Stat (statistic)

This field is not available for entry. It is only enabled when using the statistic code method.

Stat Amt (statistical amount)

Enter the total number of units that are involved in the transaction.

UOM (unit of measure)

The unit of measure automatically appears based on the unit of measure that you select when you set up the statistical account ChartField.

See Creating Journal Entries.

Use the Journal Entry - Lines page (JOURNAL_ENTRY2_IE) to record both monetary and statistical debit and credit amounts.

Navigation:

General Ledger > Journals > Journal Entry > Create/Update Journal Entries > Lines

This example illustrates the fields and controls on the Journal Entry - Lines page (statistics code entry). You can find definitions for the fields and controls later on this page.

 Journal Entry - Lines page (statistics code entry)

Enter the data for this journal line, including monetary data, and use the following information to select a statistics code and its relevant data.

Field or Control

Description

Stat (statistic)

Select a code.

Stat Amt (statistical amount)

Enter the total number of units that are involved in the transaction.