Chart of Accounts Cross-Validation Rules (as of 7/16/2024)
KB06003962 •1416 Views • Updated 16-Jul-2024
Disclaimer:
The following values are not included in displayed Error Messages, but may be included in Validation Values criteria. Please note that conversion-only values will be disabled and removed from Cross-Validation Rules in September 2024.
13800 - Due from/(Due to) Funds (Account)
13860 - Due from/(Due to) Univ Entity (Account)
49000 - Net Assets (Account)
99998 - Account Conversion (Account)
999998 - Fund Conversion (Fund)
998 - Purpose Conversion (Purpose)
Name |
Condition Values (for reference; not visible to transactional user) |
Validation Values (for reference; not visible to transactional user) |
Error Message (visible to transactional user) |
Agency Funds |
B90000 - Agency Funds |
010 - Balance Sheet |
If Fund is a child of B90000 (Agency Funds), then Purpose can only be equal to 010, 530, 610, 650, 870, or 999. |
Agency Funds Inverse |
870 - Agency Activities |
B90000 - Agency Funds |
Purpose 870 can only be used with Agency Funds between 900000 and 989999. |
Auxiliary |
C34500 - Auxiliary |
010 - Balance Sheet |
If Fund is a child of C34500 (Auxiliary Funds), then Purpose can only equal 010, 430, 540, 800, or 999. |
Balance Sheet |
A1000 - Total Assets |
010 - Balance Sheet |
Balance Sheet Accounts between 10000 and 49999 can only be used with Purpose value 010. |
Balance Sheet Inverse |
010 - Balance Sheet |
A1000 - Total Assets |
Balance Sheet Purpose 010 can only be used with Accounts between 10000 and 49999. |
G&C Sponsored Projects |
C31000 - Grants and Contracts - Sponsored Projects |
010 - Balance Sheet 860 - Argonne National Lab |
If Fund is a child of C31000, then Purpose must be equal to 010, 100, 101, 110, 200, 206, 210, 302, 304, 420, 431, 530, 535, 600, 650, 860, or 999. |
G&C Sponsored Projects Inverse |
110 - Instruction - Sponsored |
C31000 - Grants and Contracts - Sponsored Projects |
Purpose values 110, 200, 210, 302, and 860 can only be used with Grants & Contracts -Sponsored Projects Funds between 310000 and 332014 and the Cost Share Fund value 272000. |
Individually Designated |
D27050 - Individual Discretionary |
010 - Balance Sheet |
Individually Designated Funds between 270500 and 270599 can only be used with Purpose values 010, 100, 109, 120, 124, 130, 150, 202, 300, 420, 430, 600, 650, 800, 850, or 999. |
Perm Restricted for A&LI |
D55000 - PR - Annuity & Life Income |
C1300 - Prepaid Exp & Other Assets ST |
The account combination you are attempting to use is invalid. Please review published Cross-Validation rules for Accounts that may be used when the Fund is a child of D55000. |
Perm Restricted of True Endow |
DP1000 - PR - True Endow |
C1550 - Investments ST |
If Fund is a child of DP1000, then Account can only be under C1550 or C1910, or equal to 10990, 50901, or 95202. |
Quasi Endow Corpus |
DQ5000 - UR - Quasi Endow |
C1550 - Investments ST |
If Fund is a child of DQ5000, then Account can only be under C1550, C1910, C5100, C9000, E2000, E2340, E9160, or E9520, or equal to 10990, 30955, 50901, 95007, or 95203. |
Quasi Endow Distribution |
D15000 - UR - Quasi Endow Dist Donor Desig |
B7000 - Total Operating Expenses |
If Fund is a child of D15000, then Account can only be under B7000, C1300, C1800, C5100, C9000, D7540, D9500, E2000, or E9160, or equal to 10124, 10990, 23340, 52895, 52899, or 76941. |
Recharge |
C34600 - Recharge |
010 - Balance Sheet |
Recharge Funds between 346000 and 346999 can only be used with Purpose values 010, 820, or 999. |
Recharge Inverse |
820 - Recharge Operations |
C34600 - Recharge 358037 - CP-FY22 Arc Tunnel Washer |
If Purpose is equal to 820, then Fund can only be under C34600 (Recharge Funds), D35000, or equal to 100000, 271542, 358037, or 358298. |
Temp Restricted for A&LI |
D50300 - TR - Annuity & Life Income |
C1300 - Prepaid Exp & Other Assets ST |
The account combination you are attempting to use is invalid. Please review published Cross-Validation rules for Accounts that may be used when the Fund is a child of D50300. |
Temp Restricted of True Endow |
DT1000 - TR - True Endow |
C1550 - Investments ST |
If Fund is a child of DT1000, then Account can only be under C1550, C1910, C5100, C9000, D2825, E5090, or E9160, or equal to 10990, 95000, 95200, 95201, or 95202. |
Term Endow Corpus |
DT2800 - TR - Term Endow |
C1550 - Investments ST |
If Fund is a child of DT2800, then Account can only be under C1550, C1910, C5100, C9000, D2825, E9160, or equal to 10990, 50901, 95000, 95200, 95201, or 95202. |
Term Endow Distribution |
D22800 - UR - Term Endowment Dist Donor Desig |
B7000 - Total Operating Expenses |
If Fund is a child of D22800, then Account can only be under B7000, C1300, C1550, C1800, C1910, C5100, C9000, D7540, D9500, E2000, or E5090, or equal to 10124 or 10990. |
True Endowment Distribution |
D11000 - UR - True Endow Dist Donor Desig |
B7000 - Total Operating Expenses |
If Fund is a child of D11000, then Account can only be under B7000, D7540, D9500, or equal to a limited set of values. Please review published Cross-Validation rules for full details. |
Unspecified Organization
|
99999 - Due to/Due From |
13800 - Due from/(Due to) Funds 13860 - Due from/(Due to) Univ. Entity 23340 - Other Liabilities ST 49000 - Net Assets |
Organization 99999 can only be used with system-generated Account value 13800, 13860, 23340, or 49000. |
Unspecified Purpose |
999 - Unspecified |
A9999 - Unspecified D5000 -Tuition D5040 - Fees |
Unspecified Purpose 999 can only be used with Revenue accounts under A9999, B9000, B9500, B9600, C5050, C5070, C5100, C5120, C5180, C5280, C5550, D5000, or D5040, or equal to 76918. |