Thursday, 15 October 2020 18:53

Magnetic Media Compliance Reports: The 1003 Report Format

Written by Mariana Alves
Rate this item
(0 votes)
“© 2020. SAP SE or an SAP affiliate company. All rights reserved.” “Used with permission of SAP SE”

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:

AttributeTitleTypeLengthCriteria
CptItem typeInt4According to DIAN’s resolution. This data must be always reported.
TdocDocument typeInt2According to DIAN’s resolution. This data must be always reported.
NidIdentification numberString20

Fill this data without hyphens, periods, commas or blank spaces.

This data must be always reported.

DvVerification digitInt1Report this data for type 31 documents – Note, if you have this data, report it.
Apl1Third-party first surnameString60This data is mandatory for natural persons.
Apl2Third-party second surnameString60This data is mandatory for natural persons if you have it.
Nom1Third-party first nameString60This data is mandatory for natural persons.
Nom2Third-party other namesString60This data is mandatory for natural persons if you have it.
RazThird-party social reasonString450This data is mandatory for legal persons.
DirAddressString200This data is mandatory if the residency country is Colombia.
DptoDepartment codeInt2

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

This data is mandatory if the residency country is Colombia.

McpoMunicipal codeInt3

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

This data is mandatory if the residency country is Colombia.

ValorAccumulated value of payment or credit subject to withholding at sourceDouble20

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

This data must be always reported.

RetWithholding at sourceDouble20

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!

Read 32 times

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.