Skip to Content
Product Information

Magnetic Media Compliance Reports: The 1005 and 1006 Report Formats

¿Quiere leer este post en español?

This is the first post of a series about the report formats that you receive by default when you install magnetic media compliance reports for Colombia in ACR. 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.

It’s important that you keep in mind that the 1005 and 1006 report formats are complementary for VAT reporting. That is, sales VAT taxes are reported in the 1006 report format, but VAT taxes of returned sales are reported in the 1005 report format.

The same applies to purchase VAT taxes, which are reported in the 1005 report format, but VAT taxes of returned purchases are reported in the 1006 report format.

This relationship of the 1005 and 1006 report formats for VAT reporting implies that the configuration of these two report formats must be the same. All VAT tax codes used by the company must be entered in the configuration of the report formats. You find the detailed configuration steps below.

Consumption taxes are only reported in the 1006 report format. Generated and returned amounts on sales are reported in the ICON field. So, to identify tax codes related to consumption taxes, you need to classify them as ICON. You also find more details about this in the section about configuration settings in this post.

The 1005 Report Format

What is the 1005 report format?

You use the 1005 report format to report deductible VAT (value-added tax) values of purchases from third parties, and generated VAT values of sales from third parties that were canceled, terminated, or returned. 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 Run Compliance Reports app:

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 and the key account 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
  • VAT Tax Code
  • Account Key
  • Validity period

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 solution 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) – Run Compliance Reports app

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 VAT taxes on sales
  • Consumption taxes on sales
  • VAT returns on canceled, terminated or returned purchases

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 Run Compliance Reports app:

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 solution 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) – Run Compliance Reports app

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.

You find all the documentation for magentic 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!

2 Comments
You must be Logged on to comment or reply to a post.
  • Hi there Rosana,

     

    thanks for sharing these report overviews. Just wondering if the design studio report that show the contents of the file are delivered by standard SAP or you need to design your own reports per format?

     

    Kind regards,

    Hans.

    • Hi Hans,

      The analytical views that show the contents of the file and the XML file mapping are delivered by SAP but you can add or change depending on your contract if the CDS View has a specific Annotation  @MetadataExtension set as true.

      Still, there are limited annotations that you can use in that case.

      Thank you for your question.

      Kind Regards,
      Matheus Bica