Defining Ledger Verification Rules

This section provides an overview of ledger verification rules and discusses how to establish ledger verification rules.

Page Used to Define Ledger Verification Rules

Page Name	Definition Name	Navigation	Usage
Ledger Verification Rule	GC_LEDVERF_RULE	select Global Consolidations, then select Define Consolidations, then select Ledger Preparation, then select Ledger Verification Rule	Enables you to specify the Job ID and the period usage for ledger verification rules.

Understanding Ledger Verification Rules

After you load your ledgers you must verify that the content of the ledger data adheres to balancing rules that you specify, such as debits equal credits. You use the standard PeopleSoft EPM metadata tools to build these balance rules. After the balancing rules are defined, you then associate them with the ledger verification rules component that is delivered with Global Consolidations. The Ledger Verification application engine resolves these rules, and creates status log entries that you view with the Ledger Preparation Manager.

You run the ledger verification process at the beginning of the edger preparation process. The ledger verification process validates the data for specified source business units based on user-defined rules for checks and balances and error handling. If an error occurs during the verification, the Ledger Preparation engine will either continue the ledger preparation process for the valid business units only, or abort the entire run, (depending on what you specify for Verification Error Handling on the Ledger Preparation Run Group page). You can view the verification status results on the Ledger Preparation Manager page.

Note: You must run ledger verification for all source data.

See Understanding the Ledger Preparation Manager.

Defining Ledger Verification Rules

Ledger verification rules are based on balancing rule equations, such as debits equal credits. These equations are defined using metadata, including filters, constraints, and job total metadata, which is then processed through the reconciliation engine. You define a balancing rule equation and add it to a ledger verification rule by following these steps:

Define filters and constraints for each side of the balancing rule equation.
Use the constraints to define job total metadata for each side of the equation.
Use job total metadata to define the balancing rule metadata.
Add the job total metadata IDs to Global Consolidations Ledger Verification Rules.

After the ledger verification rules are defined, you then add them to the ledger preparation rules and run the ledger preparation process. .

See Defining Ledger Preparation Rules and Groups.

Delivered Sample Metadata

Global Consolidations delivers the following balancing rule sample data for standard balance rules that you can access and modify to assist you with building your own ledger verification rules:

Total debits equal total credits.
Current period retained earnings equals prior period retained earnings plus current period activity.
Assets equal liabilities plus equity.
Exclude future periods.
Prior period source count equals prior period source staging ledger (SLED) count.

You should adjust the verification rules according to your data and use those rules that make sense for your business practices. In addition to the user-defined rules, the verification process can optionally perform basic ChartField validation against the ChartField Edit on the Ledger Template. You can also create additional rules for verifying your source ledger data.

Global Consolidations delivers the following sample metadata to support manual data entry:

TableMaps
DataMaps
Filters and Constraints
Job Total Metadata
Balance Rule Metadata

Global Consolidations delivers the following sample TableMap metadata to support ledger verification for source manual ledgers:

TableMaps	Primary Table Name	Description
GCLEDMANL	GC_LEDMANL_F00	Source Ledger records for user defined spreadsheet upload/manual entry ledger.
GCSLEDMANL	GC_SLED_MANL	Prep Source Ledger - Manual Global Consolidations Preparation Source Ledger for source ledgers from user defined spreadsheet upload/manual entry ledgers.

TableMaps

Primary Table Name

Description

GCLEDMANL

GC_LEDMANL_F00

Source Ledger records for user defined spreadsheet upload/manual entry ledger.

GCSLEDMANL

GC_SLED_MANL

Prep Source Ledger - Manual

Global Consolidations Preparation Source Ledger for source ledgers from user defined spreadsheet upload/manual entry ledgers.

Global Consolidations delivers the following sample DataMap metadata support ledger verification for source manual ledgers:

DataMaps	Constraint Codes	Constraint Description
GCSLEDMANL	GC_SLEDMANL_NONE	Manual ledger no mapping
	GCLEDMPRVSLEDCNT	Prior period SLED count
	GCRECNLEDMSRC	Preparation manual source
	GCRECNMCALMAP	Calendar map - manual
GCLEDMANL	GCLEDMASSET	Source asset amount
	GCLEDMCREDIT	Source credit amount
	GCLEDMCURACTIVITY	Source current activity
	GCLEDMCURRETN	Source current retained earnings
	GCLEDMDEBIT	Source debit amount
	GCLEDMFUTPERIOD	Reconciliation future activities
	GCLEDMLIABEQUITY	Source liability plus equity
	GCLEDMPRVBAL	Source prior balance
	GCLEDMPRVSRCCNT	Prior period source count
	GCRECNMCALSRC	Calendar source - manual

Global Consolidations delivers the following sample constraints and filters to support ledger verification for source manual ledgers:

Constraint	Description	Filter Code
GC_SLEDMANL_NONE	Manual ledger no mapping	None
GCLEDMPRVSLEDCNT	Prior period SLED count	GCLEDMPRVSLEDCNT
GCRECNLEDMSRC	Preparation manual source	GCRECNLEDMSRC
GCRECNMCALMAP	Calendar map - manual	GCRECNMCALMAP
GCLEDMASSET	Source asset amount	GCLEDMASSET
GCLEDMCREDIT	Source credit amount	GCLEDMCREDIT
GCLEDMCURACTIVITY	Source current activity	GCLEDMCURACTIVITY
GCLEDMCURRETN	Source current retained earnings	GCLEDMCURRETN
GCLEDMDEBIT	Source debit amount	GCLEDMDEBIT
GCLEDMFUTPERIOD	Reconciliation future activities	GCLEDMFUTPERIOD
GCLEDMLIABEQUITY	Source liability plus equity	GCLEDMLIABEQUITY
GCLEDMPRVBAL	Source prior balance	GCLEDMPRVBAL
GCLEDMPRVSRCCNT	Prior period source count	GCLEDMPRVSRCCNT
GCRECNMCALSRC	Calendar source - manual	GCRECNMCALSRC

Note: You will find the sample constraints and filters under the SHARE SetID.

Global Consolidations delivers the following sample Job Total Metadata to support ledger verification for source manual ledgers:

Job ID	Total ID	Description	Record Name	Constraint Code
GCRECNCAL	TOT6	Calendar map - manual	GC_SLED_MANL	GCRECNMCALMAP
GCRECNCLED	TOT4	Preparation manual source	GC_SLED_MANL	GCRECNLEDMSRC
GCVERFLEDM	GC_PRVSLED	Prior period SLED count	GC_SLED_MANL	GCLEDMPRVSLEDCNT
GCRECNCAL	TOT5	Calendar source - manual	GC_LED_MANL_F00	GCRECNMCALSRC
GCVERFLEDM	GC_ASSETS	Assets	GC_LED_MANL_F00	GCLEDMASSET
GCVERFLEDM	GC_CREDIT	Credit amount	GC_LED_MANL_F00	GCLEDMCREDIT
GCVERFLEDM	GC_CURACT	Current period activity	GC_LED_MANL_F00	GCLEDMCURACTIVITY
GCVERFLEDM	GC_CURRETN	Current period retained earnings	GC_LED_MANL_F00	GCLEDMCURRETN
GCVERFLEDM	GC_DEBIT	Debit amount	GC_LED_MANL_F00	GCLEDMDEBIT
GCVERFLEDM	GC_FUTCNT	Future periods count	GC_LED_MANL_F00	GCLEDMFUTPERIOD
GCVERFLEDM	GC_LIABEQT	Liabilities plus equity	GC_LED_MANL_F00	GCLEDMLIABEQUITY
GCVERFLEDM	GC_PRVBAL	Prior period balance	GC_LED_MANL_F00	GCLEDMPRVBAL
GCVERFLEDM	GC_PRVCNT	Prior period source count	GC_LED_MANL_F00	GCLEDMPRVSRCCNT
GCVERFMNL2	GC_CREDIT	Credit	GC_LED_MANL_F00	GCLEDMCREDIT
GCVERFMNL2	GC_DEBIT	Debit	GC_LED_MANL_F00	GCLEDMDEBIT

Note: You will find the sample Job Total Metadata under the SHARE SetID.

Global Consolidations delivers the following sample Balance Rules Metadata to support ledger verification for source manual ledgers:

Balance Rules Metadata ID	Description
GCVERFLEDM	GC_LEDMANL_F00 acceptance rule
GCVERFMNL2	GC_LEDMANL minimum acceptance

Note: You will find the sample Balance Rules Metadata under the SHARE SetID.

Example: Metadata Setup for Ledger Verification

The following example demonstrates how a standard balance rule for the source manual ledger GC_LEDMANL_F00 record is defined for debits must equal credits.

This balance rule forms an equation that contains two terms.

Total Debits = Total Credits

The system calculates each one of these terms using job total metadata.

Note: This example presumes that the record metadata, tablemap, and datamap are already setup.

The first step is to set up the filters and constraints for the balance rule equation. In this example, two filters were established, one for each side of the balance rule equation, as follows:

This illustrates the GCLEDMDEBIT filter criteria page, which calculates the left side of the equation and selects debit data:

Image: Filter - Selection Criteria page for the GCLEDMDEBIT filter

This example illustrates the fields and controls on the Filter - Selection Criteria page for the GCLEDMDEBIT filter. You can find definitions for the fields and controls later on this page.

This illustrates the GCLEDMCREDIT filter criteria page, which selects the right side of the balance rule equation, credit data:

Image: Filter - Selection Criteria page for GCLEDMCREDIT

This example illustrates the fields and controls on the Filter - Selection Criteria page for GCLEDMCREDIT. You can find definitions for the fields and controls later on this page.

Note: Unless you have modified the underlying fields and tables, there is no need to modify these filters.

The two previously described filters were then associated with constraints, as follows:

This illustrates the constraint that was established to use the debit filter.

Image: Constraint - Criteria page for GCLEDMDEBIT Filter

This example illustrates the fields and controls on the Constraint - Criteria page for GCLEDMDEBIT Filter. You can find definitions for the fields and controls later on this page.

This illustrates the constraint that was established to use the credit filter:

Image: Constraint - Criteria page for GCLEDMCREDIT Filter

This example illustrates the fields and controls on the Constraint - Criteria page for GCLEDMCREDIT Filter. You can find definitions for the fields and controls later on this page.

Note: There is no need to modify these constraints even if you modify the filters that are associated with them, unless you have changed the names of the filters.

With the filters and constraints in place, the next step is to establish Total IDs for both the credit and debit constraints on the Job Total Metadata page. The Total ID's are also associated with a Job ID on the Job Total Metadata page. Because the both the debit and credit calculations are used during the ledger verification process, they are established for the Global Consolidations Manual Ledger Verification Job ID, GCVERFLEDM.

This illustrates the Job Total Metadata page for the Total ID GC_DEBIT, that uses the GCLEDMDEBIT constraint:

Image: Job Total Metadata page for GC_DEBIT

This example illustrates the fields and controls on the Job Total Metadata page for GC_DEBIT. You can find definitions for the fields and controls later on this page.

This illustrates the Job Total Metadata page for the Total ID GC_CREDIT that uses the GCLEDMCREDIT constraint:

Image: Job Total Metadata page for GC_Credit

This example illustrates the fields and controls on the Job Total Metadata page for GC_Credit. You can find definitions for the fields and controls later on this page.

Note: There is no need to modify the job total metadata even if you modify the filters and constraints that are associated with them. The only reason to modify this metadata is if you have added new filters and constraints that you want to use.

The next step is to use the Job IDs and Total IDs to establish the Balance Rules Metadata, as follows.

This illustrates the balances rules metadata for debits = credits.

Image: Balances Rules Metadata page

This example illustrates the fields and controls on the Balances Rules Metadata page. You can find definitions for the fields and controls later on this page.

The final step is to associate the Job ID from the Balance Rules Metadata with a ledger verification rule. In this example, the balance rules metadata, GCVERFLEDM is associated with the ledger verification rule GC_VERF1.

Image: Ledger Verification Rule page

This example illustrates the fields and controls on the Ledger Verification Rule page. You can find definitions for the fields and controls later on this page.

The preceding example illustrates how EPM metadata is setup to verify that the debits equal the credit. . This is one of several basic accounting principle rules that are delivered as sample EPM metadata and that you can use or modify to suit your business practices.

Ledger Verification Rule Page

Use the Ledger Verification Rule page (GC_LEDVERF_RULE) to enables you to specify the Job ID and the period usage for ledger verification rules.

Navigation

select Global Consolidations, then select Define Consolidations, then select Ledger Preparation, then select Ledger Verification Rule

Image: Ledger Verification Rule page

This example illustrates the fields and controls on the Ledger Verification Rule page. You can find definitions for the fields and controls later on this page.

Job ID

Select the job total metadata Job ID you want to assign for the ledger verification rule

ChartFields Validation

Select to perform to perform basic ChartField (dimension) validation aginst the ChartField Edit on the ledger template during the ledger verification rule process.

Note: To perform ChartField validation, you must specify a TSE record for use on the Ledger Template Consolidation Variables setup page. The delivered TSE record for the manual data entry process is GC_TSE_MANL_FLD.

See Defining Spreadsheet/Manual Entry Ledger Templates.

See Defining Ledger Templates.

Period Usage

Current period only

Select this option if you only want to apply the ledger verification rule on the current period.

Current and other periods

Select this option if you want to apply the ledger verification rule on the current period and to a specific number of future and prior periods. You can use the * wildcard value to select all periods.