Páginas filhas
  • Payments Bordereau - FINA240 - Financials - P12

Index

 

Objective

To group bills payable in bordereaux and send them to the bank along with payment method instructions.

You can print the bordereau or create a TXT file the layout of which uses the same mechanisms that create the CNAB remittance file.

You can automatically transmit the bordereau via TOTVS Connect Bank through CNAB TCB.

After the payment bordereau is generated, bills are automatically posted. 


Note

If in a release equal to or more recent than 12.1.23, you can make the Automatic Transmission of the bordereau via TOTVS Connect Bank in case the CNAB TCB configuration files are already generated in \system\ through routine CNAB Cloud.

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.

Both procedures require registering data in the Bank Parameters routine.


Mental Map

In this diagram, the data refer to the features of the routine:

To generate the payment bordereau, press key [F12\] to set routine parameters, following these criteria:


Field:

Description

Consider Bills?

Fill out this field by selecting one of the following options: 

  • Regular: bordereau generation considers only regular bills.
  • Advance: bordereau generation considers only advance payment bills.
  • Both: bordereau generation considers regular bill and advance payment bill options.

    Example:
    Yes.

Consider Branch?

Define the need to consider the branches entered below the payments bordereau by selecting between options Yes and No.


Example:
Yes.

From Branch?

In this field, enter the initial code of the branches to be included in the payments bordereau when the content of field Consider Branch? is equal to Yes.


Example:
M SP 01.

Until Branch?

In this field, enter the final code of the branches to be included in the payments bordereau when the content of field Consider Branch? is equal to Yes.


Example:
M SP 02.

Autom. Select Bills?

Define whether to automatically select bills by selecting from options Yes and No.


Example:
Yes.

Tax Calculation?

This field involves only the Taxes Bordereau routine. To set its content, select between options Actual Due Date, Bordereaux Generation or Both.


Example:
Actual Due Date

Display Entry?

Define whether to display entry by selecting between options Yes and No.


Example:

Yes.

Select Branches?

Select the branches to be included in bordereau generation. Fill out this field by choosing between options Yes and No.


Example:
No.

Consider Paymt Method?

Use options Yes and No to set your preferred payment method as a complement of the payable bills filter.

Sched. Date from?

Enter start date to consider scheduling.


Example:
4/01/16.

Sched. Date to?

Enter end date to consider scheduling.


Example:
4/01/16.


In the main page of the routine, the following options are available:

    Upon selecting this option, choose the Branch desired and click Ok.
    Follow the instructions in Main Fields to fill out the data.
    Check data and confirm procedure to generate bordereau.

    Find this option in item Other Actions. You can use it to change the order of the bordereau bills in the browser.
    Example:
    Branch+Supplier+Store+Prefix+Number+Installment+Type.

    Note

    The bill search process depends on the setting of parameter MV_F240QRY, which includes the following criteria:

    • F: all available indexes are displayed for the search. Select one and confirm it.
    • T: only one index is displayed for the search. Just select and confirm it. This option offers better performance.

    Find this option in item Other Actions. Use it to cancel a bordereau. Upon selecting this option, choose the Branch desired and click Ok.
    Enter the number of the bordereau to be canceled and confirm the procedure.

    Find this option in item Other Actions. Use it to indicate, with colors, the payment bordereau types.


    Main Fields  

    Field:

    Description

    Number:

    Enter bordereau number.


    Example:
    000006.

    Due Date from:

    Enter the initial due date to select bills payable.

         
    Example:
    5/07/16.

    Due Date to:

    Enter the final due date to select bills payable.


    Example:
    05/7/2016

    Value Limit: 

    Enter the limit value of bills to be included in the bordereau.


    Example
    0.00

    Bank: 

    Enter code of bank to be used for bill payments.


    Example:
    321

    Branch: 

    Automatically filled out with branch number in accordance with information from field Bank.


    Example:
    00193

    Account: 

    Automatically filled out with checking account number in accordance with information from field Bank.


    Example:
    1234566

    Subaccount: 

    Enter the Subaccount registered in Bank Parameters tied to the aforementioned Branch and Account.


    Example:
    001.

    Contract:

    If any, enter the code of financing contract linked to bill.

    Currency:

    Enter reference currency that corresponds to bordereau.


    Example:
    01 Real.

    Model:

    Enter the number of bordereau model that indicates the type of operation sent to the Bank. The models are registered in Table 58 of Configurator module.


    Examples:
    01 – credit to checking account.
    02 – payment/administrative check.
    03 – DOC.

    Paymt Type: 

    Enter the payment type considered. The valid types are registered in Table 59 of Configurator module.


    Examples:
    30 – Salary payments.
    50 – Insured claim payments.

    Transmit Bordereau Through TOTVS Connect Bank: 

    Select the checkbox to automatically transmit the bordereau via TOTVS Connect Bank.


    Related Contents