Clarity PPM: Invalid Transaction Error Message: No rate was found for this transaction

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Administration  > Invalid Transactions page shows error message:
No rate was found for this transaction

 

Environment

All Clarity versions

Cause

Either there is no rate matrix associated with the project or
the rate matrix associated with the project does not have a rate associated with the project team assignment resource.

 

Resolution

Solution 1:

The project was missing the Financial Transactions Rate Matrix reference. The project must reference an active Rate Matrix for the configuration to pick up the proper rates; if you do not define this, the application cannot link all the transactions to the proper rates.

1. Home, Projects, Open the project, Properties Tab, Financial Properties page 
2. In the Labor Transaction Rates Section, browse for the Labor Rate Source (select an existing Rate Matrix) 
3. In the Labor Transaction Rates Section, browse for the Labor Cost Source (select an existing Rate Matrix) 
4. Save the changes 

*Note: if you are going to have transactions for Materials, Expenses and Equipment, then you need to define a Rate Matrix for those types of transactions as well on the financial properties page.

If the project financial properties already has a valid Matrix selected, then the rejected reason can be due to no matching row within the matrix is found when the 'Post Financial Transactions' job is executed. To determine if a valid matrix row exists for the specific financial transaction with this rejected reason, search for a valid row on the Matrix.

1. Administration, Finance: Manage Matrix, Select the desired Matrix definition.
2. Go to 'Edit Rows'.
3. Search for valid rows within the matrix that would match the actual data in the transaction. 
4. If a valid row does not exist, create a 'default' (catch-all) row with an asterisk in all attribute columns to cover the date range or create a matching row.  
5. Execute the 'Post Transactions' job again, after updating the Matrix definition.
6. Also be sure to execute the 'Rate Matrix Extraction' job with options #2 and #3 to prepare and update the entire matrix to update any existing rates.

Solution 2:
Run the following query:

select
imp.job_id, IMP.SOURCEMODULE, IMP.EXTERNALBATCHID tsid, IMP.APPLY_TO_EXTERNAL_ID,
TO_CHAR(imp.importdate, 'MM-DD-YYYY HH24:MI:SS Dy') PTFjob,
imp.transdate, imp.quantity, imp.importstatus, imp.errorcode,
err.description, err.lookup_code, imp.project_code, inv.id, inv.name,
IMP.RESOURCE_CODE, SRMR.LAST_NAME, SRMR.FIRST_NAME, IMP.ROLE_CODE,
pacp.status, pacp.type_, pacp.locationid, pacp.departcode,
IMP.INPUT_TYPE, IMP.CHARGE_CODE, imp.fatalerror
from
IMP_TRANSACTIONIMPORT IMP,
imp_transactionimporterrors err,
INV_INVESTMENTS INV,
pac_mnt_projects pacp,
SRM_RESOURCES SRMR
WHERE 1=1
and srmr.unique_name = imp.RESOURCE_CODE
AND INV.CODE = IMP.PROJECT_CODE
and inv.id = pacp.id
AND ERR.ERRORCODE = IMP.ERRORCODE
order by IMP.EXTERNALBATCHID

Check the financial properties and make sure it matches what was entered in the timesheet/rate matrix.

Rerun the following jobs:
-Rate Matrix Extraction (full)
-Post Timesheets
-Post Transactions to Financials

 

If you find the Resource Class or Transaction Class is wrong on the resource and you just need to update that on the resource and run Post Transactions to Financials job not the 2 others.