- SAP Managed Tags:
Hi everyone!
Today you’ll learn more about the 1003 report format for magnetic media reporting in Colombia.
As usual, if you have missed our previous posts, you can find them here:
How can you use the 1003 report format?
You use the 1003 report format to report the withholding tax amounts that were charged by your customers.
Find below the information you report in the XML output file of the 1003 report format when you run this report in the Run Advanced Compliance Reports app:
You can find more information about Magnetic Media report formats in DIAN portal: https://www.dian.gov.co.
Before you run the 1003 report format, you need to configure data sources for extraction, which for the 1003 report format are the withholding tax codes that you maintain in the Maintain Withholding Tax Codes (FICODIANV_WHLDG) customizing activity. You can find this configuration in SAP Customizing Implementation Guide > Financial Accounting > General Ledger Accounting > Periodic Processing > Report > Statutory Reporting: Colombia > Magnetic Media (DIAN) > Maintain Withholding Tax Codes (FICODIANV_WHLDG).
In the view, you need to enter the item types, the country code, the withholding type for base amounts, the withholding tax codes and their validities.
With this configuration, the 1003 report format extracts the taxes and base amounts used in your customer invoices and separated them into the correct item type. The other configurations relevant for the report are pre-filled with the Colombia DIAN BC Set (FICODIAN_BCSET) business configuration set. (https://help.sap.com/viewer/afaad59f2f68479aa87fc13aae85c231/1909.002/en-US/8962fe288948479b8387cd11...).
And we are done! Now you can proceed to running your report.
This is the step by step execution on how to do that as well:
1 – In the SAP Fiori Launchpad, choose the Run Compliance Reports app.
3 – Choose New Run.
4 – Enter the required parameters and choose Run.
5 – Select the generated file, and choose Download.
6 – Done! Your XML output file is ready for you to send it to DIAN! (Example of XML output file for the 1003 report format).
We hope this blog post is useful for you. Now you know the details of the 1003 report format and can stay compliant with the legal requirements of DIAN!
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,
Mariana
#AdvancedComplianceReporting
This post was also translated from English into Spanish using the SAP Translation Portal. Check it out!
Today you’ll learn more about the 1003 report format for magnetic media reporting in Colombia.
As usual, if you have missed our previous posts, you can find them here:
- Magnetic Media Compliance Reports: Address Determination for Minimum Amount Registers
- Magnetic Media Compliance Reports: City Codes in Master Data
- Magnetic Media Compliance Reports: The 1009 Report Format
The 1003 Report Format
How can you use the 1003 report format?
You use the 1003 report format to report the withholding tax amounts that were charged by your customers.
Find below the information you report in the XML output file of the 1003 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 – Note, if you have this data, report it. |
| Apl1 | Third-party first surname | String | 60 | This data is mandatory for natural persons. |
| Apl2 | Third-party second surname | String | 60 | This data is mandatory for natural persons if you have it. |
| Nom1 | Third-party first name | String | 60 | This data is mandatory for natural persons. |
| Nom2 | Third-party other names | String | 60 | This data is mandatory for natural persons if you have it. |
| Raz | Third-party 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. |
| Mcpo | Municipal code | Int | 3 | DANE – numeric code, include zeros to the left hand-side. This data is mandatory if the residency country is Colombia. |
| Valor | Accumulated value of payment or credit subject to withholding at source | Double | 20 | This data must be a positive and whole number. Do not include periods or commas. This data must be always reported. |
| Ret | Withholding at source | 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 Magnetic Media report formats in DIAN portal: https://www.dian.gov.co.
How to configure the 1003 report format
Before you run the 1003 report format, you need to configure data sources for extraction, which for the 1003 report format are the withholding tax codes that you maintain in the Maintain Withholding Tax Codes (FICODIANV_WHLDG) customizing activity. You can find this configuration in SAP Customizing Implementation Guide > Financial Accounting > General Ledger Accounting > Periodic Processing > Report > Statutory Reporting: Colombia > Magnetic Media (DIAN) > Maintain Withholding Tax Codes (FICODIANV_WHLDG).
In the view, you need to enter the item types, the country code, the withholding type for base amounts, the withholding tax codes and their validities.
With this configuration, the 1003 report format extracts the taxes and base amounts used in your customer invoices and separated them into the correct item type. The other configurations relevant for the report are pre-filled with the Colombia DIAN BC Set (FICODIAN_BCSET) business configuration set. (https://help.sap.com/viewer/afaad59f2f68479aa87fc13aae85c231/1909.002/en-US/8962fe288948479b8387cd11...).
And we are done! Now you can proceed to running your report.
This is the step by step execution on how to do that as well:
1 – In the SAP Fiori Launchpad, choose the Run Compliance Reports app.
3 – Choose New Run.
4 – Enter the required parameters and choose Run.
5 – Select the generated file, and choose Download.
6 – Done! Your XML output file is ready for you to send it to DIAN! (Example of XML output file for the 1003 report format).
We hope this blog post is useful for you. Now you know the details of the 1003 report format and can stay compliant with the legal requirements of DIAN!
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,
Mariana
#AdvancedComplianceReporting
This post was also translated from English into Spanish using the SAP Translation Portal. Check it out!
