General Ledger: Consolidating Multiple Company's Financial Statements

G/L Consolidation Process

OUT OF DATE

1. Table of all companies to be consolidated

		COID			(company ID)
		GLACCT_COID		(G/L Account modifier)
		CONS_SESSION_NO		(last session # in GLTTRX of individual company)

1a. GLACCT mask which indicates where the GLACCT_COID is placed in the consolidated company account numbers

2. Create merged GLACCT table in consolidated company adding GLACCT_COID according to GLACCT mask

2a. Update GLTPERIOD table in each individual company from the consolidated company date setup

WARNING: Handle session number collision

3. Create merged GLTTRX table in consolidated company using output of GLPTRX_ACCTPERIOD procedure from each individual company

CREATE TABLE gltconsco (

 COID			CHAR(3) NOT NULL,	/* individual COID to be consolidated */
 ACCOUNT_MOD		VARCHAR(3),		/* company modifier for consolidated G/L accounts */
 CONS_SESSION_NO	INTEGER,		/* last session # from GLTTRX of individual company */

 CONSTRAINT gltconsco_key PRIMARY KEY (COID)

);