Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
aleshane_ghisleri
Product and Topic Expert
Product and Topic Expert
946

Hello everyone,


According with the new regulation, companies in Colombia are required to adapt to the changes detailed in resolution 000165 and technical annex version 1.9. In this blog post, we will cover the following topics available for SAP S/4HANA and SAP ERP:

  • Rounding removal
  • Healthy taxes
  • Foreign currency in export invoices
  • Emission and signing date of electronic documents
  • Period of time for credit and debit notes
  • CUFE algorithm

 

Rounding removal
The system does not send the <RoundingAmount> tag in the XML file for invoices anymore as rounding for values related with taxes is disabled. This means the following validations rules from DIAN are eliminated: FAS18, FAX18, CAS18, CAX18, DAS18, DAX18.

 
Healthy taxes
The system allows you to display information of the taxes for ultra-processed edible goods, liquor consumption, ultra-processed sugary drinks, and plastic products. To do so, you create a new condition type or tax code related to the tax and add this to the Define Fix Values (/AIF/V_FFIX) Customizing activity. See the steps on the post implementation instructions of SAP Note 3420596.

The system automatically calculates taxes for ultra-processed edible goods. For liquor consumption, ultra-processed sugary drinks, and plastic products, you implement the BAdI: Enhancements for eDocument (EDOC_ADAPTOR). 


Foreign currency in export invoices
Electronic documents for export invoices must be reported in Colombian pesos. If you want to use the PDF generated by the system in a foreign currency, you inform the <Interoperability> tag group of the UBLExtension and calculate the values. This tag group is optional and does not have validation rules in the system.

With the new tags, you can implement the BAdI: Enhancements for eDocument (EDOC_ADAPTOR). Check the attachments section of SAP Note 3426328 for an implementation example.

Be aware that when you convert the currency in the BAdI, you must also recalculate the CUFE.


Emission and signing date of electronic documents
The emission date of the electronic documents must be equal to the signing date of these electronic documents. To support different time zones, we added a new parameter in the CPI where the system converts an alternative time zone to the Colombian one, avoiding the documents to be signed in different times.

To avoid this inconsistency, update your Cloud Platform Integration (CPI) to version 2.0.13.

 

Period of time for credit and debit notes
[Updated on May 20, 2024]
You can use the following XML tags from the BAdI: Enhancements for eDocument (EDOC_ADAPTOR) to inform the period of time you want to report credit or debit notes:

  • /CreditNote/cac:lnvoicePeriod/cbc:StartDate
  • /CreditNote/cac:lnvoicePeriod/cbc:EndDate
  • /CreditNote/cac:lnvoicePeriod/cbc:StartTime
  • /CreditNote/cac:lnvoicePeriod/cbc:EndTime
  • /DebitNote/cac:lnvoicePeriod/cbc:StartDate
  • /DebitNote/cac:lnvoicePeriod/cbc:EndDate
  • /DebitNote/cac:lnvoicePeriod/cbc:StartTime
  • /DebitNote/cac:lnvoicePeriod/cbc:EndTime

 

CUFE algorithm
When you submit a credit or debit note, the @schemeName attribute of the <UUID> tag in the XML file must be filled in. You can implement the BAdI: Enhancements for eDocument (EDOC_ADAPTOR) with the respective CUFE algorithm.

 

SAP Notes relevant to this legal requirement
You can implement the following SAP Notes to update your solution:

  • SAP Note 3420596 - Technical annex 1.9 for Colombia: Rounding removal and healthy taxes
  • SAP Note 3426328 - Technical annex 1.9 for Colombia: Foreign currency proxy changes
  • SAP Note 3459015 - Technical annex 1.9 for Colombia: Foreign currency proxy changes - Part 2  

 

Did you like this post? Give it kudos and share the content with your colleagues, and feel free to leave a feedback, comment or question in the space below.

 
Regards,
Aleshane Ghisleri
#SAPGoGlobal #SAPLocalization

4 Comments
daniel_lopez3
Explorer

Hello @aleshane_ghisleri,

Is there a way you can share XML structure generated by SAP for an invoice in foreign currency (ex. USD) for Colombia?

Im struggling with XML creation to be approved by DIAN. 

My current issue is in attached screen.

All these notes are already implemented in our ECC system.

  • SAP Note 3420596 - Technical annex 1.9 for Colombia: Rounding removal and healthy taxes
  • SAP Note 3426328 - Technical annex 1.9 for Colombia: Foreign currency proxy changes
  • SAP Note 3459015 - Technical annex 1.9 for Colombia: Foreign currency proxy changes - Part 2image.png#colombia #annexversion1.9
shiv81
Explorer
0 Kudos

@aleshane_ghisleri,

We have the same issue - "Incorrect CUFE value" when the document currency is in USD (non-COP). All the mentioned notes for Annex 1.9 has been implemented and EDOC_ADAPTOR has been used to populate the COP values in the XML. All updates to CUFE via ZCL_EDOC_ADAPTOR has been unsuccessful, resulting in rejection from DIAN. Any help to resolve this is highly appreciated.

Regards,

Shiv

dkarma
Discoverer

We also have the problem with CUFE not being correct - because the amounts used in the CUFE calculation are the USD amounts from the SD invoice - whereas the amounts we report in XML has been converted into COP after the code adjustments we have done to convert from USD to COP in XML.

I have a really hard time understanding why we as customers have to do a lot of extra ABAP code because SAP standard do not support foreign currency handling in Colombia. When we decided to use DRC we expected that SAP would support us with a solution that at least live up to the legal requirements described by DIAN. Instead each customer now have to solve the challenges of fixing currency conversions to live up to DIAN's requirements.

Arne Maagaard

dkarma
Discoverer
0 Kudos

Adjusting CUFE is possible - but this has to be done in Class: CL_EDOC_MAP_CO_SD_UBL_21 in Method FILL_CUFE. We have earlier done a modification to handle the free of charge samples - where we still have to pay tax. We plan to adjust the amounts from USD to COP in this method.