The Administration > Invalid Transactions page shows error message:
No rate was found for this transaction
All Clarity versions
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.
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.
*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.
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.