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

<span style="color: #252525">In this diagram, the data refer to the features of the routine: </span>
!worddavaaa54a52fedabc61e13859a5e97a091d.png|height=32,width=32!
<span style="color: #252525"> </span>
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:
Bordereau
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.
Search
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:

Cancel
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.
Caption
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