3330317 - Mexico DIOT Report Displays Information Message: “No items to report;Query DOC_SEL did not return any data” With the Supplier Summary File Size 0 Byte

Upon executing the Mexico DIOT Report, the system does not return any data. Mexico DIOT Report Displays the below information message and further, the Supplier summary file is of size 0 Byte

No items to report;Query DOC_SEL did not return any data

SAP S/4HANA Cloud

1. Go to the app Run Statutory Reports
2. Choose the Filters
3. Report Name: MX_VAT_DCL – Mexico DIOT Report
4. Reporting Year: XXXX
5. Click the required entry for Reporting Period: YYYYY
6. In the Current Phases tab, click the Mexico Monthly VAT Report With Reported Item Log Information
7. At the top right corner, click the button New Run
8. In the Selection Criteria for Mexico Monthly VAT Report With Reported Item Log Information, select as below:
9. Company Code: XYZ
10. Reporting Date: DD.MM.YYYY – DD1.MM1.YYYY1
11. Run Options: Start a Short Run Now (Less than 3 Minutes)
12. Click on Run
13. The Run is Generated Successfully
14. Click open the Report Run Status
15. In the Legal Reporting section, the Document: Supplier summary file is of size 0 Byte
16. At the bottom of the screen, in the Log, you see the Information message

where XXXX represents the Reporting Year
YYYYY represents the Reporting Period

The field Type of Business is not maintained in the Vendor: Tax Data of the Business Partner. 

1. Go to the app Maintain Business Partner
2. Find the Supplier ID
3. Display in BP role: FLVN00 Supplier (Fin.Accounting)
4. Go to the tab Vendor: Tax Data
5. In the section Tax Calculation Korea, the field Type of Business is empty

Type of Business field informs the business type you have configured for your supplier in the Define Transaction Types for Vendors (SSCUI ID - 105629) customizing activity. 
You may define the Types of Business in the SSCUI ID – 103052

Once you have defined the Type of Business for your vendor that is applicable for DIOT report, you will be able to generate a file with entries.

Note:
Business type is used to determine two important information for the vendor in the DIOT report: vendor transaction types and VAT group version (tax box) to be considered. One business type is used to derive one or multiple transaction types - (each transaction type is then assigned to a VAT group version)

Single transaction type means that the vendor only provides me one type of service / product, for instance: 3 - Professional Services
On other hand, multiple transaction types means that the vendor provides me more than one type of service / product, for instance: 3 - Professional Services and 6 - Real Estate Lease.

You must enter the Type of Business with numbers 11, 12, 13, 14, 15, 21, 22, 23 and 24.

Go to the BP transaction and assign the business type to your vendor according to the following rule: 

1. Use a business type with numbers from 11 to 15 when you want to maintain a single transaction type for each one of your vendors.
2. Use a business type with numbers from 21 to 24 when you want to maintain multiple transaction types for each one of your vendors. 

You can assign a grouping version for each transaction type according to your monthly VAT returns.
You can use the following values as a template to group your transaction types: 

Transaction Type	Number of Grouping Version
Professional Services	N03
Real Estate Lease	N06
Others	N85
Acquisition of Other Intangible Goods	F29

  

Example

Here's an example of mapping that you can use as a template for your configuration:

Define Transaction Types for Vendors - (SSCUI ID - 105629)

Transaction Type	Number of Grouping Version	Ord. (Business Type)
85 Others	N85	11
85 Others	N85	12
03 Professional Services	N03	13
06 Real Estate Lease	N06	14
29 Acquisition of Other Intangible Goods	F29	15
03 Professional Services	N03	21
85 Others	N85	21
06 Real Estate Lease	N06	22
85 Others	N85	22
03 Professional Services	N03	23
06 Real Estate Lease	N06	23
29 Acquisition of Other Intangible Goods	N29	24
85 Others	F85	24

 

Mexico DIOT Report

Configuration for DIOT Report

Type of Business, MXTVO, Business Partner, BUSTYPE, Supplier, FIMXV_MXTVO, Maintain Business Partner, Tax Data, Vendor, 105629, Tax Calculation Korea, DIOT Report, Mexico, 103052, No items to report, DOC_SEL, Supplier Summary File, Size, 0 Byte, Zero Byte, Mexico Monthly VAT Report, MX_VAT_DCL, Professional Services, Real Estate Lease, Acquisition of Other Intangible Goods, Others , KBA , LO-MD-BP-VM , Vendor Master , Problem

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions