01. OVERVIEW
The Serasa - Processes routine (FINA770) allows the integration of the Protheus bills database with the PEFIN service from Serasa Experian.
The process involves the following steps:
- Generation of the bill batch;
- Generation of the bill batch dispatch file;
- Reading and processing data from the Serasa return file;
- Saving the file processing log;
Nota |
---|
title | Dispatch and receipt layouts |
---|
|
The Protheus + Serasa integration is through the dispatch and return files. To generate these files, layouts must be configured using MILE (Model Integrator Layout Engine). For more information, check SERASA - Dispatch and return layouts using MILE. |
02. OPERATIONS
Generate dispatch batches or removing bills.
View all information from the bills submitted and their occurrences.
Generate a text file for submission or withdrawal of bills in the batch.
Import the return file from Serasa to update the bills statuses on Protheus.
Mark the records from the batch as deleted.
03. PRECONDITIONS FOR USING THE ROUTINE
Below, we present the registrations needed for creating bills in the database:
Totvs custom tabs box |
---|
tabs | 1.Configure MILE layouts,Register a customer,3.Register a nature,4.Add a bill |
---|
ids | layout_mile,cad_cliente,cad_natureza,cad_tit |
---|
|
Totvs custom tabs box items |
---|
default | yes |
---|
referencia | layout_mile |
---|
| If you do not have the files referring to the Serasa process ( serasa_layout_envio.xml and serasa_layout_retorno.xml), access the Customer Portal and download them. After the download, follow the configuration instructions below: To configure the MILE layouts, check SERASA - Dispatch and return layouts using MILE. If you have already imported the files, delete and re-import them. The layouts were updated. |
Totvs custom tabs box items |
---|
default | no |
---|
referencia | cad_cliente |
---|
| - Register a customer by entering the mandatory fields:
Access the Financial Module (SIGAFIN) > Updates > Records > Customers (MATA030). Click Add.
Fill out the required fields and click Save.
|
Totvs custom tabs box items |
---|
default | no |
---|
referencia | cad_natureza |
---|
| - Register a nature by entering the mandatory fields:
Access the Financial Module (SIGAFIN) > Updates > Records > Natures (MATA030). Click Add.
Fill out the required fields and click Confirm.
|
Totvs custom tabs box items |
---|
default | no |
---|
referencia | cad_tit |
---|
|
Fill out the required fields and click Save.
|
|
04. EXAMPLE OF USE
Totvs custom tabs box |
---|
tabs | 1.Adding a batch,2.Batch query,3. Export batch,4.Return File,5.Automatic withdrawal,6.Manual Withdrawal,7.Serasa transaction history report |
---|
ids | cad_lote,consulta_lote,exp_lote,arq_ret,ret_aut,ret_manual,relatorio |
---|
|
Totvs custom tabs box items |
---|
default | yes |
---|
referencia | cad_lote |
---|
| Access the Financials Module (SIGAFIN) > Updates > Accounts Receivable > Serasa - Processes (FINA770) and click Generate batch.
Enter the questions for selection and, in the Information tab, click Run.
Informações |
---|
title | Resend bills to Serasa |
---|
| To resend bills that were previously returned with an error, in the 'Record Type?' question, select '2-Error'. |
Select the bills and click Confirm.
At the end of the process, the batch will be generated.
|
Totvs custom tabs box items |
---|
default | no |
---|
referencia | consulta_lote |
---|
| Access the Serasa - Processes routine (FINA770) and select the batch you wish to view. Then, click Query.
The routine will display information on the batch and the bills added to it.
|
Totvs custom tabs box items |
---|
default | no |
---|
referencia | exp_lote |
---|
| Access the Serasa - Processes routine (FINA770) and click the batch you want to export.
Click Other Actions > Export Batch.
The routine will create a file according to the MILE configurations to be sent to Serasa. Example of the file:
|
Totvs custom tabs box items |
---|
default | no |
---|
referencia | arq_ret |
---|
| Access the Serasa - Processes routine (FINA770) and click Other Actions > Return File. Select the Serasa return file to be imported and click OK.
Check the batch to view the status of each bill. |
Totvs custom tabs box items |
---|
default | no |
---|
referencia | ret_aut |
---|
| Access the Serasa - Processes routine (FINA770) and click Generate batch.
In Processing on the 'Process Type?' field, select option 2-Withdrawal. And, on 'Record type?', select '1-Regular'.
A list is displayed with all bills to be selected;
Click Confirm. |
Totvs custom tabs box items |
---|
default | no |
---|
referencia | relatorio |
---|
| Select the Financials Module > Reports > Accounts Receivable > Serasa Transaction History (FINR775) and enter the parameters
Click Ok
|
|
05. MAIN FIELDS AND PARAMETERS
Fields | Description |
---|
FW8_FILIAL | System Branch |
FW8_LOTE | Serasa Batch Code |
FW8_DTLOTE | Batch Generation Date |
FW8_DTARQ | File Generation Date |
FW8_DTPROC | Process. Date File |
FW8_TIPO | Serasa Batch Type |
FW8_ARQSER | Serasa File Code |
Parameters | Description |
---|
MV_ARQSERA | Code of the last information file sent to Serasa. |
MV_SERENV | The folder path where the Serasa dispatch file will be generated. |
MV_SERRET | The folder where the Serasa return files will be stored. |
06. TABLES USED
Name | Description |
---|
FWA | Serasa Bill Status |
FWB | Serasa Bill Transactions |
FW8 | Header of Serasa Batches |
FW9 | Serasa Batch Details |
SE1 | Accounts Receivable |
HTML |
---|
<!-- esconder o menu -->
<style>
div.theme-default .ia-splitter #main {
margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
display: none;
}
#main {
padding-left: 10px;
padding-right: 10px;
overflow-x: hidden;
}
.aui-header-primary .aui-nav, .aui-page-panel {
margin-left: 0px !important;
}
.aui-header-primary .aui-nav {
margin-left: 0px !important;
}
</style>
|