How Import GL Journal Respects Accounting Schema Rules

In iDempiere, the Import GL Journal process is tightly controlled by the Accounting Schema. Even though data is imported in bulk, it cannot bypass the fundamental accounting rules defined in the system. This ensures that every imported journal behaves exactly like a manually created journal from an accounting perspective.

Accounting Schema as the Control Layer

The Accounting Schema defines the structure and rules for all financial postings, including:

Chart of Accounts
Currency
Accounting Calendar
Posting precision
Costing and balancing rules

When GL data is imported, iDempiere validates every record against the active Accounting Schema before allowing journal creation.

TenthPlanet-iDempiere-AccountingManagement-ImportGLJournal-1

Account Validation During Import

Each imported journal line must reference:

A valid Account from the schema’s Chart of Accounts
A compatible Organization and accounting combination

If an account does not exist or is not allowed by the schema, the record fails validation and is not imported as a journal. This prevents incorrect or orphaned accounting entries.

Currency Precision Enforcement

Accounting Schema defines base currency, conversion rules, and decimal precision for postings. During GL Journal import, amounts are validated against schema precision, currency mismatches flagged, and conversions applied only when properly configured. This prevents rounding and currency inconsistencies in the General Ledger.

TenthPlanet-iDempiere-AccountingManagement-ImportGLJournal-2

Period and Calendar Control

The Accounting Schema is linked to an Accounting Calendar.
When importing:

The accounting date must fall within an open period
Closed or future-restricted periods are rejected

This ensures imported journals respect period control rules and cannot be posted into locked financial periods.

Standard Posting Engine Usage

After import, GL Journals use the same posting engine as manual journals to generate Accounting Facts per schema rules. Audit trails, reversals, and reporting function normally. Importing maintains full accounting logic without shortcuts.

TenthPlanet-iDempiere-AccountingManagement-ImportGLJournal-3

The Import GL Journal feature fully respects Accounting Schema rules by enforcing account validity, currency control, period management, balancing logic, and standard posting behavior. Bulk import improves efficiency—but never compromises accounting discipline.