Linha Microsiga Protheus - Inglês

Páginas filhas
  • EFD Contributions - Content of Field CL2_VLEXCL

CONTENTS


01. OVERVIEW

Use the field CL2_VLEXCL to store the exclusion value of records F120 and F130 of EFD Contributions. Thus, it ensures compliance with tax rules by excluding these values from the calculation of taxes such as PIS/Pasep and Cofins.

02. CONTENT OF FIELD IN RECORD F120

Field CL2_VLEXCL in F120 of EFD is fed with the value of ICMS (D1_VALICM) found in the incoming invoice and also the asset's depreciation rate in the month (N4_TXDEPR), containing the following formula:

CL2_VLEXCL = D1_VALICM * N4_TXDEPR

However, this formula is based on a simple scenario. There are some additional considerations:

    1. For field CL2_VLEXCL to have the exclusion value, the TIO field F4_CREDICM must be set to N, otherwise the tax credit is already taken in the invoice and so it uses no exclusion value.
    2. The above formula applies when the asset is not dismembered in the Incoming Document (MATA103), so be mindful of field F4_BENSATF of the TIO in use. If it is set to 1 (Yes), that means the asset has been dismembered and the following formula is used: CL2_VLEXCL = D1_VALICM / D1_QUANT * N4_TXDEPR


Example

When the TIO dismembers assets, they are generated equally by quantity.

For example:

-The incoming invoice has the quantity (D1_QUANT) set to 10 and the Total (D1_TOTAL) equal to BRL 10,000.00

If the TIO in use has the field F4_BENSATF set to 1 (Yes), ten assets of BRL 1,000.00 each are generated. But if field F4_BENSATF is set to 2 (No), only one asset of BRL 10,000.00 is generated.

Hence, when calculating the exclusion value for dismembered assets, the system uses field D1_QUANT in the formula to obtain only the proportional value of the asset selected.


After obtaining the exclusion value, the system uses it to calculate the base values of PIS (CL2_BCPIS) and Cofins (CL2_BCCOF).

03. CONTENT OF FIELD IN RECORD F130

Field CL2_VLEXCL in F130 of EFD is fed with the value of ICMS (D1_VALICM) found in the incoming invoice that originated the asset.

However, there are some additional considerations:

    1. The exclusion value will be fetched if the asset is linked to an incoming invoice and parameter MV_BSCREPC is equal to 2. When the parameter is equal to 1, the system looks only at Fixed Assets, and in fields N1_VLAQUIS and N3_VORIG1 the tax value is already discounted, due to being generated in accordance with parameter MV_VLRATF (default system settings come with the ICMS discount).
    2. As in F120, if the invoice has field F4_BENSATF equal to 1 (Yes), the system fetches ICMS values proportional to the item, dividing field D1_VALICM by D1_QUANT.

04. ENTRY POINTS AF120EXC AND AF130EXC

The default exclusion value used in F120 can be changed by Entry Point AF120EXC. The value returned by the EP is added to the default exclusion value of the system. Find the Entry Point documentation here: AF120EXC - Value exclusion in SPED PIS/COFINS calculation base in record F120

For the F130 we also have a similar Entry Point, the AF130EXC, which adds the value returned by the EP to the default exclusion value of F130. Here is its documentation: AF130EXC - Value deletion in the SPEDPIS/COFINS calculation base in record F130

04. RELATED SUBJECTS