Páginas filhas
  • RESST - Reimbursement of ICMS-ST - Tax Management - P12

CONTENT

01. OVERVIEW

 
Treatment available to meet CAT Ordinance No. 158 of December 28,2015 for Tax SPED EFD

CAT Ordinance No. 158 of December 28, 2015

Establishes discipline for the reimbursement of the tax withheld by passive subjection by substitution and provides related procedures.

The Coordinator of the Tax Administration, aiming to discipline the reimbursement of the tax withheld under the passive subjection regime provided for in Articles 269 and 270 of the ICMS Regulation, approved by Decree no. 45,490 of November 30,2000, as well as having related procedures, hereby requests the following ordinance:

Item 1 - The reimbursement of the tax withheld by passive subjection by substitution, in the cases provided for in paragraphs II to IV of Item 269, as well as the use of the credit provided for in Item 271, all from the ICMS Regulation, shall comply with the provisions of this Ordinance.

This ordinance comes into force on January 1st, 2016, but the old system of calculation that was established in the state of SP through the CAT Ordinance 17, from 1999, can be used to determine the period from January 1st, 2016 to December 31, 2016, being mandatory from January 1st, 20217, and done exclusively through EFD records.

The norm deals with the reimbursement of the ICMS withheld by tax substitution. The São Paulo tax rules provide reimbursement in the following situations:

Non-performed presumed taxable event;Outflow due to exemption or non-incidence; Outflow for taxpayer site in another State.
The reimbursement may be carried out alternatively as listed below:

Adjustment in the calculation of the ICMS;Tax reimbursement invoice;

Reimbursement request submitted to the State's Treasury Office, which will respond to the refusal or acceptance of the request. In the latter case, the procedure to be executed by the taxpayer for the said reimbursement.

ICMS/IPI EFD

When making an outflow operation of goods that guarantees the ICMS taxpayer the reimbursement of the tax withheld by tax substitution (hypotheses listed above), it must be presented in the document covering this operation, in additional information, and replicated in the record C176 of the ICMS/IPI EFD ancillary obligation the information relating to the last invoice of entry of these goods into the site, such as:

Tax document number and series;

Date of the last entry of the goods;

Tax document issuer code;

Unit value of goods;

Unit value of the basis of calculation of the tax paid by substitution;


Each item of the invoice that leads to the reimbursement of ICMS-ST shall generate a C170 record of the ICMS/IPI EFD, which will contain the unit values of the tax withheld by tax substitution and the portion of the proper operation of the substitute (sender of the goods).

The quantity of goods purchased in the last operation shall also be considered. If the last entry note is not sufficient to carry the quantity indicated on the outgoing invoice, the invoice immediately preceding is shall be used. It is necessary to generate a C176 record for each invoice that will be used for credit.


The information in records C195 and C197 must also be declared following the entry codes for this operation determined by the State legislation, in this case the entry code SP10090719.

For the use of the credit balance of ICMS/ST reimbursement, the amount should also be posted in Record 1200:

In field 04: Value calculated corresponding to the total reimbursement using the adjustment code SP099719, in field 02

In field 06: Credit used in the period using adjustment code SP099719, in field 02;

And, in Record E111, it will contain the same value using adjustment code SP029719.


To generate record 1200, use the routine FISA034 – Tax Credit Control

Credit of the acquisition operation

The São Paulo legislation also provides, in article 271 of RICMS-SP, the use of ICMS credit from the purchase operation of the goods, that will be made based on the values of the inflow operation indicated in the outgoing tax document of by the amount of the sale operation that generated the right to reimbursement of ICMS.

In practical terms, the taxpayer can credit himself the value of the operation when the purchase of the goods is made from a tax substitute.

These values should be indicated in the ICMS/IPI EFD in record C197 under the codes SP10090721, only for operations that have the right to credit.

ICMS Calculation

The amount of the tax to be paid will be included in the ICMS Registration Book, as well as in the record of BLOCK E of the ICMS IPI EFD in the field related to credit adjustments arising from the tax document in the same period when the outgoing invoices were issued, following the positioning indicated in the entry code according to Table 5.3 of the SPED available in the SPED portal.

The amount calculated corresponding to the total reimbursement (adjustment code SP10090719), deducted from the amounts that were reversed as a return (SP50000319) shall be subject to the release of a credit reversal in the ICMS Calculation Record and in Block E of the ICMS IPI EFD, in the same period of tax calculation when the outgoing invoices were issued that gave rise to the right to reimbursement, using the adjustment code SP019319 (transfer of the balance calculated corresponding to the reimbursement of the tax withheld by tax substitution).

New fields were added to the C176 record to meet CAT No. 158 of December 28, 2015 

N

Field

Description

Type

Size

Dec

Infl.

Outflow

01

REG

Fixed text containing "C176"

C

004

-

No

O

02

COD_MOD_ULT_E

Tax document template code for the last inflow

C

002*

-

present

O

03

NUM_DOC_ULT_E

Tax document number for the last inflow

N

009

-


O

04

SER_ULT_E

Tax document series for the last inflow

C

003

-


OC

05

DT ULT E

Date relative to the last entry of the goods

N

008*

-


O

06

COD_PART_ULT_E

Participant code (the issuer of the last incoming document)

C

060

-


O

07

QUANT ULT E

Item quantity relative to last inflow

N

-

03


O

08

VL_UNIT_ULT_E

Unit value of the goods constant in the invoice relative to the last inflow, including ancillary expenses.

N


03


O

09

VL_UNIT_BC_ST

Unit value of the basis of calculation of the tax paid by substitution;

N

-

03


O

10

E-INV KEY ULT E

Complete e-Invoice key number for the last inflow

N

044*

-


OC

11

ITEM NUM ULT E

Sequential number of the item in the incoming invoice that corresponds to the goods that is the object of the claim for reimbursement

N

003



OC

12

UNIT VL CB ICM S_ULT_E

Unit value of the basis for calculating the sender's own operation under the common taxation system

N


02


OC

13

ICMS RATE ULT E

ICMS rate applicable to the last entry of the goods

N

-

02


OC

14

LIMIT UNIT VL CB_ICMS_ULT_E

Unit value of the ICMS calculation base for the last entry of the goods, limited to the CB value of the withholding (corresponds to the lowest value between the UNIT VL CB ST and UNIT VL CB ICMS ULT E) fields

N


02


OC

15

UNIT VL ICU U LT_E

Unit value of the ICMS credit on the sender's own operations, relative to the last entry of the goods, resulting from the breakdown of the ST - equivalent to multiplication between fields 13 and 14

N


03


OC

16

ST_RATE_ULT_E

ICMS ST rate relative to the last entry of the goods

N

-

02


OC

17

REIM_UNIT_VL

Unit value of the reimbursement (partial or complete) of ICMS resulting from the breakdown of the ST

N

-

03


OC

18

WITHH_RESP_COD

Code indicating the party responsible for the ICMS-ST withholding: 1- Direct Sender 2- Indirect Sender 3- Declarant

N

001*



OC

19

REIM_PUR_COD

Purpose code for reimbursement. 1 - Sale to another State; 2 - Outflow supported by exemption or non-incidence; 3 - Loss or deterioration; 4 - Theft or robbery 9 - Other

N

001*



OC

20

RET_EINV_KEY

Full number of the e-Invoice key issued by the substitute, which contains the value of the ICMS-ST

N

044*



OC

21

RET EINV PART COD

Participant code of the e-Invoice issuer in which there was withholding of the ICMS-ST - field 02 of record 0150

C

060



OC

22

RET_EINV_SER

e-Invoice series in which the withholding of ICMS-ST occurred

C

003

-


OC

23

RET_EINV_NO

Number of the e-Invoice in which the withholding of ICMS-ST occurred

N

009

-


OC

24

RET_EINV_ITEM

Sequential number of the item in the e-Invoice in which the withholding of the ICMS-ST occurred, which corresponds to the goods subject to a request for reimbursement

N

003



OC

25

DA_COD

Code of the payment document template : 0 - State payment template 1 - GNRE

C

001*



OC

26

NUM_DA

State payment document number, if any

C

-

-


OC


Credit of the acquisition operation

The São Paulo legislation also provides, in article 271 of RICMS-SP, the use of ICMS credit from the purchase operation of the goods, that will be made based on the values of the inflow operation indicated in the outgoing tax document of by the amount of the sale operation that generated the right to reimbursement of ICMS.

These values should be indicated in the ICMS/IPI EFD in record C197 under codes SP10090721.

ICMS Calculation

The amount of the tax to be reimbursed will be added to the ICMS Calculation Record, as well as in the record of BLOCK E of the ICMS IPI EFD in the same period in which the outgoing invoices were issued, following the position indicated in the entry code, as per SPED table 5.3 available on the SPED portal.

Composition of the fields for record C176

Following the request of the development department, we present a breakdown of the information that should be presented in the C176 record.

Field 01 (REG) – Record-opening field, content indicated C176.Field 02 (COD_MOD_ULT_E) – This field must contain the invoice template for the goods that are the object of reimbursement.

Field 03 (NUM_DOC_ULT_E) - This field must contain the invoice number of the goods that are the object of reimbursement. This amount is included in the Invoice for the last entry.

Field 04 (SER_ULT_E) - This field must contain the serial number of the incoming invoice of the goods that are the object of reimbursement. This amount is included in the Invoice for the last entry.

Field 05 (DT_ULT_E) - This field must contain the date of entry of the goods that are the object of reimbursement. This amount is included in the Invoice for the last entry.

Field 06 (COD_PART_ULT_E) - This field must contain the supplier code of the goods that are the object of reimbursement.This amount is included in the Invoice for the last entry, and the amount presented must have a corresponding record in the participants file.

Field 07 (QUANT_ULT_E) – This field must contain the quantity of the goods that will be subject to reimbursement.Remember that, if the last entry does not present enough balance to meet the demand of the outgoing document, the invoice immediately prior to this one can be used.

Field 08 (VL_UNIT_ULT_E) - This field must contain the unit value of the goods that are the object of reimbursement. This amount is included in the Invoice for the last entry.

Field 09 (VL_UNIT_BC_ST) – This field must contain the unit value of the ICMS ST calculation base of the goods that are the object of reimbursement. This amount is included in the Invoice for the last entry.

Field 10 (KEY_ULT_NFE) – This field must contain the key of the incoming electronic invoice of the goods that are the object of reimbursement.

Field 11 (NUM_ITEM_ULT_E) - This field must contain the sequential number of the goods that are the object of reimbursement in the incoming document.

Field 12 (VL_UNIT_BC_ICMS_ULT_E) - This field must contain the unit value of the calculation base of the sender's own operation under the common taxation system of the goods subject to reimbursement. This amount is included in the Invoice for the last entry and will be used as a basis for calculation for the provisions of Item 271 of RICMS/SP.

Field 13 (ALIQ_ICMS_ULT_E) - This field must contain the unit value of the calculation base of the sender's own operation under the common taxation system of the goods subject to reimbursement. This amount is included in the Invoice for the last entry and will be used as a basis for calculation for the provisions of Item 271 of RICMS/SP.

Field 14 (VL_UNIT_LIMITE_BC_ICMS_ULT_E) - This field, as a rule, must contain the unit value of the ICMS ST calculation base of the goods subject to reimbursement. If the invoice supplier for the last entry is a tax substitute, the ICMS value of the transaction of the incoming invoice will be entered. If the supplier is replaced, this field will repeat the value displayed in field 09 or the value displayed in field 12, and the lowest value should be displayed.

Field 15 (VL_UNIT_ICMS_ULT_E) - This field, as a rule must, contain the unit value of the ICMS of the goods subject to reimbursement. If the invoice supplier for the last entry is a tax substitute, the ICMS value of the operation of the incoming invoice will be entered. If the supplier is replaced, this field will be the result of multiplication between fields 13 and 14.

Field 16 (ALIQ_ST_ULT_E) - Enter the internal rate of the product, to be applied in the ICMS ST calculation.Field 17 (VL_UNIT_RES) - Completion: Unit value highlighted in the incoming tax document as ICMS ST, or unit value of ICMS ST entered as a refund. The value of this field must match the multiplication of fields 09 and 16.

Field 18 (COD_RESP_RET) – Indicates who is responsible for the ICMS ST withholding:Direct Issuer: When the responsibility is of the sender of the goods;Indirect sender: In operations made with substitute;Own declarant: Anticipation operations;

Field 19 (COD_MOT_RES) – A code with the purpose of the reimbursement must be displayed, following the field's indicative table.

Field 20 (KEY_NFE_RET) - Enter the key of the invoice where the ICMS-ST has been withheld. In this case, the key of the electronic invoice in which the ICMS ST was collected should be presented. In this case, the invoice of the operation substitute. This field should be entered when field 18 has content equal to indirect sender and should display the information of the indirect sender.

Field 21 (COD_PART_NFE_RET) – Enter the participant code of the e-Invoice where the ICMS-ST was retained.In this case, the data of the electronic invoice supplier in which the ICMS-ST was collected should be presented. This field should be entered when field 18 has content equal to indirect sender and should display the information of the indirect sender.

Field 22 (SER_NFE_RET) - Enter the series of the e-Invoice where the ICMS-ST has been retained. In this case, the electronic invoice series in which ICMS ST was collected should be presented. This field should be entered when field 18 has content equal to indirect sender and should display the information of the indirect sender.

Field 23 (NUM_NFE_RET) - enter the number of the e-Invoice where the ICMS-ST was retained. In this case, the electronic invoice number in which ICMS ST was collected should be presented. This field should be entered when field 18 has content equal to indirect sender and should display the information of the indirect sender.

Field 24 (ITEM_NFE_RET) - Enter the item of the goods subject to reimbursement of the e-Invoice in which the ICMS-ST was withheld. In this case, the electronic invoice series in which ICMS ST was collected should be presented. This field should be entered when field 18 has content equal to indirect sender and should display the information of the indirect sender.
 

02.  DEPLOYMENT PROCEDURE

 
In order for the next fields and parameters required for processing to be created automatically, the UPDFIS compatibility tool was made available.


(Only for Microsiga Protheus versions prior to 12)

Before running the UPDFIS compatibility tool, you must:

Backup the product database where the compatibility tool will run (directory \PROTHEUS11_DATA\DATA) and the SX data dictionaries (directory \PROTHEUS11_DATA\SYSTEM).

The directories mentioned above correspond to the standard installation of Protheus. Therefore, they must be changed according to the company's installation environment.

This routine should be run in exclusive mode and no user should be on the system..

If data dictionaries have customized indexes (created by the user), before running the compatibility tool, make sure they are identified by nickname. If the compatibility tool needs to create indexes, it will add them from the original order installed by Protheus, which can overwrite customized indexes if they are not identified by nickname.

The compatibility tool must be run with the Referential Integrity deactivated*.

Important

Notice

The following procedure must be performed by a qualified professional, such as a Data Base Administrator (DBA) or equivalent!

The erroneous activation of the Referential Integrity can drastically change the relationship between tables in the database. Therefore, before using it, note the procedures as follows:

In the Configuration Tool (SIGACFG), check if the company uses Referential Integrity by selecting the option Integrity/Checking (APCFG60A).

If no active Referential Integrity exist, all the companies and branches registered for the system are listed in a new window, and none of them is selected. In this case, AND ONLY IN THIS CASE, you do not need any other activation/deactivation integrity procedure; just finish the checking the apply the compatibility tool according to instructions.If there is active Referential Integrity in all companies and branches, a message in the window for checking the relationship between tables is displayed. Confirm the message to complete the checking, or;

If a Referential Integrity is active in one or more companies, though not in all of them, all companies and branches registered for the system are listed on a new window, in which only those with integrity are selected. Write down which companies or branches have the integrity activated and save this note for later reference on reactivation (you may also contact our Framework Help Desk for a file with this information).

In the cases described in the items iii or iv, AND ONLY IN THESE CASES, you must deactivate such integrity by selecting option Integrity/Deactivate (APCFG60D).

When the Referential Integrity is deactivated, run the compatibility tool according to instructions.

After applying the compatibility tool, the Referential Integrity must be reactivated, IF AND ONLY IF it has been deactivated, using option Integrity/Activate (APCFG60). For this reason, have in hands the information of companies and/or branches that have integrity activation, select them again and confirm the activation.


In case of any questions, contact the Framework Help Desk.


 
In the Microsiga Protheus TOTVS Smart Client, enter U_UPDSIGAFIS in the Initial Program field.

Click OK to continue.

After the confirmation, either a screen to select the company where the data dictionary will be modified or the window for selecting the compatibility tool is displayed. Select the U_UPDSIGAFIS program.

After confirming, a warning message is displayed about the backup and the need of its run in exclusive mode.

Click Process to start processing. The first run step is file preparation.

An explanatory message is displayed on screen.

Afterwards, an Update complete window is displayed with all the history of updates processed (log). In this update log, only the fields updated by the program are presented. The compatibility tool creates the fields that do not exist on the data dictionary yet.

Click Save to save the history (log) displayed.

Click OK to end processing.

Menu Settings

In the Configuration Tool (SIGACFG), access Environment/Files/Menus and add, to the menu of the Tax Records module (SIGAFIS), the option to execute the File as specified below:

Menu

Updates

Submenu

SPED

Routine Name

ICMS-ST Reimbursement

Program

FISA132

Module

09

Type

01

Tables

CD0

Compatibility Tool Updates

SIX - Indexes

CD0 - Compl. of Reimbursement Invoice

Order

Key

Description

1

CD0_FILIAL+CD0_TPMOV+CD0_SERIE+CD0_DOC+CD0_CLIFOR+CD0_LOJA+CD0_ITEM+CD0_COD+CD0_DOCENT+CD0_SERENT+CD0_ESPECI+CD0_FORNE+CD0_LOJENT+CD0_ID

Transaction Type + Invoice Series + Invoice Number + Cust./supp. + Store + Item + Cod + Doc ent + Ent Series + Kind + Supplier + Supplier Store + ID

2

CD0_FILIAL+CD0_TPMOV+CD0_SERIE+CD0_DOC+CD0_CLIFOR+CD0_LOJA+CD0_ITEM+CD0_COD+CD0_DOCENT+CD0_SERENT+CD0_ESPECI+CD0_FORNE+CD0_LOJENT+CD0_ITENFE

Transaction Type + Inv. Series + Inv. Number + Cust./supp. + Store + Item + Cod + Doc ent + Ent Series + Kind + Supplier + Supplier Store + Item Incoming Inv.

SX2 – Tables

Table

Description

Key

CD0

Compl. of the Reimbursement Invoice

CD0_FILIAL+CD0_TPMOV+CD0_SERIE+CD0_DOC+CD0_CLIFOR+CD0_LOJA+CD0_ITEM+CD0_COD+CD0_DOCENT+CD0_SERENT+CD0_ESPECI+CD0_FORNE+CD0_LOJENT+CD0_ID

SX3 – Fields

Table CD0 - Compl. of Reimbursement Invoice:
 

Field

CD0_CHVNFE

Type

Character

Length

2

Decimal

0

Format

@!

Title

e-Invoice Key

Description

e-Invoice Key

Used

No

Mandatory

No

Browse

Yes

Context

Real

Help

e-Invoice SEFAZ key

  

Field

CD0_ITENFE

Type

Character

Length

4

Format

@!

Title

Inc. Invoice Item

Description

Incoming Invoice Item

Used

Yes

Mandatory

No

Browse

Yes

Help:

Sequential number of the item in the incoming invoice that corresponds to the goods that is the object of the claim for reimbursement 

  

Field

CD0_VLUNOP

Type

Numeric

Length

14

Decimals

2

Format

@E 99,999,999,999.99

Title

Pr. Op Base

Description

Unit Vl.Base Prop.Oper.Calc

Used

Yes

Mandatory

No

Browse

Yes

Help:

Sequential number of the item in the incoming invoice that corresponds to the goods that is the object of the claim for reimbursement 

Field

CD0_PICMSE

Type

Numeric

Length

6

Decimals

2

Format

@E 999.99

Title

ICMS Rate

Description

Incoming ICMS Rate

Used

Yes

Mandatory

No

Browse

Yes

Validation

Positive()

Help:

ICMS rate applicable to the last entry of the goods

Field

CD0_ALQSTE

Type

Numeric

Length

6

Decimals

2

Format

@E 999.99

Title

ICMS-ST Rate

Description

Incoming ICMS-ST Rate

Used

Yes

Mandatory

No

Browse

Yes

Validation

Positive()

Help:

ICMS ST rate relative to the last entry of the goods

Field

CD0_VLUNRE

Type

Numeric

Length

14

Decimals

3

Format

@E 9,999,999,999.999

Title

Reim.Unit.Vl.

Description

Unit value of reimbursement

Used

Yes

Mandatory

No

Browse

Yes

Validation

Positive()

Help:

Unit value of the reimbursement (partial or complete) of ICMS resulting from the breakdown of the ST

Field

CD0_RESPRE

Type

Character

Length

1

Format

@!

Title

Res. Withholding

Description

Responsible for the withholding of ICMS-ST

Used

Yes

Mandatory

No

Browse

Yes

Validation

Belong("123")

Options:

1=Direct Sender;2=Indirect Sender;3=Own taxpayer

Help:

Indicate the party responsible for ICMS-ST withholding

Field

CD0_MOTRES

Type

Character

Length

1

Format

@!

Title

Reimb. Purp.

Description

Code of reimbursement purpose

Used

Yes

Mandatory

No

Browse

Yes

Validation

Belong("12349")

Options:

1=Sale to another State;2=Exit by exemption or non-incidence;3–Loss or deterioration;4=Theft or robbery;9=Other

Help:

Code of reimbursement purpose

 

Field

CD0_CHNFRT

Type

Character

Length

44

Format

@!

Title

e-Invoice W Key

Description

Withholding e-Invoice key

Used

Yes

Mandatory

No

Browse

Yes

Help:

Number of the e-Invoice key issued by the substitute, in which the value of the withheld ICMS-ST appears

  

Field

CD0_PANFRT

Type

Character

Length

6

Format

@!

Title

Partic. Store

Description

Store code of party responsible for withholding

Used

Yes

Mandatory

No

Browse

Yes

Validation

Vazio() .Or. ExistCpo("SA2",M->CD0_PANFRT+M->CD0_LJPANF)

Field Group

002

Help:

Store code of e-Invoice issuer participant where the ICMS-ST was withheld.

Field

CD0_SRNFRT

Type

Character

Length

3

Format

@!

Title

Withh. Inv. Series

Description

Withholding Invoice Series

Used

Yes

Mandatory

No

Browse

Yes

Help:

e-Invoice series in which the withholding of ICMS-ST occurred

  

Field

CD0_BSULMT

Type

Numeric

Length

14

Decimal

2

Format

@E 99,999,999,999.99

Title

Limit.Un.Bs

Description

Limited base

Used

Yes

Mandatory

No

Browse

Yes

Validation

Positive()

Help:

Unit value of the ICMS calculation base for the last entry of the goods, limited to the CB value of the withholding

  

Field

CD0_VLUNCR

Type

Numeric

Length

14

Decimal

3

Format

@E 9,999,999,999.999

Title

ICM Cred.Vl.

Description

ICMS Credit Unit vl.

Used

Yes

Mandatory

No

Browse

Yes

Validation

Positive()

Help:

Unit value of ICMS credit on sender's own operations, relative to the last entry of the goods, resulting from the breakdown of the ST

 

Field

CD0_ITNFRT

Type

Character

Length

4

Format

@!

Title

Withh. Inv. Item

Description

Item of Withholding Invoice

Used

Yes

Mandatory

No

Browse

Yes

Help:

Sequential number of the item in the e-Invoice in which the withholding of the ICMS-ST occurred, which corresponds to the goods subject to a request for reimbursement

  

Field

CD0_LJPANF

Type

Character

Length

1

Format

@!

Title

Withh.Part.Res.

Description

Code of reimbursement purpose

Used

Yes

Mandatory

No

Browse

Yes

Validation

ExistCPO("SA2")

Standard Query:

SA2

Field Group

001

Help:

Participant code of the e-Invoice issuer in which the ICMS-ST was withheld

Field

CD0_CODDA

Type

Character

Length

1

Format

@!

Title

DA Code

Description

Collection Doc. Code

Used

Yes

Mandatory

No

Browse

Yes

Validation

Belong("01")

Options:

0=State document of collection;1=GNRE

Help:

Code of the collection document template

 

Field

CD0_NUMDA

Type

Character

Length

12

Format

@!

Title

DA Number

Description

Collection Doc. Number

Used

Yes

Mandatory

No

Browse

Yes

Help:

State collection document number

 

Field

CD0_METINC

Type

Character

Length

1

Format

@!

Title

Method

Description

Method of inclusion

Used

Yes

Mandatory

No

Browse

Yes

Help:

Indicate who created record: 0 - Online System 1 - Calculation

Field

CD0_ID

Type

Character

Length

36

Format

@!

Title

Key

Description

Key

Used

No

Reserved

Yes

View

Yes

Browse

Yes

Relation

FWUUID("MATA926")

Field

CD0_FCPST

Type

Numeric

Length

14

Decimal

3

Format

@E 9,999,999,999.999

Title

Val. FCP ST

Description

FCP-ST Unit Value

Used

Yes

Mandatory

No

Browse

Yes

Validation

Positive()

Help:

Unit value of the reimbursement (partial or complete) of FCP resulting from the breakdown of the ST


 SX6 - Parameters


Variable Name

MV_CODRESS

Type

Character

Description

Enter the Entry Codes for the Reimbursement Value and Credit Value

Default Value

{"SP10090719","SP10090721"}

Variable Name

MV_DEVRESS

Type

Character

Description

Enter the Entry Codes for the Return of the Reimbursement Value for CAT158/2015 of Sao Paulo

Default Value

{"SP50000319","SP50000321"}

 

Variable Name

MV_TPRESS

Type

Logical

Description

Set the search method of Incoming Invoices for CAT158. (.F.)= Always use the last entry (.T.) = Search unused incoming invoices

Default Value

.F.

Variable Name

MV_MOTPERD

Type

Character

Description

Indicate which CFOPs should generate the reimbursement purpose as: 3 – Loss or deterioration;– Theft or robbery

Variable Name

MV_MOTROUB

Type

Character

Description

Indicate which CFOPs should generate the reimbursement purpose as: 4 – Theft or robbery

Variable Name

MV_CALCRED

Type

Logical

Description

Define whether to credit ICMS in incoming operations that do not have ICMS calculation.  (.T.) = Calculate credit, (.f.) = Do not credit  

Default Value

.T.

 
When this parameter is disabled, ICMS credit calculation will not be processed for incoming invoices that have no ICMS base and value.
 
 

03. USAGE PROCEDURE

Invoice entitled to reimbursement

TIO Registration

For the system to identify the CAT 158 situation, option I - Reimbursement was added to the reflex file.

A Reflex Code must be registered with the following configuration:

Basis for calculation = Zero

Rate = Zero

Value = I (Reimbursement)

Bind reflex to the outflow TIO that will be used and Register in the ICMS calculation entries:

According to CAT 158, codes have been recommended:
Entry Code SP10090719 (Reimbursement Value)

Entry Code SP10090721 (Credit Value)

The fields below must be filled in for C197 registration to be processed in the TAX SPED EFD file:

Tax Entry Note (CC7_IFCOMP) = Information from CCE table record

The field Tax Entry Note (CC7_IFCOMP) may be filled in the TIO registration or in the complement of the invoice in routine

MATA910/MATA920 – Option Additional information, field Compl. Info (CDT_IFCOMP)

Setting parameters for reimbursement:

To set reimbursement codes, use parameter: MV_CODRESS

Important:

When the same adjustment code for ICMS credit and ICMS ST reimbursement is entered, values will be added to compose adjustment code.

Sales Return

TIO Registration

For Return invoices, set up reflex TIO option I - Reimbursement according to outgoing invoices.
Basis for calculation = Zero

Rate = Zero

Value = I (Reimbursement)

Voucher Code SP50000319 - Deduction of tax replacement reimbursement by establishment of a replaced taxpayer (Articles 269 and 270 of RICMS/2000), at entry by return or return of the goods

Entry Code SP50000321 - Credit refund of ICMS related to the sender's own operation, previously appropriate according to article 271 of RICMS/2000, at entry by return of the goods.

The fields below must be filled in for C197 registration to be processed in the TAX SPED EFD file:

Tax Entry Note (CC7_IFCOMP) = Information from CCE table record

The field Tax Entry Note (CC7_IFCOMP) may be filled in the TIO registration or in the complement of the invoice in routine MATA910/MATA920 – Option Additional information, field Compl. Info (CDT_IFCOMP)

Setting parameters for reduction of reimbursement:

To define reimbursement deduction codes, use parameter: MV_DEVRESS

Reimbursement calculation - CAT158At the end of the period, the user of the tax management module can perform the ICMS-ST Reimbursement routine (FISA132) that binds all the outgoing invoices of the period that have been configured for the calculation of the reimbursement with the incoming invoices at once.

Important:

During sales order, the reimbursement value will not be demonstrated in the financial sheet, in the entry tab of the ICMS calculation, because the routine will only calculate reimbursement during calculation. But, at this time, the adjustment code will be added to the CDA table as registered in TIO with reflex code for ICMS ST reimbursement.

During the calculation process, tables CD0 and CDA will be filled with the reimbursement value.

Important

For the calculation of previous periods, it is necessary to reprocess the outgoing documents (using routine MATA930 - Reprocessing of Tax Records) after the TIO configuration, so that the CDA table is generated correctly. Otherwise, the routine will not be able to complete the processing.

Important

The system does not consider incoming invoices with CFOP finished in "102" - Purchase of goods taxed because they do not have the right of reimbursement and credit.

The exception to this rule is for incoming invoices with CFOP 3102 and CST equal to 10, 30, 60, and 70 which, in this case, will be considered.

Invoices for internal transfer between branches are not considered.

Internal sales outgoing invoices for final consumer are not considered.

Reimbursement purpose

The system considers reimbursement purposes based on the following rule
1 – Sale to another State;

operations with CFOP started by "6"


2 – Output supported by exemption or non-incidence;

Operations in which the ICMS record in the TIO is configured different from Taxed


3 – Loss or deterioration;– Theft or robbery;

Is determined by the CFOP of the outgoing invoice item and the MV_MOTPERD parameter.


4 – Theft or robbery

Is determined by the CFOP of the outgoing invoice item and the MV_MOTROUB parameter.


5 – Export

Operations with CFOP started by "7"


9 – Others
When it does not fit in the above validations.


When the CFOP is found in the MV_MOTPERD or MV_MOTROUB parameter, purpose 3 or 4 will be applied.
In 2017, no option 5 - Export exists, option 9 - Others is used.

Incoming invoices with ICMS collected earlier

For the incoming invoice where the ICMS ST has already been collected previously, the collected value and base must be in the additional information of the incoming invoice issued by the supplier.

When entering an invoice into the system, the following fields must be manually filled in: D1_BASNDES (Prev. Coll. ICMS-ST Base) based on ICMS ST and D1_ICMNDES (ICMS ST value previously collected) with value calculated and collected previously.

The ICMS ST reimbursement calculation routine (FISA132) uses these fields in operations where the ICMS ST was not calculated in the incoming invoice.

Incoming invoices with ICMS previously collected with FECP

For the incoming invoice where the ICMS ST has already been collected previously, the collected value and base must be in the additional information of the incoming invoice issued by the supplier.

When entering an invoice in the system, the following fields must be manually filled in: D1_VFCPANT (FCP value prev. coll.) with value calculated and collected previously.

The ICMS ST reimbursement calculation routine (FISA132) uses this field to compose the FECP value and fill field CD0_FCPST (FCP ST Unit Value)

Incoming invoice without calculation of local ICMS

When the incoming invoice has no basis of calculation of the local ICMS, at the time of calculation of the reimbursement of the ICMS ST and credit of the ICMS, the value of the operation for calculation of the local ICMS is used to take credit.
It is possible to disregard credit from the local ICMS using the MV_CALCRED parameter.

Supplement of the reimbursement by invoice

It is possible to supplement the invoice at the entry time using the ATUCOMP entry point.

Activate the MV_ATUCOMP parameter to automatically update the SPED tax document complementary tables

For questions on the registration of reflexes in the TIO, follow the documentation.


04. REPORT

Reimbursement Report (FISR132)

This report shows outgoing invoices and their respective reimbursement supplements corresponds to table CD0.

In the report, credit and compensation values of ICMS per invoice will be printed, already applying the weighted average method when more than one incoming invoice exists to compose the quantity sold.

Tax Entry Report

Tax Entry Report (FISR025) to demonstrate the tax entries of ICMS calculation for incoming and outgoing documents.

 

05. TECHNICAL INFORMATION


Tables

CD0 - Compl. of Reimbursement Invoice

Routines Involved

SPEDFISCAL - Tax SPED EFD

MATA926 - Invoice Complement