Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

Índice


Informações
titleNote

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
titleNote - 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
effectDuration0.5
historyfalse
idsamples
effectTypefade
Card
defaulttrue
id1
labelBordereau

Bordereau

...

To generate the Taxes Bordereau:

...

title
  1. 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 Bank
  • .
  • After 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
    id3
    labelSearch

    Use filters to search for information, ordering it in accordance with a given characteristic.

    Example:

    • branch+prefix+bill no.+installment+type.
    Card
    id4
    labelCancel

    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
    titleNote

    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
    id5
    labelLabel

    This option indicates the types of bills available through colors.

    Card
    id5
    labelQuery Retentions

    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
    effectDuration0.5
    historyfalse
    idsamples
    effectTypefade
    Card
    defaulttrue
    id1
    labelAdvance Payments (PA)

    Settings for displaying Advance Payment (PA)-type bills in the Tax Bordereau routine (FINA241):

    1. 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
    effectDuration0.5
    historyfalse
    idsamples
    effectTypefade
    Card
    defaulttrue
    id1
    labelLP 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
    id2
    labelLP 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.