Skip to Content

Hi everyone,

This is the first post of a series about the report formats you receive by default when you install the Magnetic Media compliance report. The objective of this series is to give you more details about these report formats so that you become able to make the configurations to run them correctly in your system.

To start with the report-formats series, let’s go through the basics you need to know about the 1005 and 1006 report formats.

 

The 1005 Report Format

What is the 1005 report format?

You use the 1005 report format to report deductible tax values of sales from third party, and generated VAT (value-added tax) values of sales from third party that were canceled, terminated or completed. All these values correspond to the prior year.

Find below the information reported in the seventh version of the XML file that you inform to DIAN (Dirección de Impuestos y Aduanas Nacionales) when you run the 1005 report format in the Magnetic Media compliance report.

ATTRIBUTE

 TITLE

TYPE

LENGTH

CRITERIA

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.

dv

Verification digit

int

1

For the 31-document type (NIT).

Report this data if you have this information.

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.

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.

vimp

Deductible tax

double

20

This data must be a positive and whole number. Do not include periods or commas.

This data must be always reported.

ivade

VAT returns on canceled, terminated or completed sales

double

20

This data must be a positive and whole number. Do not include periods or commas.

This data must be always reported.

You can find more information about the technical details of the report formats in the DIAN portal: https://www.dian.gov.co/.

How to configure the 1005 report format

Before running the 1005 report format, you need to configure data sources for the extraction. To do so, all you have to do is to specify all the VAT identification codes in the Maintain VAT Codes customizing activity.

To access this customizing activity, go to SAP Customizing Implementation Guide > Financial Accounting > General Ledger Accounting > Periodic Processing > Report > Statutory Reporting: Colombia > Magnetic Media (DIAN) > Configure Data Sources for Report Formats > Maintain VAT Codes.

In the Maintain VAT Codes customizing activity, you find the following view:

In this view, you specify all the VAT identification codes that are relevant for the 1005 report format. You also inform:

  • Procedure
  • Tax Code
  • Account Key
  • Validation: beginning and end of validation

You don’t need to fill the Amount Classification column, since values are automatically classified according to their tax type (input values go to the VIMP table, whereas output values go to the IVADE table).

Ready! After setting this configuration, the Magnetic Media compliance report automatically extracts and organizes relevant data in the output XML file when you run the 1005 report format.

See below the steps to run the 1005 report format:

Advanced Compliance Reporting (ACR) – Magnetic Media compliance report

Execution example: 1005 report format

Execution example: 1005 report format

Execution example: 1005 report format

Execution example: 1005 report format

Execution example: Analytics in 1005 report format

Execution example: Output XML file of 1005 report format

 

The 1006 Report Format

What is the 1006 report format?

You use the 1006 report format to report the following values:

  • Generated taxes on sales
  • VAT returns on canceled, terminated or completed sales
  • Consumption taxes

Find below the information reported in the seventh version of the XML file that you inform to DIAN when you run the 1006 report format in the Magnetic Media compliance report.

ATTRIBUTE

TITLE

TYPE

LENGTH

CRITERIA

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.

dv

Verification digit

int

1

For the 31-document type (NIT).

Report this data if you have this information.

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.

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.

imp

Generated tax

double

20

This data must be a positive and whole number. Do not include periods or commas.

This data must be always reported.

iva

VAT returns on canceled, terminated or completed sales

double

20

This data must be a positive and whole number. Do not include periods or commas.

This data must be always reported.

icon

Consumption tax

double

20

This data must be a positive and whole number. Do not include periods or commas.

This data must be always reported.

You can find more information about the technical details of the report formats in the DIAN portal: https://www.dian.gov.co/.

 

How to configure the 1006 report format

You also need to configure data sources for extraction in the 1006 report format. To do so, you have to enter VAT codes in the Maintain VAT Codes customizing activity too.

The path to access this customizing activity is the same as in the 1005 report format (see the images above). Go to SAP Customizing Implementation Guide > Financial Accounting > General Ledger Accounting > Periodic Processing > Report > Statutory Reporting: Colombia > Magnetic Media (DIAN) > Configure Data Sources for Report Formats > Maintain VAT Codes.

At this time, after entering the VAT codes, you have to specify if they are values of consumption tax in the Amount Classification column.

Values that are classified as consumption tax in the Amount Classification column go to the ICON table. Other values are automatically classified according to their tax type (input values go to the IMP table, whereas output values go to the IVA table).

The 1006 report format configuration is done! Now the Magnetic Media compliance report automatically extracts and organizes relevant data in the output XML file when you run this report format.

See below the steps to run the 1006 report format:

Advanced Compliance Reporting (ACR) – Magnetic Media compliance report

Execution example: 1006 report format

Execution example: 1006 report format

Execution example: 1006 report format

Execution example: 1006 report format

Execution example: Analytics in 1006 report format

 

 

Execution example: Output XML file of 1006 report format

 

We hope this 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

 

Want to read this post in Spanish?

 

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

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