Skip to Content

Hi there,

Continuing with the report-format series that talks about the report formats you receive by default when you install the Magnetic Media compliance report solution, today we’ll talk about the 1007 report format.

If you missed the first post, check it out here: Magnetic Media Compliance Report: The 1005 and 1006 Report Formats.

Now let’s go through the basics of the 1007 report format:

After all, what is the 1007 report format?

In a few words, you use the 1007 report format to report gross amounts received by your company during a period of time. These gross revenues comprise returns, refunds, and discounts.

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:

Find below the information you report in the XML output file of the 1007 report format (version 9) when you run the Magnetic Media compliance report.

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 social code
  • The validity dates
  • The value classification

Ready! After doing this configuration, the Magnetic Media compliance report 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) – Magnetic Media compliance report

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

 

We hope this blog post is useful for you.

Are you missing any information about the Magnetic Media compliance report? Let us know in the comments. Your doubt can be the subject of our next post.

And don’t forget to follow the SAP S/4HANA Finance tag to stay tuned on Magnetic Media latest news.

Until the next post,

Rosana

 

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

 

Want to read this post in Spanish?

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply