- Print
- DarkLight
- PDF
View Errors and Warnings in the Data Grid
In the Data Grid for Unposted Applications in Grants and Scholarships, and for Open Items in Accounts Payable, we’ve added an error column so you can review issues that require action. With this new feature, you no longer need to run edit reports to view data issues.
To see errors and warnings in the Data Grid:
1. Go to:
- Grants > Applications
- Scholarships > Applications
--OR--
- Accounts Payable > Open Items
2. To the left of the Data Grid, click the View Settings icon.
3. Choose to edit or copy an existing view, or add a view in which to add the column.
4. Click the Columns tab.
5. Choose Functions from the drop-down list.
6. Select the error column option:
- For Grant or Scholarship Unposted Applications, select (App) $ErrorWarning.
- For Accounts Payable Open Items, select (Open A/P) $ErrorWarning.
7. Click Add>>.
8. Click Save.
Errors and warnings now display in the Data Grid. Errors are prefaced with an “*E” and display first. Errors require action. Warnings are prefaced with an “*W.” Warnings may need action.
Tip: If the error or warning does not display fully, you can drag the cell borders to widen or heighten the cell. To save the current view, right-click and choose Save View Settings.
Errors and warnings for Grants and Scholarships Unposted Applications:
Error or Warning | Description |
Error | Interfund grant amount does not equal Interfund gift amount |
Error | Interfund grant amount does not equal posted Interfund gift amount |
Error | Grant Date cannot be blank |
Error | Posting to a closed period |
Warning | Grant Date is not within one year of today |
Warning | Possible Duplicate Grant. Review Posted Grant #<number> |
Warning | Possible Duplicate Application. Review UnPosted Application #<number> |
Error | Renewal Date must be in the Future (Scholarship only) |
Warning | Fund in application does not match any in payment plan (Scholarship only) |
Warning | Fund was retired on <date> |
Error | Missing Fund record |
Error | Invalid Payment Date |
Warning | Payment date is prior to Today |
Error or Warning | Grant amount exceeds balance available |
Error or Warning | Cannot match grant to available gifts |
Error or Warning | Granted amount exceeds avail to spend for <value> |
Error | Autopay option invalid. Multiple lines with different payment dates or cash accounts |
Error | Line Items don't match Grant amount |
Error or Warning | Application denied or withdrawn and grant amount > 0 |
Warning | Application has a blank payee name |
Warning | Application has an invalid payee address |
Errors and warnings for Accounts Payable Open Items:
Error or Warning | Description |
Error | No voucher history record available |
Error | Missing Grantee/Vendor Record |
Error | Grantee Flag is Off |
Error | Vendor Flag is Off |
Warning | Grantee/Vendor is flagged ACH and Voucher is not flagged ACH |
Error | No A/P Line Item History record exists for Voucher= |
Error | There has been an Internal Data mismatch for Open Item |
Error | No General Ledger Cash Account exists for Account Key |
Error | No General Ledger Payables Account exists for Account Key |
Error | This voucher will exceed the available cash amount for . . . |
Error or Warning | Un-met conditions for Voucher/App #:<number>
|