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 transaction allows compensating all advances performed and registered by the Customers (RA bills) and the credit notes to be deducted (NCC bills).

The bills cleared have their opening balances decreased or even zeroed, characterizing a posting of the cleared bill.

Important:

Note: the bills to be cleared cannot be posted, i.e., the colored ball on the left of the bill must be green, which indicates unposted bills.

 

Clearance of bills receivable enables:

•Clearing bills from the same customer/store with advances from the same customer/store;
•Clearing bills from a certain customer with advances from the same customer, regardless of the store of the bill to be cleared. Thus, it is possible to clear the bill with any advance bill from the same customer that is opened in the bills file, regardless of the store from which this bill comes from.
•Clearing a bill from a certain customer with advances from several customers, in which case a customer range or all customers can be established. That way, the bill can be cleared with any advance bill opened in the file, regardless of the customer from which this bill comes from.
•Clearing bills and advances between branches, i.e., customers with advances from this one or other customers in several branches of the company.

Important:

The rate used when posting bills received is treated in the system as it follows:

In Brazil, it is used the rate informed in the bill.

In localized countries, the rate of the day is considered.

 

Note:

Parameter MV_BR10925 defines the time of deduction of the amounts of the taxes (PIS, COFINS, and CSLL) and can be set to 1 (tax deduction occurs when the document is posted) or 2 (tax deduction occurs when the document is issued).

If the parameter MV_BR10925 is set to 1 (deduction of taxes on document posting), in cases in which there is clearing with deduction of these tax amounts, the tax bills will be generated linked to the main bill and never to the advance payment.

•In the bills receivable settlement process, no taxes are calculated.
•The PIS, COFINS, and CSLL taxes existing in the generating bills will only be passed on to the installments in cases where the nature of the bills generated by the invoice allows the calculation of taxes. That way, the taxes of the bills generating the invoice receivable will have their values added and proportionally sized in each installment.
•In the scenario where the MV_BR10925 parameter is set with the content 1 (Posting) and a reduced base exists in the invoice bill, at the time of clearing, the system will take into consideration the reduced base for the calculation and generation of PIS, Cofins, and CSLL taxes.

 

Note:

This routine features integration with RM Classis Net.

For technical details about the procedures of Deployment, Usage, Table Synchronization among Bases and Parameterization for Generation, check the Protheus X Classis Integration Manual available on the TDN portal.

Also, check information about Education Management.

This routine uses posting reason CMP. Check the need to properly register and configure this posting reason in the Registration of Posting Reason - FINA490 routine. 

02. OPERATIONS 

Parameterization for the clearing operation is available via the F12 option. 


      


Consider Store: Indicate whether the customer's store, when the question "Consider Customer" equals Yes, should be considered in the selection of the bills to be cleared.

Consider Customer: Indicate whether the customer of the original bill should be considered in the selection of bills to be cleared, or whether the customers entered in the questions "From Customer" and "To Customer" will be considered

From customer: Initial code of the customers whose bills will be cleared if the question "Consider customer" equals yes.

To customer: End code of the customers whose bills will be cleared, if the question "Consider customer" equals yes.

Clear Transferred: Indicate whether you want the bills transferred to collection to be considered in the selection of the bills to be billed.

Calc.Comiss.w/o NCC: Indicate whether you want to calculate a commission over credit instrument (NCC).

Display Acc. Entry: Indicate whether the accounting entry must be displayed.

Cons.Deductions/Taxes: Indicate whether the balance to be compensated should be reduced by deductions and taxes. If they are not considered, the balance to be considered for operation will be only the balance of the bill.

Account Online: Enter if it is accounted for online.

Consider branches below: Enter whether to consider a branch range to be entered in the next parameters. (Parameter discontinued, replaced by the Branches button on the main bill selection screen)

From Branch: Enter the initial branch to be considered in the branches range. (Parameter discontinued, replaced by the Branches button on the main bill selection screen)

To Branch: Enter the final branch to be considered in the branches range. (Parameter discontinued, replaced by the Branches button on the main bill selection screen)

Calc.Comiss.w/o RA: Indicate whether you want to calculate a commission over credit instrument (RA).

Reuse rate entered: Indicate whether to reuse the rate entered for other compensations.

Cons.Commission Interest: Indicate whether the interest value should be considered when calculating the commission.


The commission on CR clearing can be calculated as long as the financial bill (Invoice) is correctly configured with sales representative and percentage, and the questions below are configured with Yes according to the type of bill that will be cleared - NCC or RA.


Calc comiss w/o NCC?

Enter whether the System should calculate commission in compensations with NCC-type bills.

Question = YES - The system calculates commission.

Question = NO - The system does not calculate commission.


Calc comiss w/o RA?

Enter whether the System should calculate commission in compensations with RA-type bills.

Question = YES - The system calculates commission.

Question = NO - The system does not calculate commission.


Parameters

MV_COMISCR -Indicator that allows calculation of commission for sales representative in the CR clearing.  

"S" - calculate it or "N" - do not calculate it.


TABLE FOR POSTING REASONS

In the reasons for posting table (Miscellaneous -> Files), enter the CMP reason and enable the commission calculation in the reason for posting. Example:
Acronym: CMP
Description: Clearing
Portfolio: A (Both)
 Bank Trans.: N
Commission: S
Check: N


Note: In this process, the Sales Representative and Commission Percentage data of the credit instruments (NCC/RA) will not be considered, only of the financial bill (Invoice, RC etc.)

03.  ACCOUNTING


The accounting for bills with accessory values will be performed as follows: 

  • Clear positioned on the advance

Cleared invoices are positioned during accounting, allowing accessory values to be accounted for as usual. 

  • Clear positioned in the Invoice with accessory value

Since it is the invoice that has the accessory value, in the accounting of the first advance payment bill, tables SE1 and SE5 are positioned in the invoice, so that the accessory value is accounted for. 


Example of accessory value accounting:

Register an accessory value, filling the "CTB Variable" field with the variable to be used in the standard entry configuration. 

Example: CTBDESPC

In the configuration of the standard Clearing Receivables entry, use the variable previously registered in the value to be accounted for.

In accounting, a row will be generated with the accessory value recorded in the cleared invoice. 


Scenario:

Standard Entries configured: 

1) E5_VALOR

2) Variable registered in the VA, for example CTBDESPC

  • Clear positioned in the Invoice with accessory value

Invoice:

Number: MAN - 03 -Invoice 

Value: 10,000.00 with VA: 100.00

Advance:

1) Number: MAN - 04 - RA

Value: 5,000.00

2) Number: MAN - 05 - RA

Value: 5,000.00

The two rows displayed in the example below refer to the two cleared advance payments, where the first line refers to the cleared invoice (due to the need to account for the associated accessory value).

 


  • Clear positioned on the advance:

Invoice:

Number: MAN - 06 -Invoice 

Value: 10,000.00 with VA: 100.00

Advance:

Number: MAN - 07 - RA

Value: 10,000.00

The row displayed in the example below refers to the cleared invoice.


04.  PARAMETERS

PCC Calculation

When setting up PCC withholding on posting without RA withholding control, the preselection of the bills is not performed, so that when the bill is selected, the PCC calculation is performed.

To use it, set the following parameters:

  • MV_BR10925 = 1
  • MV_RARTIMP = 2 

Residual value tolerance to zero the balance after clearing (MV_TOLERPG)

When a remaining balance of cents exists in one of the bills after clearing, you can set up so that the system considers a tolerance margin and posts the bill in its entirety.

This margin value must be configured through the MV_TOLERPG parameter (the bills receivable postings also perform the same treatment through this parameter).

This type of situation usually occurs in offsets involving a foreign currency bill against a local/strong currency bill, where it is common for cents to vary due to the rounding of decimal places after the conversion of the values between the currencies (e.g. Dollar x Real). 

Below is an example of how the routine is impacted by the parameter:

  1. Using the FINA330 routine, a bill of type RA (advance) is selected in dollars. Its value converted to BRL is BRL 1000.05 ;
  2. On the selection screen of bills to be cleared, some bills in reais are selected, totaling BRL 1000.03 (difference of 2 cents in relation to the RA);
  3. For all the bills involved to have their balances reset to zero at the end of the clearing process, the MV_TOLERPG parameter must be set to a value equal to or greater than 00.02 (two cents), otherwise, the remaining difference will remain in the bill balance (which will remain open);

Other parameters

MV_ESTADO - must be set to the branch status

The MV_ESTADO parameter must be set as unique per branch, even if the financial tables are shared.

05. FREQUENTLY ASKED QUESTIONS

How to consider cash discount in the clearing?

Financial discounts are not considered by default. In order for them to be considered, it is necessary to use the F330DES entry point. Further information at: F330DESC - Discount on clearing of accounts receivable

06. OTHER DOCUMENTATION


<!-- esconder o menu --> 


<style>
div.theme-default .ia-splitter #main {
    margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
    display: none;
}
#main {
    padding-left: 10px;
    padding-right: 10px;
    overflow-x: hidden;
}

.aui-header-primary .aui-nav,  .aui-page-panel {
    margin-left: 0px !important;
}
.aui-header-primary .aui-nav {
    margin-left: 0px !important;
}
</style>