Product Information
Magnetic Media Compliance Reports: The 1007 Report Format
¿Quiere leer este post en español?
Continuing with the report-format series that talks about the report formats you receive by default when you install the magnetic media compliance reports, today we’ll talk about the 1007 report format.
If you missed the first post, check it out here: Magnetic Media Compliance Reports: The 1005 and 1006 Report Formats.
Now let’s go through the basics of the 1007 report format:
What is the 1007 report format?
In a few words, you use the 1007 report format to report in the IBRU field the gross revenues amounts received by your company during a fiscal year period, and returns, refunds, and discounts applied to sales in the DRED field.
Recently, the Colombian government by the means of DIAN (Dirección de Impuestos y Aduanas Nacionales) launched a new version for the 1007 report format, that consequently turned from version 8 to version 9.
This new version of the 1007 report format is established in resolution 000060 of 2017, and goes live on 2019 for reporting the fiscal year of 2018.
Basically, the changes in the 1007 report format include a new organization for values classification – which now are done through the elements IBRU and DRED of the output XML file.
To update your system to run with version 9 of the 1007 report format, apply the SAP Notes listed below:
- 2681415 – Magnetic Media [1]: Automatic Implementation of Objects for SAP Note 2660269
- 2660269 – Magnetic Media [2]: 1007 Report Format Update from Version 8 to Version 9
Find below the information you report in the XML output file of the 1007 report format (version 9) when you run the report format in the Run Compliance Reports app.
The data described in the table below is extracted for each one of the revenue accounts that you customize and classify as IBRU or DRED.
ATTRIBUTE |
TITLE |
TYPE |
LENGHT |
CRITERIA |
cpt | Item type | int | 4 | According to what is specified in the DIAN resolution. This data must be always reported. |
tdoc | Document type | int | 2 | According to what is specified in the DIAN resolution. This data must be always reported. |
nid | Identification number | string | 20 | Fill this data without hyphens, periods, commas or blank spaces. This data must be always reported. |
apl1 | First surname of who is reporting | string | 60 | This data is mandatory for natural persons. |
apl2 | Second surname of who is reporting | string | 60 | This data is mandatory for natural persons. Report this data if you have this information. |
nom1 | First name of who is reporting | string | 60 | This data is mandatory for natural persons. |
nom2 | Other names of who is reporting | string | 60 | This data is mandatory for natural persons. |
raz | Social reason | string | 450 | This data is mandatory for legal persons. Report this data if you have this information. |
pais | Country of residence | int | 4 | According to what is specified in the DIAN resolution. This data must be always reported. |
ibru | Gross revenue received | long | 18 | This data must be a positive and whole number. Do not include periods or commas. This data must be always reported. |
dred | Returns, refunds, and discounts | long | 18 | This data must be a positive and whole number. Do not include periods or commas. This data must be always reported. |
Remember that the Item type, Document type y Identification Number fields are composed of a unique key for the 1007 report format, and that this key is repeated for the registers of one sent file.
If you report a NIT in the Identification Number field, use the NIT number and its verification digit as well.
You can find more information about the report formats in DIAN portal: https://www.dian.gov.co/.
How to configure the 1007 report format
Before you run the 1007 report format (CO_DIAN_1007), you need to configure data sources for the extraction. To do so, you have to assign G/L accounts and their item types according to what is relevant to the 1007 report format, and you also inform their validity and classification.
To access the Maintain G/L Accounts customizing activity, go to:
In the Maintain G/L Accounts customizing activity, you find the following view:
In more details, in this view you enter:
- The interval of G/L accounts that are relevant for the 1007 report format
- The item types for the G/L accounts you entered
- The company code
- The validity dates
- The amount classification (IBRU for gross revenue accounts and DRED for returns, refunds, and discounts applied to sales)
Ready! After doing this configuration, the solution automatically extracts and organizes the relevant information in an XML output file when you run the 1007 report format.
Find below the sequence of execution for the 1007 report format:
Advanced Compliance Reporting (ACR) – Run Compliance Reports app
Example of execution: 1007 report format
Example of execution: 1007 report format
Example of execution: 1007 report format
Example of execution: 1007 report format
Example of execution: 1007 report format
Example of execution: 1007 report format output XML file in version 9
You find all the documentation for magnetic media compliance reports for Colombia in the SAP Help Portal, under help.sap.com/viewer/s4h_op_colombia.
If you have doubts about Magnetic Media in Colombia, you can also refer to SAP FAQ Note for Magnetic Media.
Are you missing any information about the magnetic media compliance reports? Let us know in the comments. Your doubt can be the subject of our next post.
And don’t forget to follow the Advanced Compliance Reporting tag to stay tuned on news about Magnetic Media in ACR for Colombia.
See you next time and stay compliant ?,
Rosana
#ACR #SAPGoGlobal #SAPLocalization
If you enjoyed this post, you may be also interested in this one: Reporte de Medios Magnéticos: Lo que usted socio tiene que saber
This post was translated from English into Spanish using the SAP Translation Portal. Check it out!