Histórico da Página

To perform the clearing process, you need to select the main bill that you want to be cleared.  

Choose the parameters to execute the process: 

Branches button: Used to select the branches that will be considered for clearing.

With the data from the bill to be cleared, we can choose the amount to be cleared as the clearing limit, and also the date of the posting. 

The "Selected Bills" flag can facilitate the process by already selecting the bills according to the balance composition until the balance of the main bill is reached. 

Note: in some situations, due to the way the tax calculation is configured, the initial suggestion ("Selected Bills") is not performed by the system, leaving it up to the operator to select manually so that the tax calculation can be made at runtime. For further information on tax configuration, visit: http://tdn.totvs.com/x/tA2qC

After the screen is displayed, the following options are available: 

• Individual selection of each bill, and this consists of the balance of the bill to confirm or not the selection of the record. Using this option, the system automatically suggests how much the selected bill can be posted according to the balance of the main bill.

Clearing with Contracted Rate 

Parameters involved:

MV_CMTXCON =Indicates that monetary correction will be generated for bills with contracted rate in CP clearing.  T = Generate / F = Do not generate

For the process of clearing with Contracted Rate, the parameter must be configured as follows:

MV_CMTXCON = T (True)

The monetary correction will start from the selected document:

If the advance payment (RA) bill is selected, the invoice bills will suffer monetary correction based on the rate of the selected RA bill.

If the invoice bill is selected, the advance payment (RA's) bills will suffer monetary correction based on the rate of the selected invoice bill.

MV_CMTXCON = F (False)

No monetary correction will be generated and clearing with different contracted rates will not be allowed.

Example:

Invoice:

Value: 1,000.00

Currency: 2

Rate: 2

Converted Value: 2,000.00

Advance:

Value: 1,000.00

Currency: 2

Rate: 2.5

Converted Value: 2,500.00

Performing the clearing from the Invoice, we will have the following recordings in table SE5:

Performing the clearing from the Advance Payment, we will have the following recordings in table SE5:

Example of automatic clearing using the rates above:

#INCLUDE "TOTVS.ch"
#Include "PROTHEUS.ch"    
#Include "PRTOPDEF.CH"
#INCLUDE "TBICONN.CH" 

User FUNCTION COMPCR()

    Local lRetOK := .T.
    Local aArea := GetArea()
    Local nTaxaCM := 0
    Local aTxMoeda := {}
    Local cCliente := "001   "
    Local cLoja := "01"
    Local cPrefixo := "TIT"
    Local cNumDoc := '00001    '
    Local cParcela := " "
    Local cTipoDoc := "RA "
    Private nRecnoNDF
    Private nRecnoE1

    dbSelectArea("SE1")
    dbSetOrder(2) // E1_FILIAL, E1_CLIENTE, E1_LOJA, E1_PREFIXO, E1_NUM, E1_PARCELA, E1_TIPO, R_E_C_N_O_, D_E_L_E_T_

    IF dbSeek(XFILIAL("SE1") + cCliente + cLoja + cPrefixo + cNumDoc + cParcela + cTipoDoc)
        nRecnoRA := RECNO() 

        cTipoDoc := "NF"
        IF dbSeek(XFILIAL("SE1") + cCliente + cLoja + cPrefixo + cNumDoc + cParcela + cTipoDoc)
            nRecnoE1 := RECNO()
            
            PERGUNTE("AFI340",.F.)
            lContabiliza := .F.
            lAglutina := .F.
            lDigita := .F.

            SE1->(dbSetOrder(1)) //E1_FILIAL+E1_PREFIXO+E1_NUM+E1_PARCELA+E1_TIPO+E1_FORNECE+E1_LOJA
            aRecRA := { nRecnoRA }
            aRecSE1 := { nRecnoE1 }

            nSaldoComp := 2000 // Clearing value in strong currency

            nTaxaCM := 2 // Rate considered in the clearing

            aAdd(aTxMoeda, {SE1->E1_MOEDA, nTaxaCM} ) // Rates of the currencies used

            If !MaIntBxCR(3, aRecSE1,,aRecRA,,{lContabiliza,lAglutina,lDigita,.F.,.F.,.F.},,,,,nSaldoComp,,,, nTaxaCM, aTxMoeda)
                Help("XAFCMPAD",1,"HELP","XAFCMPAD","Could not perform clearing "+CRLF+" of the advance bill",1,0)
                lRetOK := .F.
            Else
                Alert("Clearing performed.")
            ENDIF
        ENDIF
   ENDIF

   RestArea(aArea)

Return lRetOK
  

The MV_RATXMOV parameter was created to define the rate to be considered for advance payments without contracted rate in the clearing.

The parameter has been incorporated into Protheus release 12.1.27 and made available in the continuous shipments for the previous releases in effect. 

MV_RATXMOV = .T.

When set to true .T., the rate of its inclusion transaction will be considered.

When clearing comes from the advance payment, this rate will be used for listed bills of the same currency.

When clearing comes from the bill, the bill will use the rate of the day or the rate entered at the time of clearing, and listed advances will use their transaction rate.

MV_RATXMOV = .F.

When set to false .F., the rate of the day of clearing or that used at the time of clearing for all the bills involved will be considered.

Specification of parameter:

Rates used and order of priority

Rate of the day (Table SM2): Once the rate of the day has been set for foreign currency bills, this rate will be considered at the time of clearing.

Bill rate (contracted): The rate set at the time of inclusion of the bills (E1_TXMOEDA) is respected in the clearing. When this contracted rate is entered, clearing uses it, even if a currency rate has been configured for the dates involved (Table SM2);

Rate on clearing: This rate can be set by the option Currency Rates, before selecting the bills for clearing.  Even if the bill has a rate of the day (Table SM2) for the currency in question, or a contracted rate (E1_TXMOEDA), the rate defined at the moment of clearing is considered, if entered;

The criterion for rate conversion is the order of rate configuration, being:

1 - Rate on clearing

2 - Bill rate (contracted)

3 - Rate of the day (Table SM2)

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.)