Invalid Transactions – SQL

The Invalid Transactions portlet displays all of the transactions that did/will not post in Clarity. The benefit of this portlet is that you can use the filter to select a specific project, resource, or error to display all transactions associated to your selection.

There are several reasons a transaction may fail to post such as inactive resource, no location or inactive location selected on the Financial sub-page, project on hold, etc. To resolve the error, the user must go into the project or resource and make the noted change. Once all corrections are complete, the  Post Transactions to Financials job must be run to evaluate the corrected WIP transactions to be sure the data is now complete and accurate. If additional incorrect data is found, the transaction will fail to post again and the new error/reason will display.