SAP Knowledge Base Article - Public

3144227 - Report USA Withholding Tax - 1099 MISC did not return any data

Symptom

In log the following messages are shown:

Correspondence 'CORRESPONDENCE' could not be generated.     
No items to report;Query DOC_SEL did not return any data.        

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP S/4HANA Cloud

Reproducing the Issue

Example in app Run Statutory Reports (App id F1515) follow steps in help documentation Withholding Tax (1099-MISC) Report

Cause

There could be a number of causes:

  • No withholding specific document 

  • Document not cleared 
    For Example from Help Documentation Withholding Tax (1099-NEC) Report
    the following is stated:
    The withholding tax report is generated based on the information collected from supplier documents, for example, supplier cleared invoices, supplier credit memos, and open down payments.

  • Document is available, clearing is done but wrong withholding tax codes are used



Resolution

  • Check Journal Entry, In app Check Withholding Tax Settings and Simulate Calculation, simulate a posted document

  • In App Manage Supplier Line Items check status of journal Entry

  • Use correct report for withholding tax codes for supplier.

see Define Withholding Tax Codes 
which references:

Withholding Tax Codes for Form 1099-MISC

Withholding Tax Codes for Form 1099-NEC

Withholding Tax Codes for Form 1099-INT

Withholding Tax Codes for Form 1099-G

Withholding Tax Codes for Form 1099-K

Withholding Tax Codes for Form 1042-S
 

See Also

Document and Reporting Compliance

Keywords

1099-NEC,US_WHT_1099MISC,US_RPG_ENT, Run Advance Compliance Reports , KBA , FI-AP-AP-Q1 , Withholding Tax (Reporting) , FI-LOC-FI-US-WHT , Withholding Tax , Problem

Product

SAP S/4HANA Cloud all versions