Páginas filhas
  • CADSPED - Product x Declaration Value Codes_F3K

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

CONTENTS

Índice
exclude

...

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

 

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.


Nota
titleImportant
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

Aviso
titleImportant

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/

...

Image Added

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

...

Image Added.

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


Informações
titleImportant

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

Aviso
titleImportant

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;

Image Removed Image Added


Record E111

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

             Image Removed Image Added

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:

...


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.

Informações
titleImportant
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: