| Informações |
|---|
|
This routine was adjusted to comply with the General Personal Data Protection Law (Statute No. 13.70) so that some fields containing data regarded as sensitive and/or personal are blurred, becoming illegible. |
01. OVERVIEW
This routine groups bills payable in bordereaux to send them to the bank along with instructions on the payment term.
...
After the payment bordereau is generated, bills are automatically posted. Use the option Automatic Posting Payable to check the bordereau number.
...
...
 Image AddedImportant:
- Once you generate the bordereau, prepare the File to Send to the bank, if you use Bank Communication - CNAB. You can only send the file after registering CNAB Parameters.
- When you enter Yes in question Select Branches? you can select the branches to be included in the bordereau generation.
- You can generate the payment bordereau with the Payment Method through routine Suppliers and Accounts Payable. To do this, fill out the field Paymt Method.
|
...
| Informações |
|---|
| title | Note - TOTVS Connect Bank (TCB) |
|---|
|
By internal settings, the integration with TOTVS Connect Bank is unavailable, and, at this time, it does not have an activation forecast. Selecting the "Transmit Bordereau through TCB" option will not affect the system. |
02. OPERATIONS
| Deck of Cards |
|---|
| effectDuration | 0.5 |
|---|
| history | false |
|---|
| id | samples |
|---|
| effectType | fade |
|---|
|
| Card |
|---|
| default | true |
|---|
| id | 1 |
|---|
| label | Bordereau |
|---|
| Bordereau |
|
...
To generate the Taxes Bordereau: |
|
...
| title | - In Taxes Bordereau, press [F12] and follow field help instructions to set routine parameters.
|
|
|---|
| Informações |
|---|
| Image AddedNote: - The parameter Check Bills Aut.? defines whether bills are displayed pre-checked. If configured as Yes, bills are displayed pre-checked. If configured as No, bills are displayed unchecked.
- Parameter Consider Scheduling? schedules the clearing of Bills Payable, regardless of actual due dates
|
|
.
TOTVS Connect BankIf in a release equal to or more recent than 12.1.23, you can make the Automatic Transmission of the bordereau TOTVS Connect Bank in case the CNAB TCB configuration files are already generated in \system\ through routine CNAB Cloud, selecting the new screen parameter: Transmit Bordereau Through TOTVS Connect BankAfter bordereau generation, if it has not been Transmitted through TOTVS Connect Bank, you will need to prepare the File to be Sent to the bank when using CNAB Banking Communication.
2. Check the information and confirm |
|
...
. 3. Then, select the option Bordereau. 4. The system displays the Bordereau Payment screen. |
|
4. Follow field help instructions to fill out the data requested.
5. Check and confirm the data.
...
5. Fill in the requested information according to the field's help instructions. 6. Check the information and confirm. If the parameter Check Bills Aut.? is set to Yes, the bills that match the fields filled out are displayed |
|
...
on another screen, checked with a green X. |
|
...
7. To select an unchecked bill or to deselect it, place the cursor on it and press [Enter] or double-click it. |
| Card |
|---|
| Use filters to search for information, ordering it in accordance with a given characteristic. Example: - branch+prefix+bill no.+installment+type.
|
| Card |
|---|
| When you activate this option, fill in the information that should be filtered to consider the cancelation of the bordereau, such as your number. Then, confirm the procedure.
| Informações |
|---|
| It is not possible to cancel a bordereau with a date before its generation. For example, if the bordereau has a generation date on August 26, 2022, it is only possible to cancel with a date equal to or greater than August 26, 2022. |
|
| Card |
|---|
| This option indicates the types of bills available through colors. |
| Card |
|---|
| This option allows you to query tax posting and withholding transactions of the withholdings engine related to the bills. |
|
03. EXAMPLES OF USE
| Deck of Cards |
|---|
| effectDuration | 0.5 |
|---|
| history | false |
|---|
| id | samples |
|---|
| effectType | fade |
|---|
|
| Card |
|---|
| default | true |
|---|
| id | 1 |
|---|
| label | Advance Payments (PA) |
|---|
| Settings for displaying Advance Payment (PA)-type bills in the Tax Bordereau routine (FINA241): - In the routine of creating the Bill Payable (FINA050), the parameters Bank Trans. w/out check and Generate check for advance must be set to No.
2. In Tax Bordereau (FINA241), the parameter Consider bills? must be set to Both or Advance.
If the parameter Generate check for Advance is set to Yes, the Advance Payment bill is not displayed on the selection screen for the creation of the Tax Bordereau, so this bill is not generated in duplicity, as the check has already been generated. However, if it is necessary to include advance payment-type bills in the bordereau, entry point FA240PA must be used as in the documentation: FA240PA - Select PA with banking transaction.
|
|
04. PARAMETERS
For more parameters and information, see Financial Parameters.
05. ACCOUNTING FOR POSTINGS BY TAX GENERATION
| Deck of Cards |
|---|
| effectDuration | 0.5 |
|---|
| history | false |
|---|
| id | samples |
|---|
| effectType | fade |
|---|
|
| Card |
|---|
| default | true |
|---|
| id | 1 |
|---|
| label | LP 530 - Accounts Payable Postings |
|---|
| To account, in the generation of the tax bordereau, if partial postings related to the generation of taxes occur, the following sequences must be configured: - Using table SE5 (Bank Transactions)
Cod Stand Entry | Description | Entry Type | Vl. Currency 1 |
|---|
530 | POSTINGS BY TAX BORDEREAU PCC | 3 | IIF(SE5->E5_MOTBX='PCC',SE5->E5_VALOR,0) | 530 | POSTINGS BY TAX BORDEREAU INC. TAX | 3 | IIF(SE5->E5_MOTBX='IRF',SE5->E5_VALOR,0) | 530 | POSTING BY TAXES BORDEREAU ISS | 3 | IIF(SE5->E5_MOTBX='ISS',SE5->E5_VALOR,0) |
- Using table FK2 - Postings Payable
Cod Stand Entry | Description | Entry Type | Vl. Currency 1 |
|---|
530 | POSTINGS BY TAXES BORDEREAU PCC FK2 | 3 | IIF(FK2->FK2_MOTBX="PCC",FK2->FK2_VALOR,0) | 530 | POSTINGS BY TAXES BORDEREAU INC. TAX FK2 | 3 | IIF(FK2->FK2_MOTBX="IRF",FK2->FK2_VALOR,0) | 530 | POSTINGS BY TAXES BORDEREAU ISS FK2 | 3 | IIF(FK2->FK2_MOTBX="ISS",FK2->FK2_VALOR,0) |
|
| Card |
|---|
| id | 2 |
|---|
| label | LP 531 - Accounts Payable Posting Cancelation |
|---|
| To account, in the cancelation of the tax bordereau, if partial postings related to the generation of taxes occur, the following sequences must be configured: - Using table SE5 (Bank Transactions)
Cod Stand Entry | Description | Entry Type | Vl. Currency 1 |
|---|
531 | CANCEL. OF POSTINGS BY TAX BORDEREAU PCC | 3 | IIF(SE5->E5_MOTBX='PCC',SE5->E5_VALOR,0) | 531 | CANCEL. OF POSTINGS BY TAX BORDEREAU INC. TAX | 3 | IIF(SE5->E5_MOTBX='IRF',SE5->E5_VALOR,0) | 531 | CANCEL. OF POSTING BY TAXES BORDEREAU ISS | 3 | IIF(SE5->E5_MOTBX='ISS',SE5->E5_VALOR,0) |
- Using table FK2 - Postings Payable
Cod Stand Entry | Description | Entry Type | Vl. Currency 1 |
|---|
531 | CANCEL. OF POSTINGS BY TAXES BORDEREAU PCC FK2 | 3 | IIF(FK2->FK2_MOTBX="PCC",FK2->FK2_VALOR,0) | 531 | CANCEL. OF POSTINGS BY TAXES BORDEREAU INC. TAX FK2 | 3 | IIF(FK2->FK2_MOTBX="IRF",FK2->FK2_VALOR,0) | 531 | CANCEL. OF POSTINGS BY TAXES BORDEREAU ISS FK2 | 3 | IIF(FK2->FK2_MOTBX="ISS",FK2->FK2_VALOR,0) |
|
Image AddedNote: - As tax generation in the tax bordereau constitutes a partial posting in the amount of the withheld tax, the tax values fields in Table SE2 (Bills Payable) should not be used, as these refer to the calculated values and not the actual values withheld.
|
|
