Exibir origem

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

Index	F3K
Order	1
Key	F3K_FILIAL + F3K_PROD + F3K_CFOP + F3K_CODAJU + F3K_CST + F3K_GRCLAN + F3K_GRPLAN + F3K_GRFLAN
Description	Branch + Product + CFOP + Decl.Val.Code + CST + Customers Grp. + Product Grp. + Supplier Grp.
Display Search	Yes

Index	F3K
Order	2
Key	F3K_FILIAL + F3K_PROD + F3K_CFOP + F3K_CST
Description	Branch+Product+CFOP+CST
Display Search	Yes

SX1 – Questions File:

Question	From NCM:
Routine	FISA140
Type	Character

Question	To NCM:
Routine	FISA140
Type	Character

Question	From Product:
Routine	FISA140
Type	Character

Question	To Product:
Routine	FISA140
Type	Character

Question	Action ?
Routine	FISA140
Type	Character

Question	Product Source?
Routine	FISA140
Type	Character

Question	From Group:
Routine	FISA140
Type	Character

Question	From Group:
Routine	FISA140
Type	Character

SX2 – Tables

Key	Name	Mode	Pyme	Key
F3K	Items x Decl. Val.Codes	Exclusive	Yes	F3K_FILIAL+F3K_PROD+F3K_CFOP+F3K_CODAJU+F3K_CST+F3K_GRCLAN+F3K_GRPLAN+F3K_GRFLAN

SX3 – Fields:

Field	F3K_FILIAL
Type	Character
Size	2
Decimal	0
Format	@!
Title	Branch
Description	System Branch
Used	No
Mandatory	No
Browse	Yes
Context	Real
Ownership	Edit
Fields Group	033 - Branch Size
Order	01

Field	F3K_PROD
Type	Character
Size	15
Decimal	0
Format	@!
Title	Product
Description	Product
Used	Yes
Mandatory	Yes
Browse	Yes
System Val.	ExistCpo('SB1')
Context	Real
Ownership	Edit
Stand. Query	SB1
Fields Group	030 - Product Size
Order	02

Field	F3K_CFOP
Type	Character
Size	5
Decimal	0
Format	@!
Title	CFOP
Description	CFOP
Used	Yes
Mandatory	Yes
Browse	Yes
System Val.	ExistCpo('SX5', '13' + M->F3K_CFOP)
Context	Real
Ownership	Edit
Stand. Query	13
Order	03

Field	F3K_CODAJU
Type	Character
Size	8
Decimal	0
Format	@!
Title	Decl. Val. Code
Description	Decl. Val. Code
Used	Yes
Mandatory	Yes
Browse	Yes
Val. System	ExistCpo('CDY')
Context	Real
Ownership	Edit
Stand. Query	CDY
Order	04

Field	F3K_VALOR
Type	Character
Size	1
Decimal	0
Format	@!
Title	Amount
Description	Value
Used	Yes
Mandatory	Yes
Browse	Yes
Options	1=ICMS ST;2=IPI;3=Freight;4=Deferred Value;5=Exempt/Other Reduc. Base 7=Expenses;9=Accounting Value
Context	Real
Ownership	Edit
Order	05
Help	Specify the value as per V.C. Attachment GIA/RS. Options: 1=ICMS ST;2=IPI;3=Freight;4=Deferred Value;5=ICMS Exempted/Others Reduced Base ;7=Expenses;9=Accounting Value.

Field	F3K_CST
Type	Character
Size	2
Decimal	0
Format	@!
Title	CST
Description	CST
Used	Yes
Mandatory	No
Browse	Yes
System Val.	ExistCpo('SX5', 'S2' + M->F3K_CST)
Context	Real
Ownership	Edit
Stand. Query	S2
Order	06

Field	F3K_CODREF
Type	Character
Size	7
Decimal	0
Format	@!
Title	Reflex Code
Description	Reflex Code
Used	Yes
Mandatory	No
Browse	Yes
System Val.	ExistCpo('CE0')
Context	Real
Ownership	Edit
Stand. Query	CE0
Order	07

Field	F3K_GRCLAN
Type	Character
Size	3
Decimal	0
Format	@!
Title	Customer Grp.
Description	Customers Group
Used	Yes
Mandatory	No
Browse	Yes
System Val.
Context	Real
Ownership	Edit
Stand. Query
Order	08

Field	F3K_GRPLAN
Type	Character
Size	4
Decimal	0
Format	@!
Title	Product Grp.
Description	Product Group
Used	Yes
Mandatory	No
Browse	Yes
System Val.	Vazio() .Or. ExistCpo("SX5","21"+M->F3K_GRPLAN)
Context	Real
Ownership	Edit
Stand. Query	21
Order	09

Field	F3K_GRFLAN
Type	Character
Size	3
Decimal	0
Format	@!
Title	Supplier Grp.
Description	Suppliers Group
Used	Yes
Mandatory	No
Browse	Yes
System Val.
Context	Real
Ownership	Edit
Stand. Query
Order	10

Field	F3K_IFCOMP
Type	Character
Size	6
Decimal	0
Format	@!
Title	Tax Ent. Note
Description	Note Tax Entry
Used	Yes
Mandatory	No
Browse	No
System Val.	Vazio().Or.ExistCpo('CCE')
Context	Real
Ownership	Edit
Stand. Query	CCE
Order	11

Field	F3K_CODLAN
Type	Character
Size	10
Decimal	0
Format	@!
Title	Entry Code
Description	Entry Code
Used	Yes
Mandatory	No
Browse	No
System Val.	Vazio() .Or. EXISTCPO("CC6")
Context	Real
Ownership	Edit
Stand. Query	CC6
Order	12

SX6 - Parameters:

Items/Folders	Description
Name	MV_GIAEFD
Type	Logical
Description	Indicate whether the Additional Calculation Information - Declaration Values will be calculated through the calculation of ICMS.
Default Value	.F.

Items/Folders	Description
Name	MV_MTCLF3K
Type	Character
Description	Method for framing the declaration value F3K. 0 - Framing by product; 1 - Framing by group: customer, product, and supplier.
Default Value	0

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.

The value field is available only when the MV_GIAEFD parameter is Active (.T.)

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

Customers operating in releases 12.1.25 or earlier must run the UPDDISTR compatibilizer with the differential package (SDFBRA.txt) in the systemload folder to use the latest version of the routine. In this case, the differential package will be available on the December/2019 continuous dispatch, and the package can be accessed athttps://suporte.totvs.com/portal/p/10098/download#company/

We recommend the following configuration as a search key:

Search: Tax Dispatch

Product: Protheus

Version: Example: MICROSIGA PROTHEUS VERSION 12.1.25

Environment: Periodic updates

For information about Continuous Dispatch, access: http://tdn.totvs.com/x/H4uCEw.

For information about the UPDDISTR compatibilizer, access: Dictionary and database updater - UPDDISTR.

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

The reflex and groups fields will be available only when the MV_GIAEFD parameter is disabled (.F.)

Routine operation via the settings in this document will only work when the MV_MTCLF3K parameter is 1 (framing by group: customer, product, and supplier). Check the information about creating the new parameter at the end of this document.

After the application of the differential package of the December/2019 continuous dispatch, it is possible to make the bonding using groups, which will decrease the configuration work and the number of records in table F3K.

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

The parallel use of the calculation records by this routine (FISA140) and calculation settings by the Type of Inflow and Outflow (MATA080) can cause duplicate records in the Tax Document (CDA) Entries table. Therefore, it is very important to register the information correctly, aiming at the use of Adjustment Codes by TIO.

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;

Linha Microsiga Protheus - Inglês > CADSPED - Product x Declaration Value Codes_F3K > image2019-5-8_18-11-56.png

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.

In the Edit action of the facilitator, you must enter the CFOP, Decl.Val.Code, and CST fields to edit the Reflex Code. Therefore, this functionality only works to change the Reflex Codes of the records in table F3K.

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
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+

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

CONTENTS