10.05.06: How to Resolve Suspended DTL3 (TDP) Records


Occasionally, you may have a suspended DTL3 record on your retirement detail report.

You can use the Download TDP Agreement Details link on the Employer Reporting website to help you resolve suspended DTL3 records. This link opens a spreadsheet that allows you to view all active TDP agreements with your reporting unit. You can sort this spreadsheet by any column. See section 10.06 How to Use the TDP Download Detail Link for instructions.

The following table will assist you in resolving these suspended records. It lists the most common error messages you may receive when a DTL3 record is suspended and what you can do to fix the record.
 

Suspended DTL3 Record Messages and Solutions
 

S– This record indicates the agreement is paid in full, yet there is still a balance remaining on the account. Find the SSN on the Download TDP Agreement Details spreadsheet.
Verify the current TDP balance. If you agree with the balance, either adjust the deduction amount on your DTL3 record to match the scheduled deduction amount or change the amount to reflect the remaining balance. Save the record and accept your report for posting. Any money deducted from the employee’s pay above the remaining balance should be refunded to the employee.
If you do not agree with the TDP balance, call the Employer Reporting at 800-381-5111 for assistance or submit an email to ORS_Web_Reporting@michigan.gov requesting a TDP history.
S – Agreement number does not exist with this employer processed. Find the SSN on the Download TDP Agreement Details spreadsheet.
Find the agreement number on the spreadsheet for the SSN. Change the agreement number on the DTL3 record to match what is on the spreadsheet. Save the record and accept your report for posting. If the SSN is not on the spreadsheet, then ORS has not received the agreement. Please call Employer Reporting at 800-381-5111 for assistance.
S – The payment is received for an invoice that has been completely paid. This message means that ORS shows the invoice has been paid in full. Delete the DTL3 record from your payroll report and do not submit a DTL3 record for this invoice on any future reports. Any money deducted from the employee’s pay that exceeds the remaining balance should be refunded to the employee.
If you do not agree that the invoice has been paid in full, call the Employer Reporting at 800-381-5111 for assistance or submit an email to ORS_Web_Reporting@michigan.gov requesting a TDP history.
If you identify that there is an error in the payment detail, submit an email to ORS_Web_Reporting@michigan.gov requesting an adjustment to the TDP record.
S – Invoice Number xxxxxxxx does exist for SSN being processed but billing is not in accepted status. Find the SSN on the Download TDP Agreement Details spreadsheet. Verify that you are using the correct agreement AND invoice numbers, including the leading zeroes. Change the agreement and/or invoice numbers on the DTL3 record to match the spreadsheet. Save the record and accept your report for posting.
S – Invoice number does not exist in the system for the SSN being processed. Find the SSN on the Download TDP Agreement Details spreadsheet. Verify the invoice number for the agreement. Change the invoice number on the DTL3 record to match the spreadsheet. Save the record and accept your report for posting.
S – Invoice number exists for SSN but invoice number does not match the invoice number for the reported agreement number. Find the SSN on the Download TDP Agreement Details spreadsheet. Find the invoice number on the spreadsheet. Change the invoice number on the DTL 3 record to match the number on the spreadsheet. Save the record and accept your report for posting.
S – The deduction amount is greater than the balance remaining on the invoice. Find the SSN on the Download TDP Agreement Details spreadsheet.
If the spreadsheet shows unposted deductions, you must subtract the unposted deductions from the remaining balance shown on the spreadsheet to determine the correct remaining balance. Enter the remaining balance on the DTL3 record. Save the record and accept your report for posting.
Note: Any money deducted from the employee’s pay above the remaining balance should be refunded to the employee.
S – The deduction amount is less than scheduled deduction amount and it is not final payment. Find the SSN on the Download TDP Agreement Details spreadsheet.
If the spreadsheet shows unposted deductions, you must subtract the unposted deductions from the remaining balance shown on the spreadsheet to determine the correct remaining balance. If you agree with the TDP balance, enter the remaining balance on the DTL3 record. Save the record and accept your report for posting. Note: The reporting unit is responsible for collecting the money due from the employee.
-OR-
You recently submitted a supplemental TDP agreement, and the new deduction amount was entered before all deductions of the lower amount posted. Contact the Employer Reporting at 800-381-5111 for assistance with getting the payment posted.
-OR-
If you do not agree with the TDP balance, call the Employer Reporting at 800-381-5111 for assistance or submit an email to ORS_Web_Reporting@michigan.gov requesting a TDP history.
S – This is a duplicate pay period end date for the same agreement. There is more than one DTL3 record on your payroll report for the same agreement/invoice for the same SSN with the same pay period end date. Only one record type 01 DTL3 record per agreement per payroll report is allowed. Delete any duplicate DTL3 records.
If you are trying to adjust a prior pay period, contact Employer Reporting at 800-381-5111 for assistance.
It is also possible that the same agreement and/or invoice numbers were incorrectly used on a DTL3 record for another employee. If two employees have suspended DTL3 records with the same error message, check each one to make sure the agreement and invoice numbers are correct.

Last updated: 12/27/2018