SMART Messages

SMART Logo

 
MESSAGE 060911-01
DATE June 9, 2011
AUTHOR Travel & Expense
Subject 3 new AP/Travel & Expense queries are now available

Message Text:

There are 3 new queries available in the SMART system that will help agencies identify Accounts Payable and Travel & Expense transactions that have not fully processed in the system. Agencies should incorporate running these queries as part of their month-end check list. For end of year clean up, these queries will be very useful to identify transactions that will need to be completed or deleted before close of business July 13, 2011.

Navigation: Reporting Tools>Query>Query Viewer>UNPROCESSED_EXPENSE_REPORTS – Users will enter a date range based upon when the Expense Report was created. The query returns all unprocessed Expense Reports sorted by status and report id. Expense Reports with a status of DEN can either be deleted or left in the system depending on your agency’sbusiness process.

Navigation: Reporting Tools>Query>Query Viewer>UNPROCESSED_TRAVEL_AUTHS – Users will enter a date range based upon the accounting date of the Travel Authorization. This will typically be the date the Travel Authorization was created. The query returns all Travel Authorizations that have not fully processed in the system sorted by Travel Date From and Travel Auth ID number. Note** Travel Authorizations with a status of APR and a valid budget status are encumbering funds.

Navigation: Reporting Tools>Query>Query Viewer>UNPROCESSED_VOUCHERS – Users will enter a date range based upon the accounting date of the vouchers. This will typically be the date the Voucher was created. The query returns all Vouchers that have not fully processed in the system sorted by Voucher ID.

SMART Team

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Quick Links

Search the Site

Contact Us

Send us an email

Sign Up

Sign up for the SMART InfoList