Technology Evaluation Centers Inc.
Mixed-Mode Enterprise Resource Planning
Criteria Worksheet
Priority Mandatory
Hierarchy Criterion SUP PSUP PADD MOD 3RD CST FUT NS Description Comment
(0-10) (Y/N)
Financial system modules for
bookkeeping and ensuring
accounts are paid or received on
1 Financials time.
General ledger keeps
centralized charts of accounts
and corporate financial
balances. It supports all aspects
of the business accounting
process. In this module, financial
accounting transactions are
posted, processed, summarized,
and reported. It maintains a
complete audit trail of
transactions and enables
individual business units to view
their financial information, while
parent companies can roll up all
business subsidiaries and view
the consolidated information.
1.1 General Ledger
1.1.1 Parameters and Structuring
Lean manufacturing accounting practices and methods
(i.e., manufacturing overheads based on cycle time
1.1.1.1 including labor)
1.1.1.2 Fiscal calendar is defined by the user
1.1.1.3 Calendar periods are defined by the user
Calendar can be defined as uneven periods, adjustment
1.1.1.4 periods, or to a maximum of 366 periods
Multiple calendars may be useful
for different accounting
scenarios. For example,
different financial entities may
need separate fiscal calendars--
one set of books might require a
quarterly calendar while another
would require a different term. If
a merger results in two financial
entities that have different fiscal
calendars, the accounting
system will need to maintain
both calendars and normalize
the data (Q2 for Entity A is equal
to Q3 for Entity B). This may
also be useful for what-if
scenarios.
1.1.1.5 Multiple calendars
A financial reporting entity is a
business unit which can legally
1.1.1.6 Multi-entity financial reporting make financial reports.
1.1.1.7 Twelve or thirteen fiscal months
The 4-4-5 calendar period uses
a four week, four week, five
week pattern. Likewise, the 5-4-
4 calendar period uses a five
week, four week, four week
Fiscal quarterly periods can be defined as 4-4-5, 5-4-4, pattern; and analagously for the
1.1.1.8 or 4-5-4 4-5-4 pattern.
1.1.1.9 Organization of calendar periods determined by the user
The calendar can be organized
Calendar may be organized in a variety of ways, in a limitless form, with up to 999
1.1.1.10 supporting 999 periods in a financial year user periods, per calendar
Open any number of fiscal years or calendar periods at
1.1.1.11 the same time
Companies with different regional presences may set a
1.1.1.12 default currency for the financial division of each region
The ability to decide how to
organize data when defining the
organization of an enterprise's
financial information
1.1.1.13 Sets reporting entity and its organizational characteristics
Distinguishes A/P transactions (of the same type) from account payable (A/P)
1.1.1.14 different entities
Each entity's ledger can have its own calendar and
1.1.1.15 chart of accounts
By controlling when an account
is open and closed, the posting
Each entity's ledger can have its own accounting of information in an account
1.1.1.16 periods opened and closed period can restricted.
User may choose between data collection and real time Allows for instant processing or
1.1.1.17 posting modes batch processing
Tracks items in the G/L and sub-ledger by quantity and general ledger (G/L)
1.1.1.18 value (in whichever currency is used)
The ability to change the
currency used in balance sheet
accounts to another currency
using a default rate. It is possible
to override this default rate for
particular accounts. Moreover, it
is possible to set different default
Maintains unit and dollar amount postings in GL and sub- rates for different subledgers.
1.1.1.19 ledgers
User-defined criteria for system purges for general
ledger transactions, journal vouchers, and accounts
payable data based on the number of years or months
of data required to maintain--each purge type has its
1.1.1.20 own unique criteria
Sub-ledgers closed out prior to performing a purge. The
closeout process sets all financial account balances in
the sub-ledger to zero by posting an equal and offsetting
1.1.1.21 transaction
A general ledger key typically is
an identifier attached to
accounts to put the accounts into
groups. For example, there may
be fifteen accounts in the chart
of accounts related to payroll,
and all fifteen accounts will be
assigned the same key (perhaps
"PAYROLL"). Thus the system
Specifies a key and rules to have the system can purge or set other rules to all
automatically purge all records related to the key chart of accounts with the same
throughout the system--sub-ledger accounts, sub-ledger key.
1.1.1.22 transactions, tables, rates
Automatic check to ensure that prior to deleting a
financial record, the account balance must have been
1.1.1.23 "closed out" (i.e., nets to zero)
The ability to cumulatively
incorporate results from the
Translation of balance sheet accounts including the previous accounting period into
ability to have a default rate (spot) that can be the current accounting period,
overridden on an exception basis (historic), on an but only when the last document
account-by-account basis - do not want to set up a rate generated in the previous period
for every balance sheet account - the override rates will was the financial statement.
1.1.1.24 differ ledger to ledger
Automatically inserts actual account balances into the
elapsed month's bucket in a future forecast file at the
end of each accounting period when the system rolls
1.1.1.25 into the next period
The ability to cumulatively
incorporate results from the
previous accounting period into
the current accounting period,
but only when the last document
generated in the previous period
Prevents roll from one accounting period to the next was the financial statement.
1.1.1.26 unless the last job run is the financial statements
Audit log required for any changes to table information
that may contain rates and information used by the
system in any way; log contains before and after,
1.1.1.27 change, date, and user identification
General ledgers are designed to
present values for creating
financial statements. The
multiple level for a ledger key
means the system will have a
more complex and functional key
structure--one that supports a
1.1.1.28 Flexible general ledger key with multiple levels hierarchy of keys.
The ability to automatically,
rather than manually, identify
open receivables exceptions by
using user-defined conditions
(for example, very large amount
invoices, exceeding credit line,
1.1.1.29 Exception reporting with drill down capabilities etc.)
Change cross charge percentages without retroactively
1.1.1.30 changing previously published financial information
The system can provide a copy
function or a program to
propagate a chart of accounts
for a specific existing business
unit to a new business unit. If a
US dollar ledger has a chart of
accounts, a Canadian dollar
ledger can be created by
Provision for use of standards that can be automatically propagating from the US dollar
1.1.1.31 propagated throughout the system to the various ledgers ledger, etc.
Integration with ADP electronic transmission of payroll ADP refers to automatic d