...
Aviso | ||
---|---|---|
| ||
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 | ||
---|---|---|
| ||
For more information about adding routines to the menu: PSIGABD0006 - Adding a routine to the menu |
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 | ||
---|---|---|
| ||
|
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.
...
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:
...
...
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 | ||
---|---|---|
| ||
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. |
...
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.
...
Expandir | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||
|
...