CONTENTS

01. OVERVIEW

The CL2_VLAQUI field is used to store the acquisition value of record F130 in EFD Contributions, serving as the basis for calculating the corresponding PIS/COFINS credit.

This documentation aims to detail how this field is populated, allowing the user to correctly configure F130 generation for each asset according to their needs.

We recommend linking all assets to the incoming invoice, to correctly generate record F130, considering that the system uses data of the invoice (SD1) e TIO (SF4) that generated the asset to assemble such values as the exclusion value (to be detailed in the following steps). You must follow this recommendation for all assets to participate in EFD Contributions.

Documentation to generate EFD mentioning the need to link assets to the invoice: Cross Industries - Backoffice Protheus - FIS - Magnetic Files - How to generate the EFD Contributions F120 Record

02. CONTENT OF FIELD IN RECORD F130

The CL2_VLAQUI field in F130 of EFD can be populated according to several scenarios, as detailed below:

  1. If the Asset originates from an Incoming Invoice and parameter MV_AGVLATF is set to .F., the system will position itself on the incoming invoice that generated the asset and will consider field D1_BASIMP6 as the Acquisition Value. The system also considers the Fixed Asset Unbundling rule (F4_BENSATF) and if it is enabled, the obtained value is divided by the quantity of items on the invoice (D1_QUANT), in order to generate only the proportional value of the asset created by that invoice.
  2. If parameter MV_BSCREPC is set to 1, the system will use the original value of the asset registered in tables SN3/SN4. Regarding this mode: 
    1. This is not the recommended mode, since values such as acquisition value should ideally come from the invoice, considering that it contains the full acquisition amount and that the asset may be generated with tax discounts or additions, discounts, and so on.
    2. In addition, other values used in the F130 calculation are not generated, such as the Exclusion value, which is directly linked to the Incoming Invoice.
  3. If parameter MV_BSCREPC is set to 2, the Asset originates from an Incoming Invoice and parameter MV_AGVLATF is set to .T., the system will position itself on the incoming invoice that generated the asset and will return the value based on the following criteria:
    1. The formula contained in parameter MV_AFVL130, will be used, defining the rule for obtaining the Incoming Invoice value. If the parameter is blank, the current standard will be considered, which is "SD1->D1_TOTAL".
    2. After obtaining the invoice value, the system considers the Fixed Asset Unbundling rule (F4_BENSATF) and if it is enabled, the obtained value is divided by the quantity of items on the invoice (D1_QUANT), in order to generate only the proportional value of the asset created by that invoice.
    3. In addition to the Incoming Invoice that originated the asset, Extended Warranty/Services from table SF8 and the CTE (Freight Bill of Lading) linked to the main invoice, if any, will also be considered. The calculation of these supplementary invoices follows the same logic as the main invoice, and the result is added to the final acquisition value.
  4. If parameter MV_BSCREPC is set to 2 and the Asset is not originated from an Incoming Invoice, the system will use the asset’s Acquisition Value (N1_VLAQUIS).

03. ENTRY POINTS DEPREATF

The default acquisition value used in F130 can be changed by the Entry Point DEPREATF, the value returned by the entry point takes precedence, and the system will not consider the default acquisition value. Find the Entry Point documentation here: PE DEPREATF.

04. RELATED SUBJECTS

EFD Contributions - F120 and F130 - Fixed Assets