Final Validation

The validation criteria are listed in the business rules below:

Sample of final transaction validation business rules:

No.

Rule

Error Message

1

Chart code must exist in the Chart table.

ORIGIN CODE NOT IN THE ORIGIN TABLE

2

Account number must exist in the Account table.

ACCOUNT NUMBER IS NOT IN THE ACCOUNT TABLE

3

Balance type must exist in the Balance Type table.

BALANCE TYPE CODE IS NOT IN THE BALANCE TYPE TABLE

4

Object type code must exist in the Object Type table.

OBJECT TYPE CODE IS NOT IN THE OBJECT TYPE TABLE

5

Fiscal year must exist in the Options Maintenance table.

FISCAL YEAR IS NOT IN THE OPTIONS MAINTENANCE TABLE

6

Transaction ledger entry amount must be numeric.

LEDGER AMOUNT IS NOT NUMERIC

7

If balance type offset generation attribute is 'N', then transaction debit/credit code must be blank or null.

DEBIT/CREDIT CODE MUST BE SPACE

8

If balance type offset generation attribute is not 'N', then transaction debit/credit code must be 'C' or 'D.'

DEBIT/CREDIT CODE IS NOT D OR C

More:

GL Balance Update