Skip to main content
Mitratech Success Center

Error: Line Item # Conflicts with Existing Rate

When uploading your rate request, the error show: Line item 1 conflicts with existing rate.  This error can be caused by two different problems.

Cause #1:   

The Rate Request (RR) with the RATE for the timekeeper in line 1 was 'Approved' or is 'Pending Client Approval' with dates that overlap the new rate request.

Collaborati-LineItemConflicts-1.png

Solution:

The old "Approved" rate request should be deleted and then you should be able to create the new one.  If the rate request is "Pending Client Approval" you will have to wait until it is "Approved" or "Rejected".  Review the list of Rate Requests by viewing the Timekeepers > Rate Requests page.  Note that deleting an "Approved" rate request does not delete the approved rate.

Hint: You may need to Click the Clear button on the Rate Request page to reset all the Search filters

COLL-Rate_Request_disappears_after_creation-2.png

Cause #2:

This could also be caused by two lines with the same timekeeper with overlapping information in the file.

Collaborati-LineItemConflicts-2.png

Solution:

Check if there are two or more lines with the same timekeeper in your file and remove the duplicate lines.

Tip: If you open the file in Excel, you can highlight the column with the Timekeeper Display Code and choose Conditional Formatting > Highlight Cell Rules > Duplicate Values.

Duplicate Values in Excel.png

Note: This error is not caused by Rate Sharing.  Rate Sharing allows a Firm Admin to view timekeeper and office rates that the client specifies for each office on the Rates page for a timekeeper and the Rates page of the Clients tab.

Note: It's possible that a file could have both problems listed above. For example, the file receives an error related to #2 and the file is fixed, AND then the file receives additional error(s) related to #1 and the file has to be fixed again.  Sometimes the line item number in the error message does not seem related to line in the file and it could be that the reason is that the file has both problems (but does not show error messages for all errors at once).

  • Was this article helpful?