01. OVERVIEW
Instant Payments (PIX) are the electronic monetary transfers in which the payment order transmission and the funds' availability to the receiving user happen in real-time. This service is available 24 hours a day, 7 days a week, and during the entire year.
The transfers occur directly from the payer user to the receiving user, without the need for mediators and with lower transaction costs.
PIX can be transferred using APIsonline, and some banks are also making PIX communication available via the CNAB template.
This project will be released in waves, and the first wave was released by the Financial continuous expedition on 11/09/2020, with processes for using CNAB Payable (240 positions).
The CNAB Receivable (750 positions), released in the second wave by the Financial continuous expedition on 01/15/2021.The process is ready to work with the Dynamic QR Code template.
CNABs validated with our customers will be made available on CNAB Cloud (Payable) and TDN (Receivable), but the system can be used in any bank. You only need to set up CNAB according to the bank manual.
02. RECORDS
Expandir |
---|
|
We have two new payment templates to use in the Accounts Payable Bordereau routine: - 45 - PIX - Transfer
- 47 - PIX - QR Code
After the system is updated with the dictionary package, they will be available at in table 58 - Payment method - SISPAG, at the Configurator. |
Expandir |
---|
|
To account for the PIX collection process, we created two standardized entries (LPs). Below are their setup details: 54G - Accounts Receivable - Portfolio transfer to PIX Field | Content | Note |
---|
Currency Val 1 | Vl | FWI->FWI_VALOR | As a second option, fields from table F71 can also be used (F71->F71_VALOR to get the bill's original value, or F71->F71_VLRPIX to get the collection value) Table SE1 will also be available for accounting for other values existing in the bill, such as taxes, | increase decrease
54H - Accounts Receivable - PIX transfer to portfolio Field | Content | Note |
---|
Currency Val 1 | Vl | FWI->FWI_VALOR | The same information from the note in LP 54G |
Both LPs are triggered: - In the online accounting using the PIX Monitor (FINA890) routine:
- 54G - In the Generate CNAB option that generates the CNAB remittance files for PIX collection. This operation is the an accounting fact.
- 54H - In the Generate CNAB option, when there are bills in the status Cancellation Requested (caption
Image Added) that will be considered in the 4th screen of the wizard for sending the cancellation request to the bank. - Note: For the online accounting to happen, the "Account online?" question must be set to "Yes" (F12 parameters from the PIX Monitor routine).
- More details about this routine are on throughout this page.
- In offline accounting using the Multi-Thread Offline Accounting routine (CTBAFIN).
Remember that journal entries related to PIX must be considered on in working days, regardless of whether they are being performed on weekends and holidays. |
...
Expandir |
---|
|
In the bank registration, the new ISPB field is the Brazilian Payment System Identifier that is needed for submission in CNAB Receivable. This link presents an updated list: https://www.bcb.gov.br/pom/spb/estatistica/port/ASTR003.pdf The bank registration also has a new screen for listing PIX Keys linked to each bank/branch/account record. In Other Actions within the bank record, the new PIX Keys option allows you to link up to 20 PIX keys per account, but only one key can be active. The PIX keys cannot be used by another bank, since Bacen's DICT assures this integrity to the financial system. The system allows the following key types: e-mail, mobile phone number, EIN, and random. This new table that stores the banks' PIX keys (table F70) must have the same sharing of as the environment's banks table (table SA6).
To use the integration with Banco do Brasil, it is necessary to inform the register of the official bank (A6_BCOOFI) "001", which is the identifier code of Banco do Brasil. |
Expandir |
---|
|
The suppliers' suppliers’ registration has a new screen for listing the PIX keys linked to the supplier record. In Other Actions within the Suppliers record, the new PIX Keys option allows you to link PIX Keys to the supplier. Only one key can be active per at a time. The PIX keys cannot be used in another supplier, since Bacen's DICT assures this integrity in the financial system. The system allows the following key types: e-mail, mobile phone number, EIN/SSN, and random. This new table that stores the suppliers' PIX keys (table F72) must have the same sharing of as the environment's suppliers table (table SA2). For PIX transfers (template 45) missing the supplier's PIX data, the Bank, Branch Cd, Checking Acct, and Sup. Acct. Tp fields must be entered for a successful transfer. |
...
Expandir |
---|
|
In the Collection Status record, a new question, "PIX Status", was created to identify that bills in this collection status are from the PIX Payment Method. The system only allows one collection status with this characteristic (PIX Status = Yes). In a new installation, this situation has the K code. For existing installations, the next one available will be created with this feature. |
03. ACCOUNTS ACCOUNTS RECEIVABLE
With the PIX solution, the system allows a bill to be sent to Bank A through the bordereau, and that another PIX to be is eventually generated in another bank.
The entire concept and existing tables for the bordereau were maintained, and PIX is controlled in a new entity.
...
For PIX, there is also a strong key called TRANSACTION ID (TXID) in the PIX manuals. In the system, this key is stored in the PIX Monitor table (F71), in the F71_IDTRAN field.
...
Expandir |
---|
title | CNAB Remittance Layout Template 1 |
---|
|
This routine did not need adjustments because it natively allows the configuration of the new layout blocks for the main banks.
Dica |
---|
| The following new functions are available for use in the CNAB Remittance Layout Template 1: - CNABDJUR()
- If the bill has an interest, the function returns the actual due date of the bill that will be considered for adding interest to the original value (e.g.: 20210120). Otherwise, content "00000000" is returned.
- CNABDMULT()
- If the bill has a fine, the function returns the bill's actual due date that which will be considered for adding the fine to the original value. Otherwise, content "00000000" is returned.
- CNABDDESC()
- If the bill has a discount, the function returns the bill's actual due date that which will be considered for applying the discount to the original value. Otherwise, content "00000000" is returned.
|
|
...
Expandir |
---|
|
In the complement for bills in the Accounts Receivable record, a new tab called PIX was created, with a new field (Generate PIX) to store the information on whether the bill can be received by PIX or not. By setting this field to Yes, the PIX process is started, generating the information in the PIX Monitor. If it is set to No, the respective PIX is canceled. This field is not enabled for RA (Advance Receipt) bill types, since the receipt process is done. For bills from customers in which the Generate PIX field is set to 1 or 2, in the customer complementcompliment, the Generate PIX field of the bill complement starts automatically with Yes when these bills are generated.
|
Expandir |
---|
|
This routine now handles the new layouts for 750 positions of the PIX bills receivable through the new "PIX Template" option in the "CNAB Configuration" question that used to have only options "Template 1" and "Template 2". Since the PIX operation now allows a bill to be in bordereau and PIX simultaneously, this routine now automatically cancels a flow when the other one is finished. Example: - Flow 1: The bill was put in bordereau and sent to Bank A
- Flow 2: A PIX for the same bill was issued to Bank B
- Therefore, if the bordereau is paid in Bank A (Flow 1) , when this post is processed, the routine automatically triggers the PIX Cancellation Request process in Bank B (Flow 2).
- Or, if the PIX is paid in Bank B (Flow 2) , when this post is processed, the routine automatically creates the bill cancelation instruction in Bank A's bordereau (Flow 1) for later submission to the bank using the Collection Instruction routine (FINA151).
|
Expandir |
---|
|
The PIX Wizard (FINA893) is the routine responsible for validating connection credentials with TOTVS Instant Pay and/or Banco do Brasil. Configuration of monitoring scheduling, QR Code generation, and PIX processing. For further information about the routine, refer to PIX Wizard After configuring this routine, it is possible to send and receive the data online through schedules FINA892 and FINA892A. For more information, visit - Job for sending and returning records in PIX billing status. |
Expandir |
---|
|
This new routine is responsible for the complete control of bills that can be paid using the PIX payment method. It must be added to the Updates, Bank Commun. menu. Its code is FINA890. All bills generated by Financials or Billing that have the Generate PIX field set to Yes are automatically listed in the PIX Monitor (F71). This new table that This new routine is responsible for the complete control of bills that can be paid using the PIX payment method. It must be added to the Updates, Bank Commun. menu. Its code is FINA890. All bills generated by Financials or Billing that have the Generate PIX field set to Yes are automatically listed in the PIX Monitor. This new table that stores the PIX bills information (table F71) must have the same sharing of the bills receivable table (table SE1) in the environment.
Caption for bills in the PIX Monitor routine:
Image Removed 1 Image Added-
| CNAB to Generate To generate CNAB / Waiting for Integration | This is the first step for a PIX bill. | It indicates the bill it is available to be sent to the financial institution for registration | using through the Generate option | that builds , where we will have the assembly of the CNAB file | . Image Removed 2 - CNAB Generated | This is the bill status after the CNAB file is generated. | Image Removed 3 - QR Code Generated
| When processing the CNAB return, after the record is confirmed by the bank, we receive the QR Code that will represent the bill in the PIX system and can make this information available to the customer. | Image Removed 4 - Customer Notified | With the QR Code information available, after the report (Print PIX) is generated with the respective QR Codes, the bill moves to this status. | Image Removed 5 - Receipt Confirmed
| After a new CNAB return processing, now with the confirmation of the receipt by the customer, the bill moves to this last status that indicates the receipt and posting of the respective bill. | Image Removed 6 - Cancellation Requested
| When it is necessary to cancel a bill from the PIX system, the bill moves to this status that indicates that it needs to be sent to the bank. Whenever the generation routine is sent, it automatically checks if there is any | and, if it is the Online PIX, the status means that the bill was created but has not yet been integrated with the bank. | Image Added- Waiting for Cancelation (Integration)
| Bills that were sent to the bank online and, for some reason, have undergone changes in value and date or have been posted, for example, but that the system has not yet received confirmation of cancelation of the charge. | Image Added- Waiting for bank return of issue.
| This is the status for when the bill submission was made, but the return of "confirmed entry" has not yet occurred. | Image Added- Change requested
| When it is necessary to edit a bill in the PIX system, the bill moves to this status which indicates that it needs to be sent to the bank to perform the change requested. Whenever the generation routine is sent, it automatically checks if there is any bill in this status. | Image Added- Canceled
| When processing the return, with the confirmation from the bank that the PIX was canceled, this information is made available using this status. | Image Added- Cancelation sent to the bank (CNAB)
|
Image Removed 7 - Cancellation sent to the bank | Request to be sent and puts this request in the generated CNAB file. |
Image Removed 8 Image Added-
| CanceledWhen processing the CNAB return, with the confirmation from the bank in which the PIX was canceled, this information is made available using this status. | Options available in the monitor: Expandir |
---|
| This option allows the building of the CNAB PIX files for submission to the respective bank. The routine analyzes the banks configured with a main PIX key and Bank Parameters and, using a wizard, guides the user to select the bills liable for PIX registration request in each selected bank. In the same operation, the system also puts, in the same CNAB file, the PIX cancellation requests for the respective bank. These cancellation requests are made using various system points when, for example, a bill balance is edited. The wizard has the following characteristics: - It has the same initial validations and is not run without them
- It checks whether there are bills with status CNAB to generate or Cancellation Requested.
- If there are banks with PIX keys configured as main.
- If the bank parameter registration is configured to the banks identified above. The bank parameter in question must have the field No. Bytes = 750 to indicate that it is PIX.
- First Screen - Routine Presentation
- This presents the routine functionalities
- Second Screen - Bank Selection
- This presents the configured banks with a PIX key and that are parameterized for the user's selection since they can generate PIX. Various banks can be selected at the same time.
- At this point, the user can change the type and the PIX key that each bank has in their records for use in this PIX file generation.
- The Configuration File column can be edited by the user if needed and is automatically filled in if the system identifies, in the environment's system folder, the configuration file in the nnn_PIX.RET format, where nnn is the bank code.
- The Output File column can be edited by the user if needed and is automatically filled in with the generation's bank code, year, month, day, hour, and minute plus the extension entered in the bank parameter. This column also uses information from the MV_LOCENV parameter, if entered.
- Third Screen - Bills Selection
- This screen is displayed to all banks selected in the second screen.
- It presents all bills that can be sent to the banks for the PIX registration. For the first bank, we have all the bills with status CNAB to generate. As some are selected to the first bank, they are not available for the second bank anymore, and so successively.
- Fourth Screen - Cancellations
- This screen displays the bills that had the PIX cancellation requested for the banks selected in screen no. 2. These are added automatically to each CNAB file generated from the respective bank.
- Fifth Screen - File Generation
- To each generated file, we present the operation success and the name of the file generated.
|
Expandir |
---|
| This option allows you to check details about the bill in what concerns PIX, such as submission date and time, cancellation date and time, customer and other data relevant to the process. |
Expandir |
---|
| This option allows you to print a report with bill information and the respective QR Codes that can be sent to the customer. This routine only prints bills that were already registered in the PIX system and that already have a QR Code available in the system. This information is available after the CNAB PIX return with the respective confirmation that the bill was successfully added to the PIX system. |
Expandir |
---|
| This option allows you to resend emails to notify customers about the PIX collections, making the QR Code available for payment (same template of the PIX report, "Print PIX" option). This is possible when the PIX is in status "QR Code Generated" (caption Image Removed), i.e., after it is sent to the bank using CNAB remittance and the Entry Confirmed return is received. - Parameters used
- Positioned bill - This defines if the PIX collection e-mail using QR Code will happen only for the bill positioned in the browse. If set to Yes, the other questions will not be considered. If set to No, the other questions must be answered.
- Issuance From/To - This defines the data interval to filter the PIX bills by issue date (the filter considers table F71, not table SE1, but the information is the same).
- Due Date From/To - This defines the data interval to filter the PIX bills by the due date (the filter considers table F71, not table SE1, but the information is the same).
- Customer - This defines the customer to whom the PIX collection e-mail will be sent for the record if the question Positioned Bill is set to No.
- Store - This defines the customer's store to which the PIX collection email will be sent for the record if the question Positioned Bill is set to No.
|
Expandir |
---|
| This option allows you to configure collection letters, messages sent with the collection letters, and QR Code, plus parameterizing the PIX value that will be sent in the remittance file. The screen is divided into 3 grids (rows): - Grid 1 - Collection letter
- Addition Layout Code and Deletion Layout Code - In these fields, you must enter the collection letter template used for sending the newly generated PIX bills and the canceled PIX bills to the customer.
- Grid 2 - Default message
- A field for the customer to enter a message that will be sent to all customers among with the QR Code so that the payer user will know who sent the code.
- Grid 3 - PIX Value parameters
- This configuration determines the calculation method for the PIX Value (F71_VLRPIX) field. This field can be used when generating the remittance file. You just have to use it in the PIX remittance layout for that.
- The PIX Value configuration can consider the increase or decrease balance value, the accessory values (FINA035), and/or the taxes generated in the issuance or that will be generated in the bill posting.
- The FINVLPIX entry point was created in case the customer wants to customize the value to be sent to the bank.
- For more information on this entry point, check the link - Entry Point - FINVLPIX.
|
Expandir |
---|
|
|
The PIX collection cancellation process using the PIX Monitor routine happens according to the bill status in PIX (F71_STATUS).
The chart below explains the cancellation behavior in relation to the bill status in PIX:
Bill status in PIX / Caption | Routine behavior |
Image Removed 1 - CNAB to Generate
| The bill will be canceled (F71_STATUS = 7, and FKF_RECPIX=2). |
Image Removed 2 - CNAB Generated
| Message onscreen explaining that the CNAB was generated and that it is awaiting a return from the bank. |
Image Removed 3 - QR Code Generated
| The bill status becomes Requested to the bank (F71_STATUS = 6, and F71_SOLCAN =1). |
Image Removed 4 - Customer Notified
| The bill status becomes Requested to the bank (F71_STATUS = 6, and F71_SOLCAN =1). |
Image Removed 5 - Receipt Confirmed
| Message onscreen explaining that the payment has been processed. |
Image Removed 6 - Cancellation Requested
| Message onscreen explaining that the cancellation was requested to the bank. |
Image Removed 7 - Cancellation sent to the bank
| Message onscreen explaining that the cancellation was sent to the bank. |
Image Removed 8 - Canceled
| Message onscreen explaining that the bill is canceled. |
04. ACCOUNTS PAYABLE
Expandir |
---|
|
In the bill complement, in the Accounts payable record, at the new PIX tab, a new field stores the information corresponding to the QR Code of that received bill. This field can receive the QR Code content in at least two ways: - QR Code reader connected to the computer
- Using the barcode_scan.exe app provided by TOTVS for this end (click here for more information and download) that must be in the system's SmartClient folder. This app is started using the Other Actions >> Read PIX QR Code option. Using this app, you can navigate through the emails, PDFs, and images where the QR Code that represents the positioned bill's PIX is available, and scan the image. When the scan is successful, the information is sent to the computer's clipboard. Then, select the field in question and use Windows Paste (CTRL + V) to link the information to the bill.
With the information available in the field, when the user leaves the field, the system will interpret the QR Code entered and display some information, such as Beneficiary, Value, Currency, City, Country and Postal Code of the bill, so that the user can check if the QR Code was scanned successfully. The system also allows taxes bills such as the INSS to receive the QR Code information. However, in these cases, the bill complement tab will only enable fields from the CNAB and PIX tabs for filling in. |
Expandir |
---|
|
Using the CNAB Cloud Wizard routine, the layout that serves the CNAB for 240 positions from the main banks in Accounts payable will be provided, easing the configuration of the respective layouts. |
...
title | CNAB Configurator Template 2 |
---|
This routine did not need adjustments because it natively allows the configuration of the new layout block for the main banks.
Dica |
---|
|
The following new functions are available for use in the CNAB Configurator Template 2: - FNRETPIX(nOpcao)
- With parameter 1, the function returns the active PIX Key Type for the selected supplier
- With parameter 2, the function returns the active PIX Key for the selected supplier
- With parameter 3, the function returns whether the transfer (Template 45) is using a checking account or a PIX key (in this case, a key must be configured in the selected supplier)
- FNURLPIX()
- Returns the URL extracted from the QR Code entered in the positioned bill
|
Expandir |
---|
title | Payment Bordereau (FINA240 and FINA241) |
---|
|
These routines now validate the new templates 45 - PIX - Transfer and 47 - PIX - QR Code that can only be used if the bank/branch/bordereau account has an active PIX key in Banks registration > Other actions > PIX keys. - Template 45 - PIX Transfer must be selected for building bordereaux for transferring values to the suppliers. The supplier for these bills must have an active PIX key in the respective supplier PIX Keys record.
- Template 47 - PIX QR Code must be selected for building payment bordereaux for the bills that have a QR Code scanned in the respective bill complement field in the PIX tab.
|
Expandir |
---|
|
This routine did not need adjustments and will be responsible for processing the PIX CNAB return by posting the bills as in a traditional CNAB. |
Aviso |
---|
|
The FINA300 - SISPAG routine available at the Updates/Bank Communication menu was not edited for processing CNAB with the PIX payment method since the process also serves the CNAB 240 positions - Sispag 1 file. |
05. TABLES AND FIELDS USED
AI0 - Customer Complement (Accounts Receivable)
AI0_RECPIX - Generate PIX
AI0_EMAPIX - E-mail PIX
FKF - Bill complement
FKF_RECPIX - Generate PIX - (Accounts Receivable)
FKF_PAGPIX - QR Code - (Accounts Payable)
FRV - Collection Status
PIX Status - (Accounts Receivable)
F70 - PIX Bank Keys (Both Portfolios)
F71 - PIX Monitor (Accounts Receivable)
F72 - PIX Supplier Keys (Accounts Payable)
SA6 - Banks
...
| When it is necessary to cancel a bill from the PIX system, the bill moves to this status which indicates that it needs to be sent to the bank. Whenever the generation routine is sent, it automatically checks if there are any | Image Added- Customer Notified
| With the QR Code information available, after the report (Print PIX) is generated with the respective QR Codes, the bill moves to this status. | Image Added- CNAB Generated
| This is the bill status after the CNAB file is generated. | Image Added- Payment Reversed
| Status of the bill sent and posted that the payment was reversed. | Image Added- QR Code Generated
| When processing the return, after the record is confirmed by the bank, we receive the QR Code information that will represent the bill in the PIX system and can make this information available to the customer. | Image Added- Receipt Confirmed
| After a new return processing, now with the confirmation of the receipt by the customer, the bill moves to this last status that indicates the receipt and posting of the respective bill. | Image Added- Record changed
| When processing the return, with the confirmation from the bank that the PIX was edited, this information is made available using this status. | Image Added- Transacted by CNAB
| In the case of configuration for online transactions in which the records have a CNAB file generated, this message is displayed indicating that the record was transacted with the bank via CNAB. |
|
Options available in the monitor:
Expandir |
---|
|
Using this option, it is possible to select the bills to be sent to the respective bank online and/or via PIX CNAB. The routine analyzes the banks configured with a main PIX key and Bank Parameters and, using a wizard, guides the user to select the bills liable for PIX registration requests in each selected bank. In the same operation, the system also puts, in the same CNAB file, the PIX cancellation requests for the respective bank. These cancellation requests are made using various system points when, for example, a bill balance is edited. The Wizard has the following characteristics: - It has the same initial validations and is not run without them
- It checks whether there are bills with the status CNAB to generate/Waiting for integration or Cancelation Requested.
- If there are banks with PIX keys configured as main.
- If the bank parameter registration is configured to the banks identified above. The bank parameter in question must have the field No. Bytes = 750 to indicate that it is a PIX and/or was configured via the wizard for online transactions.
- First Screen - Routine Presentation
- This presents the routine functionalities
- Second Screen - Bank Selection
- This presents the configured banks with a PIX key that are parameterized for the user's selection since they can generate PIX. Various banks can be selected at the same time.
- At this point, the user can change the type and the PIX key that each bank has in their records for use in this PIX file generation.
- The Configuration File column can be edited by the user if needed and is automatically filled in if the system identifies, in the environment's system folder, the configuration file in the nnn_PIX.RET format, where nnn is the bank code.
- The Output File column can be edited by the user if needed and is automatically filled in with the generation's bank code, year, month, day, hour, and minute plus the extension entered in the bank parameter. This column also uses information from the MV_LOCENV parameter, if entered.
- Third Screen - Bills Selection
- This screen is displayed to all banks selected on the second screen.
- It presents all bills that can be sent to the banks for PIX registration. For the first bank, we have all the bills with the status CNAB to generate. As some are selected to the first bank, they are not available for the second bank anymore, and so successively.
- Fourth Screen - Cancellations
- This screen displays the bills that had the PIX cancellation requested for the banks selected in screen no. 2. These are added automatically to each CNAB file generated from the respective bank.
- Fifth Screen - File Generation
- To each generated file, we present the operation success and the name of the file generated.
|
Expandir |
---|
|
This option allows you to check details about the bill in what concerns PIX, such as submission date and time, cancellation date and time, customer, and other data relevant to the process. |
Expandir |
---|
|
Through this option, you can print a report with bill information in the selected period or only the record positioned on the screen. This routine only prints bills that were already registered in the PIX system and that already have a QR Code available in the system. This information is available after the bank's return with the respective confirmation that the bill was successfully added to the PIX system. |
Expandir |
---|
|
This option allows you to resend emails to notify customers about the PIX collections, making the QR Code available for payment (same template of the PIX report, "Print PIX" option). This is possible when the PIX is in status "QR Code Generated" (caption ), i.e., after it is sent to the bank, and the Entry Confirmed return is received. - Parameters used
- Positioned bill - This defines if the PIX collection e-mail using QR Code will happen only for the bill positioned in the browse. If set to Yes, the other questions will not be considered. If set to No, the other questions must be answered.
- Issuance From/To - This defines the data interval to filter the PIX bills by issue date (the filter considers table F71, not table SE1, but the information is the same).
- Due Date From/To - This defines the data interval to filter the PIX bills by the due date (the filter considers table F71, not table SE1, but the information is the same).
- Customer - This defines the customer to whom the PIX collection e-mail will be sent for the record if the question Positioned Bill is set to No.
- Store - This defines the customer's store to which the PIX collection email will be sent for the record if the question Positioned Bill is set to No.
|
Expandir |
---|
|
This option allows you to configure collection letters, messages sent with the collection letters, and QR Code, plus parameterizing the PIX value that will be sent in the remittance file. The screen is divided into 3 grids (rows): - Grid 1 - Collection letter
- Addition Layout Code and Deletion Layout Code - In these fields, you must enter the collection letter template used for sending the newly generated PIX bills and the canceled PIX bills to the customer.
- Grid 2 - Default message
- Field for the customer to enter a message that will be sent to all customers with the QR Code, so that the payer user will know who sent the code.
- Grid 3 - PIX Value parameters in the CNAB remittance
- This configuration determines the calculation method for the PIX Value (F71_VLRPIX) field. This field can be used when generating the remittance file. You just have to use it in the PIX remittance layout for that.
- Setting the PIX value may consider: increasing or decreasing the balance value, the ancillary values (FINA035), and/or the taxes generated in the issuance or that will be generated in the bill posting.
- The FINVLPIX entry point was created in case the customer wants to customize the value to be sent to the bank.
- For more information on this entry point, check the link - Entry Point - FINVLPIX.
- Grid 4 - Purpose and history of PIX posting
- Using the MV_FINPIX7 and MV_FINPIX8 parameters, you can configure a default purpose and history of posting to be used in all PIX postings.
- Posting purpose (MV_FINPIX7): This parameter is intended to set the default posting reason with bank transactions that will be used in all PIX postings.
- Posting History (MV_FINPIX8): This parameter is intended to configure the PIX default posting history that will be saved in the E5_HISTOR, FK1_HISTOR, and FK5_HISTOR fields.
- Grid 5 - Type of bank communication
- Indicates how transactions will be performed on the PIX monitor. Saves the settings in the MV_FINPIX9 parameter.
- Default CNAB configuration.
- Grid 6 - Record conciliation.
- Exclusive item for online use.
- Indicates whether the return of the records is the conciliated banking transaction entered or not. Saves the configuration in the MV_FIPIX10 parameter.
Card template |
---|
Desc | The option to configure increase, decrease, ancillary values (FINA035), and taxes that may compose the value of the PIX applies exclusively to the PIX CNAB. |
---|
Titulo | IMPORTANT! |
---|
|
|
Expandir |
---|
|
To transmit the record without waiting for the job to run (FINA892), an option was made available in "Other Actions - Transmit" of the PIX Monitor to record the immediate collection manually following the same assumptions of job validations but including only the record positioned in the PIX collection system. For more information - Transmission of positioned record. |
Expandir |
---|
|
The “Post" option has the same functionality as the PIX collection return job (FINA892A). It was made available to perform the record posting without the need to wait for the job to run. It was made available under "Other Actions - Post" of the PIX Monitor to perform the immediate posting of the collection after it was registered in the PIX system, manually following the same assumptions of job validations, but including only the record positioned at the posting. More information - Posting of positioned record. |
Expandir |
---|
|
The PIX collection cancellation process using the PIX Monitor routine happens according to the bill status in PIX (F71_STATUS). The chart below explains the cancellation behavior in relation to the bill status in PIX:
Bill status in PIX / Caption | Routine behavior | Image Added1 - CNAB to Generate | The bill will be canceled (F71_STATUS = 7, and FKF_RECPIX=2). | Image Added2 - CNAB Generated
| Message on screen explaining that the CNAB was generated and that it is awaiting a return from the bank. | Image Added3 - QR Code Generated
| The bill status becomes Requested to the bank (F71_STATUS = 6, and F71_SOLCAN =1). | Image Added4 - Customer Notified
| The bill status becomes Requested to the bank (F71_STATUS = 6, and F71_SOLCAN =1). | Image Added5 - Receipt Confirmed | Message on screen explaining that the payment has been processed. | Image Added6 - Cancellation Requested | Message on screen explaining that the cancellation was requested to the bank. | Image Added7 - Cancellation sent to the bank | Message on screen explaining that the cancellation was sent to the bank. | Image Added8 - Canceled | Message on screen explaining that the bill is canceled. |
|
Expandir |
---|
|
Variable Name | MV_PIXDTHR |
---|
Type | Character |
---|
Description | Date and time of last execution of the PIX API integration in the format aaaa-mm-ddThh:mm:ss.MMMMMZ. Example: 2021-12-20T12:05:01.000001" 2022-12-13T08:10:12.000001 |
---|
Default Value |
|
---|
Variable Name | MV_BCOPIX |
---|
Type | Numeric |
---|
Description | Defines the form of PIX Bills association with the Bank.
1=The configured bank that has a PIX key; 2=The TOTVS PIX Bank; 3=Manual link via FINA890. |
---|
Default Value |
|
---|
Variable Name | MV_FINPIX1 |
---|
Type | Character |
---|
Description | Collection letter to be sent in the inclusion of the PIX. |
---|
Default Value |
|
---|
Variable Name | MV_FINPIX2 |
---|
Type | Character |
---|
Description | Collection letter to be sent in PIX deletion. |
---|
Default Value |
|
---|
Variable Name | MV_FINPIX3 |
---|
Type | Character |
---|
Description | Default message to be sent in PIX inclusion. |
---|
Default Value |
|
---|
Variable Name | MV_FINPIX4 |
---|
Type | Character |
---|
Description | Calculation rule of the PIX value (collection value). |
---|
Default Value |
|
---|
Variable Name | MV_FINPIX5 |
---|
Type | Character |
---|
Description | Canceled bill message to be printed on the FINRPIX report. |
---|
Default Value | For your control, see below a list of canceled bills for your company through the PIX payment method. |
---|
Variable Name | MV_FINPIX6 |
---|
Type | Character |
---|
Description | Generated bill message to be printed on the FINRPIX report. |
---|
Default Value | For your control and payment, see below a list of bills generated for your company through the PIX payment method. |
---|
Variable Name | MV_FINPIX7 |
---|
Type | Character |
---|
Description | Sets the posting purpose that will be used in the PIX posting transactions. |
---|
Default Value |
|
---|
Variable Name | MV_FINPIX8 |
---|
Type | Character |
---|
Description | Sets the posting history that will be saved in the PIX posting transactions |
---|
Default Value |
|
---|
Variable Name | MV_FINPIX9 |
---|
Type | Numeric. |
---|
Description | Defines the type of bank communication to register bills in the PIX system (1 = CNAB, 2 = Online) |
---|
Default Value | 1 |
---|
Variable Name | MV_FIPIX10 |
---|
Type | Character |
---|
Description | Sets whether the banking transaction of PIX bills will be automatically conciliated when posting. 1-Conciliate; 2-Do not conciliate (Default); |
---|
Default Value | 2 |
---|
Dica |
---|
The MV_PIXDTHR parameter is populated by job FINA892, where the date/time of the last run is written so that the next online data requisition is from the time of the last requisition. The MV_BCOPIX parameter defines the form of association of the bank, branch, and account with the generated PIX and has the following contents: Set to 1: Search how many active PIX keys exist in table F70. If there is more than one, the bank must be associated manually using the PIX Monitor (FINA890); Set to 2: Association method for the bank configured through the PIX Wizard routine (FINA893); Set to 3: no bank is associated, and it must be linked manually using the PIX Monitor (FINA890).
The parameters mentioned above are configured in the Configure option in Other Actions, in the PIX Monitor routine (FINA890). |
Aviso |
---|
| The MV_FINPIX4 parameter is used only in the CNAB PIX because, in online transactions, the net amount is calculated automatically by the system. |
|
04. ACCOUNTS PAYABLE
Expandir |
---|
|
In the bill complement, in the Accounts Payable record, at the new PIX tab, a new field stores the information corresponding to the QR Code of that received bill. This field can receive the QR Code content in at least two ways: - QR Code reader connected to the computer
- Using the barcode_scan.exe app provided by TOTVS for this end (click here for more information and download) that must be in the system's SmartClient folder. This app is started using the Other Actions >> Read PIX QR Code option. Using this app, you can navigate through the emails, PDFs, and images where the QR Code that represents the positioned bill's PIX is available, and scan the image. When the scan is successful, the information is sent to the computer's clipboard. Then, select the field in question and use Windows Paste (CTRL + V) to link the information to the bill.
With the information available in the field, when the user leaves the field, the system will interpret the QR Code entered and display some information, such as Beneficiary, Value, Currency, City, Country, and Postal Code of the bill, so that the user can check if the QR Code was scanned successfully. The system also allows taxes bills such as the INSS to receive the QR Code information. However, in these cases, the bill complement tab will only enable fields from the CNAB and PIX tabs for filling in. - Please note that only Dynamic QR Codes are sent to the Payment CNAB natively with the template provided by CNAB CLOUD. As an example of the difference between a Dynamic and Static QR Code, after being decoded, we can cite that the Dynamic has a URL, and static has the receiver's Pix key:
- Fictitious Example of a Dynamic QR Code:00020101021226740014br.gov.bcb.pix2552com/pix/8baaa2f3-9c41-40d1-a91a-bc93113bd4415204000053039865406123.455802BR5913John Doe6008BRASILIA62190515RP12345678-20196304FA24
|
Expandir |
---|
|
Using the CNAB Cloud Wizard routine, the layout that serves the CNAB for 240 positions from the main banks in Accounts payable will be provided, easing the configuration of the respective layouts. |
Expandir |
---|
title | CNAB Configuration Tool Template 2 |
---|
|
This routine did not need adjustments because it natively allows the configuration of the new layout block for the main banks.
Dica |
---|
| The following new functions are available for use in the CNAB Configurator Template 2: - FNRETPIX(nOpcao)
- With parameter 1, the function returns the active PIX Key Type for the selected supplier
- With parameter 2, the function returns the active PIX Key for the selected supplier
- With parameter 3, the function returns whether the transfer (Template 45) is using a checking account or a PIX key (in this case, a key must be configured in the selected supplier)
- FNURLPIX()
- Returns the URL extracted from the QR Code entered in the positioned bill
|
|
Expandir |
---|
title | Payment Bordereau (FINA240, and FINA241) |
---|
|
These routines now validate the new templates 45 - PIX - Transfer and 47 - PIX - QR Code that can only be used if the bank/branch/bordereau account has an active PIX key in Banks registration > Other actions > PIX keys. - Template 45 - PIX Transfer must be selected for building bordereaux for transferring values to the suppliers. The supplier for these bills must have an active PIX key in the respective supplier PIX Keys record.
- Template 47 - PIX QR Code must be selected for building payment bordereaux for the bills that have a QR Code scanned in the respective bill complement field in the PIX tab.
|
Expandir |
---|
|
This routine did not need adjustments and will be responsible for processing the PIX CNAB return by posting the bills as in a traditional CNAB. |
Aviso |
---|
|
The FINA300 - SISPAG routine available at the Updates/Bank Communication menu was not edited for processing CNAB with the PIX payment method since the process also serves the CNAB 240 positions - Sispag 1 file. |
05. TABLES AND FIELDS USED
AI0 - Customer Complement (Accounts Receivable)
AI0_RECPIX - Generate PIX
AI0_EMAPIX - E-mail PIX
FKF - Bill complement
FKF_RECPIX - Generate PIX - (Accounts Receivable)
FKF_PAGPIX - QR Code - (Accounts Payable)
FRV - Collection Status
PIX Status - (Accounts Receivable)
F70 - PIX Bank Keys (Both Portfolios)
F71 - PIX Monitor (Accounts Receivable)
F72 - PIX Supplier Keys (Accounts Payable)
SA6 - Banks
A6_ISPB - ISPB Code (used for sending the PIX remittance - Accounts receivable via CNAB)
A6_BCOOFI - Official Bank (used for online communication)