Processing a CNAB 400 Return File (Brazilian Hub SuiteApp)

After you submit a delivery file to the bank, the banking institution sends you a return file. This file contains the bank response to the requests contained in the delivery file. You need to process the return file in NetSuite to update your transactions and payment statuses.

To process a CNAB 400 return file:

Go to BRHub > Arquivos Bancários > Processamento Arquivo Retorno > New.
In the Banco field, select the bank.
In the Arquivo field, select or upload the return file you received from the bank.

If you have already uploaded the return file to your file cabinet, select it. If you have not, you can upload it directly from the processamento arquivo retorno record.

To upload the return file:
1. Hover over the Arquivo field.
2. Click the plus icon .
  
  The File window opens.
3. In the Attach from field, select Computer to attach a file from your local storage, or Web to attach a file by linking to it on the internet.
4. In the File Name field, enter a name for the file.
5. In the Folder field, select the file cabinet folder to which to save the file.
6. If you are attaching a file from the web, in the URL field, enter the URL to the file.
7. If you are attaching a file from your computer, in the Select File field, click Browse and find the file you want to upload to NetSuite.
8. In the Character Encoding field, select the proper character encoding for the file.
9. Click Save.
Note:
Make sure the uploaded file is a TXT file. This is the only file format allowed.
In the Layout CNAB field, select the layout CNAB record that NetSuite should use to process this file.
Click Save.

The system updates and saves the record. Refresh the page until the Status field shows that the file status is Processado.

If the Status field displays the Processado com Críticas or the Não Processado statuses, you must check the processing log to verify the issues with the processing.

Verifying the Return File Processing Log

See the following steps to learn how to verify the processing log of a return file.

To verify the return file processing log:

Go to BRHub > Arquivos Bancários > Processamento Arquivo Retorno.
Find the record that you want and open it in view mode.
If the Status field shows the Não Processado status, do the following:
1. Click the Log Execução subtab.
2. In the Mensagem de Execução field, review the error message.
3. In the Arquivo de Erros field, click Download to download a CSV file listing all the errors.
If the Status field shows the Processado com Críticas status, do the following:
1. Click the Log Arquivo subtab.
2. In the Erro list, select Yes.
  
  This filters only the error log entries.
3. In the Mensagem column, verify the reason for the each error log entry.
4. Click the Log Execução subtab.
5. In the Mensagem de Execução field, review the error message.
6. In the Arquivo de Erros field, click Download to download a CSV file listing all the errors.

Review the error entries and solve them. After you solve the issues, try processing the return file again.

To process a CNAB 400 return file:

Verifying the Return File Processing Log

To verify the return file processing log:

Related Topics