DDA – Brazilian Automatic Direct Debit – Improving Vendor Payment Reconciliation
Introduction
The Brazilian DDA replace the old Boleto which is a Bill of Exchange with a 44/47 bar-code digits that the payer can easily perform the payment thru an ATM , Bank Web Site or Bank File Exchange.
Basically DDA is an Electronic Boleto also containing the 44/47 bar code digits as reference for payment.
Previously, the AP open item should be updated by the user, usually using a Bar-code Scanner, with the Bar Code Digits at FB02, screen field RF05L-BRCDE.
Now with DDA replacing the old Boleto, SAP delivered some solutions to have this bar code updated automatically when processing the bank file thru J_1BBR20 and J_1BBR30 programs. SAP also delivers DDA_BR functionality for post processing in case that the automatically identification didn´t happens for some reason.
Business Process for DDA
The vendor will send to the bank a file with the information for DDA creation which send to CIP (Câmara Interbancária de Pagamentos), CIP will process the Vendor request and forward to the House Bank that can be download by the company or receive the file for processing thru a VAN service.
Vendor -> Bank <-> CIP <-> House Bank <-> Company
The company will process and update the open items with the DDA bar-code and process the F110 DME payment file and send to the House Bank which send back to CIP that process the payment of that DDA and communicate the Vendor Bank.
The Challenge
The information such as CNPJ, Due Date, Amount and Reference Field will be used by SAP system to determine the AP open item for bar-code update.
The reference field in Brazil is used to record the Nota Fiscal number (Invoice Number) usually with the following Mask: 999999999-999 – Nine numeric digits as the NF number and three numeric digits called Serie.
The vendor can send the NF number with many possibilities such as:
* 123-1
* 123/1
* 1231
* 000000123-1
Usually SAP create the open item with the following way: 000000123-1 (Leading zeros the NF number, pipe and then the serie)
It is really difficult to match the vendor reference with the SAP reference field and usually the DDAs will be sent to DDA_BR for post processing. Unfortunately, this transaction code is not open to update the reference number with the expected one (REFERENCE_NO) and also the payable accountant usually do not agree to update his/her open item with the vendor reference.
Workaround Solution
The workaround solution that we applied for our business is to open the reference number, so the payable accountant can input the reference according to his open item.
We did that using enhancements on programs “RFFOBR_DDA, RFFOBR_DDA_O00”. The enhancement point is RFFOBR_DDA_POINT that can be used on the information treatment.
Follow bellow some technical inputs and ABAP source code to help you to perform the same to open the Reference Field in DDA_BR transaction without need to copy the program to a Z program:
Enhancement to apply the ALR user input data before Post Processing function:
Great Document!!!
I implemented Brazil Boleto back in 2008 but now everything has changed with electronic DDA. My client just asked for the implementation of this new process for Brazil entity.
Thanks Dammah...
Hi Gabriel,
Is it typical for Brazil banks not to provide sample test files for the new DDA process? File layout? Bradesco bank says not possible but feel does not want to provide sample file to test until production and this is weird. I cannot find any sample test file creation program similar to RFEBKAT0-9 for MultiCash/BAI/IDOCs. Thanks
Dear Dammah,
Yes, it´s not possible to have test file data because Brazilian banks usually don´t have a test environment system.
Ask your customer to contact the bank to activate the DDA service inside the bank and when the customer receive some Boleto thru DDA you can test this file.
This was how we did.
Best regards,
Gabriel Coleti
Ok, great. thank you
Hi Gabriel,
Ok so Bradesco sent sample DDA file but this file is not accepted by SAP. FF.5 throws an error that file format not valid. I and a colleague compared the file with the file specifications provided by Brasdesco. We found about 90% of records as per specification but notice it did not have file trailer and few other items. Still debugging but can't get anywhere and I have never seen an actual DDA file so not sure why FF.5 says file not valid format.
Do you have any pointers? Thanks
Hello
Could you tell me If you have the solution about the CNPJ 8 digits insted of complete digit fron the file BankĀ DDA to link the invoice
Thanks