Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
RosanaErnzen
Product and Topic Expert
Product and Topic Expert
¿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 - which are the VAT identification codes for input taxes (purchase) and for output taxes so that you're able to see amounts coming from sales returns.

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.

In this view, you specify all the VAT identification codes that are relevant for the 1006 report format - which are the VAT identification codes for output taxes (sales) and for input taxes so that you're able to see amounts coming from purchase returns.

At this time, after entering the VAT codes, you also 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 IVA table, whereas output values go to the IMP 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!
9 Comments