CADSPED - Product x Declaration Value Codes_F3K

CONTENTS

01. OVERVIEW

The registration routine Products x Declaration Value Codes aims to register taxation rules that vary depending on the product, CFOP, and Declaration Value Codes, according to table 5.2 - Table of Additional Calculation Information - Declaration Values, of the Public Tax Bookkeeping System - EFD ICMS/IPI.

These rules will be used in the calculation of ICMS in the recording of the CDV table, so that it is possible to generate the EFD ICMS/IPI record E115 correctly, and, with this, the possibility of importing the file generated for the Normative Instruction GIA-RS - version 8.5

02. EXAMPLE OF USE

SIX - indexes Updates of the compatibilizer

• Table F3K – Items x Declaration Value Codes

SX1 – Questions File:

SX2 – Tables   

SX3 – Fields: 

SX6 - Parameters:

03.USAGE PROCEDURE BY CALCULATION

Details of the available fields on the registration screen: 

• Product. (F3K_PROD): Enter the code of the operation product;
• CFOP. (F3K_CFOP): Operation CFOP;
• Decl. Val.Code (F3K_CODAJU): Code of declaration value associated with the operation. 
• Value(F3K_VALOR): Value as per Annex I and Annex V of GIA/RS.
• CST(F3K_CST): ICMS CST associated with the operation.

 
In the ICMS calculation, a query will be performed in the Items x Declaration Value Codes table (F3K) considering the product and the CFOP to identify the associated entry code, allowing the values to be calculated automatically(CDV table - Additional Calculation Information).

• Addition: Allows you to include multiple CFOPs and codes per product;
• Edit: Allows you to edit all CFOP rows and delete any of the existing rows.
• Delete: Delete the selected product and all rows registered in this code.

04.USAGE PROCEDURE BY INVOICE

Details of the available fields on the registration screen: 

• Product. (F3K_PROD): Enter the code of the operation product;
• Customer Group (F3K_GRCLAN): Enter the code of the customer's taxation group (A1_GRPTRIB);
• Product Group (F3K_GRPLAN): Enter the code of the product's taxation group (B1_GRTRIB);
• Suppliers Group (F3K_GRFLAN): Enter the code of the supplier's taxation group (A2_GRPTRIB);
• CFOP. (F3K_CFOP): Operation CFOP;
• Decl. Val.Code (F3K_CODAJU): Code of declaration value associated with the operation;
• CST(F3K_CST): ICMS CST associated with the operation;
• Reflex Code (F3K_CODREF): Code of the reflex record containing the calculation rule for the declaration code;
• Tax Entry Note (F3K_IFCOMP): Code of Entry Note (used to generate the C195 record of the Tax SPED);
• Entry Code (F3K_CODLAN): Tax Document Entry Code (see table CC6).

When the invoice is added, it will be verified if a calculation rule is registered in the Items x Declaration Value Codes table (F3K) to automatically process and generate the CDV table - Additional Calculation Information, and the CDA - Tax Document Entries.

If the configuration by customer group is used (A1_GRPTRIB), the system will search, at the time of calculation, if the invoice customer is framed in the field group (F3K_GRCLAN).

If the configuration by product group (B1_GRTRIB) is used, the system will search, at the time of calculation, if the invoice product is framed in the field group (F3K_GRPLAN).

If the supplier group configuration (A2_GRPTRIB) is used, the system will search, at the time of calculation, if the invoice supplier is framed in the field group (F3K_GRFLAN). 

05.PROCEDURE FOR USING THE CALCULATION ENTRY

• In routine FISA140, the fields F3K_IFCOMP and F3K_CODLAN were added to generate the calculation entries in the CDA table when issuing a Tax Document, centralizing the operations in a single file.

When filling in the F3K_CODLAN field, they will be written in the Tax Document Entries (CDA) table and can be viewed in the ICMS Accounting Entries Tab, and the code of table 5.2 corresponding to the entry code of table 5.3 is also bound. When using this configuration, it will not be necessary to bind TIO X Calculation Entries in the routine Types of Inflow and Outflow (MATA080).

This allows the link between an Entry Code (F3K_CODLAN) and several Declaration Value Codes (F3K_CODAJU).

This setting is made for records C197 and E111 to display adjustment code information in the supplementary description field of the document adjustment, as shown below:

Record C197

• Field 03: Fill with the code of Table 5.2 corresponding to the standard used and kind, indicated in field 02 of record E115;

Record E111

• Field 03: Fill with the code in Table 5.2 corresponding to the standard used, indicated in field 02 of record E115;

When filling in the F3K_IFCOMP field, the C195 record of the Tax SPED is generated.

06. FACILITATOR

In order to expedite the registration in the Items x Declaration Value Codes (F3K) routine, a facilitator was developed and is available in the " Related Actions" option of this routine.  This facilitator will perform the processing, considering the filter and the values entered by the user through the questions in this routine. Below are details of completing these questions: 
 
From NCM:  Enter the initial NCM that you wish to process;

To NCM: Enter the final NCM that you wish to process;

From Product: Enter the initial product code to be considered when processing;

To Product: Enter the final product code to be considered when processing;

Action ?: Through this question, it will be indicated whether the facilitator's processing will edit, add, or delete a record if it already exists. Enter the available options:

Edit: Will edit the record; 

Add: Will add records using the filter made by the facilitator.

Delete: Will Delete records using the filter made in the facilitator.

Product Source?: This question will validate which product source should be processed.

From Group: Enter the code of the initial product group that should be considered in the processing;

To Group: Enter the code of the final product group that should be considered in the processing;

After confirming these questions, a screen with the following fields will appear:

• CFOP: In this field, the code of the operation is recorded in the Items x Declaration Value Codes table (F3K) for NCM and Product entered in the previous questions.
• Decl.Val.Code: In this field, enter the declaratory value code to be entered in the Items x Declaration Value Codes table (F3K) for the NCM and Product entered in the previous questions.
• CST: In this field, enter the CST to be recorded in the Items x Declaration Value Codes (F3K) table for the NCM and Product entered in the previous questions.

• When MV_GIAEFD is Enabled (.T.), the Value field will be displayed 
• Value: In this field, enter the CST to be recorded in the Items x Declaration Value Codes (F3K) table for the NCM and Product entered in the previous questions.

• When MV_GIAEFD is disabled (.F.) the reflex field will be displayed
• Reflex Code: Enter the code of the reflex record containing the calculation rule for the declaration code.

You can enter more than one CFOP for the same product code, or the same CFOP as long as the Declaration Value Codes are different.

Facilitator Processing Example:

• Register code RS052043 for all Products whose NCM is 07095100:  

  From NCM: ?	07095100
  To NCM: ?	07095100
  From Product: ?
  To Product: ?	ZZZZZZZZZZZZZZZ
  Action ?	1-Edit
  Product Source ?	0

   
  Screen with available fields:

  CFOP
  5101
  Decl. Val. Code
  RS052043
  Value
  Accounting Value

  Important

   The facilitator cannot be run in more than one instance.

  
  

  07. ADDITIONAL INFORMATION

• Tables: F3K – Items x Declaration Value Codes (F3K)
• Routines Involved: FISA140 – Items x Declaration Value Codes (F3K) 
• Code Table: {+}http://www.sped.fazenda.gov.br/spedtabelas/AppConsulta/publico/aspx/ConsultaTabelasExternas.aspx?CodSistema=SpedFiscal+