Skip to Content
Product Information

Magnetic Media Compliance Reports: The 1003 Report Format

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:

 

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/8962fe288948479b8387cd11c1fa77e1.html).

 

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.

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

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!

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