Symptom
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
Environment
SAP S/4HANA Cloud
Reproducing the Issue
- Go to the app Run Statutory Reports
- Choose the Filters
- Report Name: MX_VAT_DCL – Mexico DIOT Report
- Reporting Year: XXXX
- Click the required entry for Reporting Period: YYYYY
- In the Current Phases tab, click the Mexico Monthly VAT Report With Reported Item Log Information
- At the top right corner, click the button New Run
- In the Selection Criteria for Mexico Monthly VAT Report With Reported Item Log Information, select as below:
- Company Code: XYZ
- Reporting Date: DD.MM.YYYY – DD1.MM1.YYYY1
- Run Options: Start a Short Run Now (Less than 3 Minutes)
- Click on Run
- The Run is Generated Successfully
- Click open the Report Run Status
- In the Legal Reporting section, the Document: Supplier summary file is of size 0 Byte
- 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
Cause
The field Type of Business is not maintained in the Vendor: Tax Data of the Business Partner.
- Go to the app Maintain Business Partner
- Find the Supplier ID
- Display in BP role: FLVN00 Supplier (Fin.Accounting)
- Go to the tab Vendor: Tax Data
- In the section Tax Calculation Korea, the field Type of Business is empty
Resolution
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:
- 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.
- 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 |
See Also
Keywords
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