Sorun Cevaplayalım

İşinizle ilgili öngörüler edinin, gerçek zamanlı bilgilere göre karar alın.

SAP Eğitim ve Sertifika Dönemleri

Uzmanlığınızı ve deneyiminizi SAP çözümleri kullanarak tasdik edin.

Çözüm Ekibi Başvurusu

Kullanıcılara hızlı ve pratik çözümler üreterek görev almak isteyenler.

SAP BLOG Magnetic Media Compliance Reports: The 1008 Report Format

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
678
Tepki puanı
7
Puanları
6
¿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
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 – Nit, if you have this data, report it.
Apl1Debtor’s first nameString60This data is mandatory for natural persons.
Apl2Debtor’s second nameString60This data is mandatory for natural persons if you have it.
Nom1Debtor’s first nameString60This data is mandatory for natural persons.
Nom2Debtor’s other namesString60This data is mandatory for natural persons if you have it.
RazDebtor’s 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.
MunMunicipal codeInt3
DANE – numeric code, include zeros to the left hand-side.

This data is mandatory if the residency country is Colombia.
PaisResidency or domiciliary countryInt4According to DIAN’s resolution. This data must be always reported.
SalDebtor’s payable balance in December 31thDouble20
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 (SAP Help Portal) 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



Okumaya devam et...
 
Üst