The transaction validation process checks to make sure that accounting string values (such as account, object code and sub-object code) are valid. It also ensures that the transaction has proper identifying information (such as a document number, document type and origination code indicating the system it came from) attached.
Because some systems may not be capable of providing all of the information required to post a General Ledger transaction, 'Scrubber' may assign some attributes to complete the transaction.
If necessary, 'Scrubber' can assign a fiscal year, fiscal period, and transaction date to a transaction based on the system date (which is determined by the date on which the batch process is run). It can also assign an object code type based on the object code of the transaction.
Sample of transaction validation business rules and error messages
No |
Rule |
Action or ERROR MESSAGE |
1 |
Origin code must exist in the Origin Code table. |
ORIGIN CODE NOT IN THE ORIGIN TABLE |
2 |
Document number is required. |
DOCUMENT NUMBER IS REQUIRED |
3 |
Chart code must exist in the Chart table. |
CHART CODE NOT IN THE CHART TABLE |
4 |
Chart code must be 'Active.' |
CHART CODE IS NOT ACTIVE |
5 |
Account number must exist in the Account table. |
ACCOUNT NUMBER IS NOT IN THE ACCOUNT TABLE |
6 |
If the Origin code indicates a Kuali e-doc or an institution-selected external application source, the account must be 'Open', unless the document type is 'Year-End Closing' and the balance type indicates beginning balance. |
ORIGIN CODE CANNOT HAVE A CLOSED ACCOUNT |
7 |
If a sub-account is entered, it must exist in the Sub-Account table. |
SUB-ACCOUNT IS NOT IN SUB-ACCOUNT TABLE |
8 |
If a sub-account is entered, it must be 'Active.' |
SUB-ACCOUNT CODE IS NOT ACTIVE |
9 |
Object code must exist in the Object Code table. |
OBJECT CODE IS NOT IN THE OBJECT CODE TABLE |
10 |
If a sub-object code is entered, it must exist in the Sub-Object Code table. |
Action: If Sub Object Code is null/blank or if it doesn't exist in table, dashes are substituted. |
11 |
Balance type must exist in the Balance Type table. |
BALANCE TYPE CODE IS NOT IN THE BALANCE TYPE TABLE |
12 |
Object type code must exist in the Object Type table. |
OBJECT TYPE CODE IS NOT IN THE OBJECT TYPE TABLE |
13 |
Fiscal year must exist in the Options Maintenance table. |
FISCAL YEAR IS NOT IN THE OPTIONS MAINTENANCE TABLE |
14 |
Fiscal period code must exist in the Accounting Period table |
FISCAL PERIOD CODE IS NOT IN THE ACCOUNTING PERIOD TABLE |
15 |
Fiscal period must be 'Open.' |
FISCAL PERIOD IS CLOSED |
16 |
Transaction entry sequence number must be numeric. |
Action: If null/blank/non-numeric, zeroes are substituted. |
17 |
Transaction ledger entry amount must be numeric. |
LEDGER AMOUNT IS NOT NUMERIC |
18 |
If Balance type offset generation attribute is 'Y' or 'C', then transaction ledger entry amount must be greater than or equal to zero. |
NEGATIVE AMOUNT IS INVALID WHEN OFFSET GENERATION CODE=Y OR C |
19 |
If Balance type offset generation attribute is 'N', then Transaction debit/credit code must be blank or null. |
DEBIT/CREDIT CODE MUST BE SPACE |
20 |
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 |
21 |
Transaction date must exist in the University Date table. |
In this case the invalid date will be replaced with the current date. |
22 |
Document type must exist in the Document Type table. |
DOCUMENT TYPE IS NOT IN THE DOCUMENT TYPE TABLE |
23 |
If a project code is entered, it must exist in the Project Code table. |
PROJECT CODE IS NOT IN THE PROJECT CODE TABLE |
24 |
If a project code is entered, it must be 'Active.' |
PROJECT CODE IS CLOSED |
25 |
If reference document number is not blank or null, then reference document type must exist in the Document Type table. |
REFERENCE DOCUMENT TYPE IS NOT IN THE DOCUMENT TYPE TABLE |
26 |
If reference document number is not blank or null, then reference origin code must exist in the Origin Code table. |
REFERENCE ORIGINATION CODE IS NOT IN THE ORIGIN CODE TABLE |
27 |
If transaction encumbrance update code is 'R', then reference document number must not be blank or null. |
REFERENCE DOCUMENT NUMBER CANNOT BE SPACE |
28 |
If reversal date is entered, it must exist in the University Date table |
REVERSAL DATE IS NOT IN THE UNIVERSITY DATE TABLE |
29 |
If balance type encumbrance indicator is 'Y' and object type fund balance indicator is 'Y', then transaction encumbrance update code must be 'D', 'R', or 'N.' |
ENCUMBRANCE UPDATE CODE IS NOT=D OR R OR N |
30 |
If object type code is expense type and balance type
code is 'Actuals' or 'Encumbrance,' then sub-fund group must exist in the Sub-Fund Group table. |
SUB-FUND GROUP IS NOT IN THE SUB-FUND GROUP TABLE |
More: