RELATED IDEAS
Rename the error messages
It would be quite helpful to have each error in the validation results be its own error number. Below is a chart of some current error codes and their proposed new error codes. If one of the proposed new error codes is already taken by another error, then you can choose another error code; this is merely a suggestion (I skipped the numbers which I know are already in use for other errors). The important part to note is the six rows in different colors. These errors should be the same error code, as it's basically the same error or fixed in a similar manor.
Current Error Code |
Error Message |
Location |
Proposed new error code |
3 |
Bank Description missing (blank) |
BANK-DEF |
1 |
3 |
Bank Name missing (blank) |
BANK-DEF |
2 |
3 |
Bank Address missing (blank) |
BANK-DEF |
3 |
3 |
Required Field |
BANK-DEF |
4 |
3 |
Missing AP account for cash client |
BANK-DEF |
5 |
7 |
Summary GL account Sub-Type does not match detail account Sub-Type |
GL |
6 |
7 |
Summary GL account must be blank for S and SI accounts |
GL |
7 |
7 |
Must be one of the following: 0,1 |
CC |
8 |
7 |
Must be one of the following: 0,1,NULL |
VENDOR |
9 |
20 |
Invalid 1099 code |
VENDOR |
20 |
20 |
Invalid 1099 Reporting State |
VENDOR |
20 |
20 |
Invalid Pay Via Bank 20 - cash GL account 10296 is inactive as of 12/31/2016 |
BANK-DEF |
21 |
20 |
Invalid Pay Via Bank 20 - terminated as of 12/31/2016 |
BANK-DEF |
21 |
20 |
Missing current year earnings account 32510 from GL file |
GL |
22 |
20 |
Missing previous year earnings account 3200-01 from GL file |
GL |
22 |
20 |
DDS definition MILLER.50 missing from CLIENT file |
BANK-DEF |
23 |
20 |
Invalid Pay Via Bank 2 - cannotread |
BANK-DEF |
24 |
20 |
Missing AP account 22100 from GL file |
AP |
26 |
20 |
Missing cycle definition item M20 from DFT.GP,CYCLE file |
REPINV |
29 |
20 |
Missing default account 55700 from GL file |
VENDOR |
31 |
20 |
Unable to read item 10399 from GL file |
BANK-DEF |
32 |
20 |
Unable to read non-divisional GL item for 52409.04.00.726 |
GL |
33 |
20 |
Unable to read summary GL account 4000-000 |
GL |
34 |