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;
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 batch
Generate dispatch batches or remove bills.
- Query Batch
View all information from the bills submitted and their occurrences.
- Export Batch
Generate a text file for submission or withdrawal of bills in the batch.
- Return File
Import the return file from Serasa to update the bills statuses on Protheus.
- Bill withdrawal
- FINA771 - Manual Withdrawal of bills on Protheus where they have been directly withdrawn on the Serasa website. For further information, check: FINA771 Serasa - Manual Withdrawal / Protheus 12 / Financial / Accounts Receivable.
- FINA770 - Automatic withdrawal of bills if they present the following statuses:
- Added;
- Negotiated;
- Received;
- Delete batch
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:
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.
- 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.
- 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.
- Add a bill by entering the mandatory fields:
Access the Financials Module (SIGAFIN) > Updates > Accounts Receivable > Accounts Receivable (FINA040).
Click Add.
Fill out the required fields and click Save.
04. EXAMPLE OF USE
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.
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.
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.
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:
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.
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.
To perform a manual withdrawal, check: FINA771 Serasa - Manual Withdrawal / Protheus 12 / Financial / Accounts Receivable.
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 |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas