¿Quiere leer este post en español?
Giving continuity to our series about the report formats you receive by default when you install magnetic media compliance reports, 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:
You use the 1008 report format to report debtors’ balances on the last day of the fiscal year, which generally is on December 31st.
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.
Make sure you have applied SAP Note 2854549 so that you have the 1008 report format properly working in your system.
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 1....
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:
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.
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).
In the Maintain G/L Accounts customizing activity, you find the following view:
In this view, enter:
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.
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:
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/s4h_op_colombia) 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
This post was translated from English into Spanish using the SAP Translation Portal. Check it out!
Giving continuity to our series about the report formats you receive by default when you install magnetic media compliance reports, 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:
- Magnetic Media Compliance Reports: The 1005 and 1006 Report Formats
- Magnetic Media Compliance Reports: The 1007 Report Format
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, which generally is on December 31st.
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.
Make sure you have applied SAP Note 2854549 so that you have the 1008 report format properly working in your system.
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 1....
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 visually impaired readers: 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 visually impaired readers: 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 visually impaired readers: 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 visually impaired readers: 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 visually impaired readers: 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/s4h_op_colombia) 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
This post was translated from English into Spanish using the SAP Translation Portal. Check it out!
- SAP Managed Tags:
4 Comments
