Páginas filhas
  • SCRESST - Calculation for reimbursement, refund, and complement of ICMS - SC

Versões comparadas

Chave

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

...

Aviso
titleImportant

For this implementation, it will be necessary to run the UPDDISTR compatibility tool with the data dictionary differential available, even if the emergency package available in 04/2019 was already executed because new updates are available in the link below.

If you run UPDDISTR again with the new package available, pay attention to the decimal sizes of the value fields of tables F1J/F1K/F1L/F1M. Make sure they are as specified in Dictionary Updates. Otherwise, rounding problems may occur in the values determined. If this is the first execution, this procedure is not required, as the fields will be created with the correct sizes.

For more information about UPDDISTR, see Dictionary and Database Updater - UPDDISTR

The file with the differential data dictionary compatible with versions 11.80, 12.1.17, and 12.1.23 is available through the link: https://suporte.totvs.com/portal/p/10098/download#detail/739772

...

Aviso
titleImportant
For more information about adding routines to the menu: PSIGABD0006 - Adding a routine to the menu


 

04. USAGE PROCEDURE

When accessing routine FISA230, the main process screen appears. The menu located on the left lists the routines related to the calculation and generation of the file in question, detailed later, and, on the right side, the calculations already made are listed:
 

...

Nota
titlePre-conditions
  • The parameter MV_SCINIRC must be correctly filled with the periods for calculating the refund, the reimbursement, and the complementation, as provided for in the current legislation;
  • The MV_DRCIREG parameter must be correctly filled with the effective dates of the records: 2115, 2133, 2121, and 2134, given by SEF Ordinance 378/2018.
  • The MV_DRCCDAJ parameter must be properly filled in so that the 24-COD_DA/25-NUM_DARE/26-COD_AJ fields of Record 2130 are generated correctly;
  • The rules for transactions must be properly registered/configured;
  • The products involved in the transactions that can be calculated must have the ICMS-ST Cont. (B1_CRICMST) field set to 1-Yes; otherwise, they will be disregarded;
  • In the hypothesis of a 70% reduction in the MVA in internal operations intended for companies that opted for the Simples Nacional, the products listed in Chapter VI of Title II of Annex III of the RICMS-SC must have the field Reimb.Sale.SN (F2Q_REVSN) set to 1-Yes. This field is located in the product tax supplement (Table F2Q). To enable the tax supplement in the product registration: PEST018 - MV_CADPROD - Parameter to inform which additional records should be presented in the product record;
  • The closing of the stock of the period to be calculated must be carried out. For further information, refer to: PEST05502 - MATA280 - Script to perform the stock balance carry forward;
  • The P7 Inventory Record export file (the same one used for ICMS IPI EFD block H) corresponding to the calculation period should be generated. For further information, refer to: How to generate Block H of the Tax Sped;

For more information about filling out the parameters used by the routine, see the Dictionary Updates section.
 
The routine parameterization screen will be displayed next. The fields below must be entered on it:
 

...


 
 
After the processing is finished, the routine returns to the main screen, where the newly performed calculation will be available for viewing in the list of calculations already made. The values displayed in the calculation preview screen can be checked in detail through the Checking Report.
 
 

...

Incoming Tax Booking

The data source for the calculation routine, both for incoming and outgoing transactions, is the SFT table. For the incoming transactions, however, it is necessary to pay attention to the correct bookkeeping of the values of Local ICMS and ICMS-ST, since these values compose a weighted average that will be applied to the total outgoing quantities for each hypothesis of reimbursement, directly influencing the values to reimburse or complement:

  • Acquisitions of Tax Substitute: For this type of transaction, the following fields must be filled in: FT_BASERET, FT_ALIQSOL, FT_ICMSRET;
  • Acquisitions of Tax Substituted: For this type of transaction, the following fields must be filled in: FT_BASNDES, FT_ALQNDES, FT_ICMNDES, referring to the base that served as withholding in the previous operation.  Such transactions must be carried out with CST 60- ICMS charged previously for tax substitution. Pay attention to the composition of Records 2120 and 2121.

 
 

...

Entry Point FSA231UND 

...

In this type of printing, the weighted averages of the Local ICMS, ICMS-ST, and ICMS-ST calculation basis will be demonstrated by the product, obtained through the inflow transaction of the period determined. It is important to emphasize that, due to the effects of SEF Ordinance 343/2019, which instituted Record 2121, the calculation may calculate two different weighted averages for the ICMS-ST calculation basis: One in the already existing record 2120 and another in the new record 2121. The two averages will be displayed in the report, but the calculation is performed using only one of the two calculated averages, according to criteria set by SEF Ordinance 378/2018. Some notes on these two records are also available in the Records 2120 and 2121 topic.
 
It also demonstrates these averages applied to the total outflow, thus generating, for each product, the value of reimbursement and supplement of tax (in cases of internal outflows to the final consumer), through the Reimbursement Vl. and Complement Vl. fields, and Compensation Vl. (interstate and internal outflows to companies opting for the Simples Nacional), through the ICMS-ST Out. St. Vl. and SN Cred Vl. fields. The credit value of ICMS on local transactions will be demonstrated through the ICMS Out. St. Vl. field.
 
Example of a report by transaction:

...

 
The Checking Report has, as its data source, the calculation tables F1J, F1L, and F1M
 
To check the calculation shown in the images above, check the example provided.
 

Aviso
titleImportant
We recommend using the Checking Report in spreadsheet format due to the amount of information displayed; however, if there is a need for printing in the File, HTML, or PDF formats, and it presents inconsistencies in the visualization of information due to the amount of information exceeding the entire print area, we suggest that the Report Customization be used to avoid any self-sizing problem. 

...

  • 1 - Direct sender
  • 3 - Declarant themselves
  • 2 - Indirect Sender, provided that it indicates, in the NF-e XML, the information related to the ICMS previously charged for tax substitution in the tag specified for the ICMS Taxation Group = 60, in the vBCSTRet and vICMSSTRet fields. For the tax document to be classified in this condition, the values contained in these tags must be registered in the fields D1_BASNDES and D1_ICMNDES. Pay attention to the Incoming Tax Bookkeeping item.

 
On the other hand, record 2121 contains all the inflows present in its child records 2130, regardless of the contents of the field 08 COD_RESP_RET of these records, and contains only the weighted average of the ICMS-ST calculation base.
 
It should be noted, therefore, that within the same period, it is possible to have these 2 records generated, and then we will have two weighted averages of the ICMS-ST calculation base as provided for in the Ordinance itself, which establishes some criteria for the decision of which average should be used. Essentially:

...


 
In this example, the value to be reimbursed is greater than the value to be supplemented. For this reason, there is compensation, and, therefore, no value exists to be supplemented. There remains a positive balance of 590.39, which can be verified in the calculation results.
 

...

05. DICTIONARY UPDATES


Expandir
titleParameters

Variable Name

MV_SCINIRC

Type

Character

Description

For the calculation of ICMS-ST reimbursement in the form of DRCST/SC, inform, in that order, the start date: Restitution, complement, reimbursement

Default Value

05/04/2017,01/01/2019,01/02/2019

 
 
 

Variable Name

MV_DRCCDAJ

Type

Character

Description

Enter the ICMS-ST debit adjustment codes withheld in the inflows by the taxpayer themselves for the generation of the COD_AJ field of the 2130 record.

Default Value

Blank

 
The entered adjustment codes must be separated by commas. Example: SC71000001,SC41000001,SC41000002.
 

Var. Name

MV_DRCIREG

Type

Character

Description

To determine the calculation of the ICMS-ST Reimbursement in the form of DRCST/SC, enter, in this order, the effective date of Rec. 2115, 2133, 2121, 2134

Content

07/16/2019,07/16/2019,10/31/2019,10/31/2019

...