Skip to Content
Product Information

Magnetic Media Compliance Reports: The 1008 Report Format

¿Quiere leer este post en español?

Giving continuity to our series about the report formats you receive by default when you install the Magnetic Media compliance reports solution, today we’ll go through the 1008 report format (CO_DIAN_1008).

If you missed the previous posts of the series, you can find them here:

 

The 1008 Report Format

 

How can you use the 1008 report format?

You use the 1008 report format to report debtors’ balances on the last day of the fiscal year – generally it’s December 31th.

To calculate a debtors’ balance, the report extracts open items from both customers and suppliers based on the G/L accounts you have configured for the 1008 report format. In addition, all open items related to down payments from suppliers are included when you have configured a G/L account for down payments.

According to resolution 000060 of 2017, the government of Colombia requires that the 1008 report format includes minimum amount calculation. This requirement goes live on 2019 for reporting the fiscal year of 2018 onwards.

The minimum amount calculation is a customizing setting that you use to configure your system to report values from open items according to a minimum amount that you specify. With this configuration, the system aggregates values in one single line of the XML output file according to threshold you have specified. That is, all amounts that are under this threshold are aggregated in this single line of the XML output file.

To set a minimum amount threshold for each report format, go to SAP Customizing Implementation Guide > Financial Accounting > General Ledger Accounting > Periodic Processing > Report > Statutory Reporting: Colombia > Magnetic Media (DIAN) > Define Minimum Amount for Report Formats, and specify the report format, the minimum amount and the validity of this configuration.

To enable the minimum amount setting for the 1008 report format, make sure you have applied SAP Note 2594183 – Colombia Magnetic Media Compliance Reporting in SAP S/4 HANA OP1709 FPS1/FPS2 – 1008 and 1009 Legal Change.

Find below the information you report in the XML output file of the 1008 report format when you run this report in the Run Advanced Compliance Reports app:

Attribute

Title Type Length

Criteria

Cpt Item type Int 4 According to DIAN’s resolution. This data must be always reported.
Tdoc Document type Int 2 According to DIAN’s 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 Report this data for type 31 documents – Nit, if you have this data, report it.
Apl1 Debtor’s first name String 60 This data is mandatory for natural persons.
Apl2 Debtor’s second name String 60 This data is mandatory for natural persons if you have it.
Nom1 Debtor’s first name String 60 This data is mandatory for natural persons.
Nom2 Debtor’s other names String 60 This data is mandatory for natural persons if you have it.
Raz Debtor’s social reason String 450 This data is mandatory for legal persons.
Dir Address String 200 This data is mandatory if the residency country is Colombia.
Dpto Department code Int 2

DANE – numeric code, include zeros to the left hand-side.

This data is mandatory if the residency country is Colombia.

Mun Municipal code Int 3

DANE – numeric code, include zeros to the left hand-side.

This data is mandatory if the residency country is Colombia.

Pais Residency or domiciliary country Int 4 According to DIAN’s resolution. This data must be always reported.
Sal Debtor’s payable balance in December 31th Double 20

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

This data must be always reported.

The Item Type, Document Type, and Identification Number fields are composed of a unique key for the 1008 report format, and that this key is repeated for the registers of one sent XML file.

You can find more information about Magnetic Media report formats in DIAN portal: https://www.dian.gov.co.

How to configure the 1008 report format

Before you run the 1008 report format, you need to configure data sources for extraction. To do so, you have to assign G/L accounts and item types – together with their validity and classification – according to what is relevant to the 1008 report format.

Having said that, the first configuration setting you need to visit is the Maintain G/L Accounts customizing activity.

To access the Maintain G/L Accounts 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 G/L Accounts (FICODIANV_GLA).

For blindsided people to see: The picture shows a screenshot of the SAP system in SPRO transaction, with a highlight in the structure to draw attention to the Maintain G/L Accounts customizing activity.

In the Maintain G/L Accounts customizing activity, you find the following view:

For blindsided people to see: The picture shows a screenshot of the Maintain G/L Accounts view in edition mode.

In this view, enter:

  • Customer and vendor reconciliation accounts
  • Vendor down payments accounts
  • The item types for the G/L accounts you have entered
  • The company code
  • The validity dates

After maintaining the relevant G/L accounts, you can set a threshold for the minimum amount.

Go to SAP Customizing Implementation Guide > Financial Accounting > General Ledger Accounting > Periodic Processing > Report > Statutory Reporting: Colombia > Magnetic Media (DIAN) > Define Minimum Amount for Report Formats (FICODIANV_MINAMT), and define a threshold for the minimum amount calculation.

For blindsided people to see: The picture shows a screenshot of the SAP system in SPRO transaction, with a highlight in the structure to draw attention to the Define Minimum Amount for Report Formats customizing activity.

For blindsided people to see: The picture shows a screenshot of the Define Minimum Amount for Report Formats view in edition mode.

Ready! After setting these configurations, the 1008 report format automatically extracts and organizes the relevant information in an XML output file that you can send to DIAN.

Find below the step by step execution of the 1008 report format:

For blindsided people to see: The pictures are screenshots of the step that is being described.

1 – In the SAP Fiori Launchpad, choose the Run Compliance Reports app.

2 – Filter for the CO_DIAN_1008 report format and choose the run you want to execute.

3 – Choose New Run.

4 – Enter the required parameters and choose Run.

5 – When your run is successfully generated, select it to see the details.

6 – Select the generated file, and choose Donwload.

7 – Your XML output file is ready for you to send it to DIAN! 🙂

We hope this blog post is useful for you.

If you have doubts about Magnetic Media reports, see our FAQ SAP Note.

Want to know more about the Magnetic Media reports in ACR? See Magnetic Media (https://help.sap.com/viewer/S4HANACOLOMBIA) in the SAP Help Portal.

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

Until the next post,

Rosana

#SAPGoGlobal #SAPLocalization

 

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