Chart of Accounts structure

Infor d/EPM requires the chart of accounts to have defined top level GL accounts for Budgeting & Planning to work.

When the chart of accounts structure is not transferred to the staging tables from the source system, a top level structure is generated by the bds_integration_bp_import_account_staging Base Data Store account import stored procedure. This structure is then used to define settings in the System Elements tab under Planning Settings in Designer.

Parent accounts are assigned based on ACCOUNT_TYPE. Structure beneath the top level definition can be configured to meet your chart of account structure requirements.

This table describes the account types and parent IDs:

ACCOUNT_TYPE	PARENT_ID
A (Assets)	TTL_ASSETS - All Assets
L (Liabilities)	TTL_LIABILITIES - All Liabilities
Q (Equity)	TTL_EQUITY - All Equity
R (Revenue)	TTL_REVENUES - All Revenues
E (Expenses)	TTL_EXPENSES - All Expenses

This table describes the system elements:

Top elements configuration	Default account
Top Account / Balance Sheet	TOTAL_ACCOUNT lists all accounts in the chart of accounts.
Top Account / Assets	TTL_ASSETS lists all asset accounts.
Top Account / Liabilities	TTL_LIA-EQ lists all TTL_LIABILITIES and TTL_EQUITY accounts.
Top Account / Profit and Loss	TTL_P_L lists all TTL_REVENUES and TTL_EXPENSES accounts.