Servicing Director IRS 1098/1099 Export Error Message When Selecting to Include the 1099-INT

Servicing Director IRS 1098/1099 Export Error Message When Selecting to Include the 1099-INT

There are xxxx loans eligible for a 1099-INT form, but all of the loans are missing Borrower, MailingAddress or StateCode information. The Export has not written any A, B or C records for the 1099-INTs.

Root Cause:

The problem and error message can be caused by any customization or coding changes made to any or all of the SQL views used in the functionality of this export event. If a client has made a change to the code, such as include code to restrict the output to a specific reporting year, then records may not be successfully selected, and the functionality of the event will be broken.


Environment:

IRS 1098/1099 Export Event - Selecting to Include 1099-INT

Workaround:

The client should review all of the SQL views delivered and used in this export, to see if any custom code has been added. The custom code should be removed and the event can then be re-run.

The SQL views accessed by the 1099-INT portion of the IRS 1098/1099 export are the following :

Q_IRS_1099INT_Export
Q_IRS_1099INT_Export_With_StateCode
Q_IRS_1099INT_Export_ReportAllAmts
Q_IRS_1099INT_Export_ReportAllAmts_With_StateCode

ArticleNumber:

000044235