Páginas filhas
  • APUICM - ICMS Calculation - MATA953 - Tax Management - P12

Versões comparadas

Chave

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

...

Deck of Cards
effectDuration0.5
historyfalse
idsamples
effectTypefade
Card
defaulttrue
id1
labelParameter configuration for generating the calculation

Generating the ICMS Calculation

  1. In ICMS Calculation, click Parameters and fill out data according to the field help instructions.
  2. Adjust the data in accordance with the instructions described in item Main Fields.
  3. Check and confirm data.
  4. Repeat the confirmation, and the system displays a new screen subdivided into tabs:
    • ICMS - Inflows
    • ICMS - Outflows
    • ST - Inflows
    • ST - Outflows
    • ICMS calculation
    • ST calculation
    • Additional Information
    • Calculation-Fomentar

See also the features available in Other Actions.

Card
defaulttrue
id2
labelICMS - Inflows

Tab - ICMS inflows

This tab presents the summary of the incoming invoices organized in columns, totalized, and sorted by CFOP.

Card
defaulttrue
id3
labelICMS - Outflows

Tab - ICMS Outflows

This tab shows the summary of the outgoing invoices organized in columns, totalized, and sorted by CFOP.

Card
defaulttrue
id4
labelST - Inflows

Tab - ST inflows 

This folder displays the totalization of the Calculation Basis and the Tax Credited, by State, of the interstate inflows of products under the Tax Substitution system.

Card
defaulttrue
id5
labelST - Outflows

Tab - ST Outflows

This folder displays the totalization of the Calculation Basis and the Tax Debited, by State, of the interstate inflows of products under the Tax Substitution system.

Card
defaulttrue
id6
labelCalculation - ICMS

Tab - Calculation - ICMS

The data is presented in columns containing:

Row, Code, Description, Value, GNRE, and Expiration Class.

Card
defaulttrue
id7
labelCalculation - ST

Tab - Calculation - ST

The data is presented in columns containing:

Row, Code, Description, Value, GNRE, and Expiration Class.

Card
defaulttrue
id8
labelAdditional Information

Tab - Additional Information

This folder displays the following values related to the ICMS:

015 - ICMS Withheld

(Outflows-Returns)

A total of the ICMS withheld in return transactions.

016 - Additional ICMS (Tax Rate Differential)

This corresponds to the differential of rates to enter in the ICMS Calculation, local operations, in the Other Debits/Other Credit rows, as needed.

When a debt balance exists, the fields Tax Maturity Date and Collection Agency are enabled. The Notes field is always enabled.

 017 - ICMS Withheld

(Sales Returns)

A total of the ICMS withheld is displayed in the Outflow Return transactions.

018 - ICMS Deferred

The values related to the ICMS Deferred are displayed in documents with TIO indicating the deferral calculation.

019 - Complementary ICMS

Fixed Assets

This displays the calculated Complementary ICMS value related to the inflow of fixed assets.

020 - Complementary ICMS

(Use or Consumption Mat.)

The complementary ICMS calculated value related to material for use and consumption is displayed.

021 - Credit Transf.

This displays the values related to ICMS credit transfer in documents with TIO indicating the transfer.

022 - Debt Transf.

This displays the values related to ICMS debt transfer in documents with TIO indicating the transfer.

023 - Mutual ICMS Credit

Displays the value of the ICMS Solidario, only when the question Print ST Credit? is set to Yes.

In this case, only inflows with TIO indicating the Tax Substitution credit are summed.

024 - Incentive Credit

The value calculated related to the State of Manaus Incentive Credit is displayed.

The value is automatically entered into Other Credits when using the P9AUTOTEXT.AM autofill file; otherwise, the value must be manually entered.

025 - Presumed Credit

The value calculated referring to the Presumed Credit calculation of the State of Rio de Janeiro is displayed. This value is automatically entered into Other Credits when using the P9AUTOTEXT.RJ autofill file; otherwise, the value must be manually entered.

 We also see on this screen the Tax Due Date, the Collecting Agency, and the space for Notes.

Card
defaulttrue
id9
labelDIFAL / FECP

Tab - DIFAL/FECP

This tab shows the data displayed in columns: Status, DIFAL to be collected, Credit DIFAL Balance, FECP to be collected, Credit Balance, and FECP/Special Debits.

Card
defaulttrue
id10
labelSpecial Debits

Tab - Special Debits

This tab displays the data in columns: Row, Code, Description, Value, GNRE/Maturity Class.

Card
labelExtra Calculation Credit

Setup Procedure 

Fill in the information in the Extra Calculation Credits tab of the Calculation Entry routine (MATA964) or Invoice Entry (MATA985), verifying that the Credit Usage Code and Credit Adjustment Code fields are properly filled in.

Usage procedures

  1. In SIGAFIS, access the ICMS calculation routine (MATA953) using the menu Miscellaneous->Calculations->ICMS Calculation.
  2. Fill in the initial questions of the routine and confirm the calculation processing.
  3. When you complete the calculation, check that, now, the new Extra Credits tab
  4. In this tab, codes for Extra Calculation Credits will be displayed, with the totalizers of the following values:
    1. Balance of tax credits from previous periods
    2. Total credit appropriated in the period
    3. Total credit received by transfer
    4. Total credit used in the period
    5. Accumulated tax credit balance to be carried forward to the following period

5. When you double-click the row of the code, the details of the amounts will be displayed, separated by the sections Credit Receipt, Receipt by Transfer, and Credit Usage.

6. In this detailed Extra Calculation Credits screen, we have the following values:

    1. A row identifying the section, where 0001 is credit receipt, 0002 is receipt by transfer, and 0003 is use
    2. Type of credit use as defined in the ICMS/IPI EFD layout
    3. Code value, as per the row section;
    4. Number of the document that originated this value (if any);
    5. Electronic invoice key that originated this value (if any);
    6. Source entry code that originated this value(if any)
    7. Type of entry, which can be Individualized Automatic, Grouped Automatic, or Manual

7. To return to the consolidated screen, simply double-click the row that contains the

<<<—RETURN

<<<— RETURN description to display the consolidated screen again.

8. When the calculation is completed, this information will be recorded in table CE5 with the details of the values, and also in table CE6 with the consolidated balances

Inclusion of manual rows of extra calculation credits

The inclusion of manual information in this tab can be done in two ways:

1 - Manual inclusion directly in the Extra Calculation Credits tab

On the consolidated screen, via using the Add Row button available in Other Actions, a new row will be added on the screen, and you will need to enter an entry code corresponding to MV_ESTADO UF with the fourth digit equal to 9.

Once a valid code has been entered, it will be possible to access the detailed calculation by double-clicking this new row.

In the detailed screen, you can also add rows in the Receipt, Receipt by Transfer, and Usage sections using the Add Row button available in Other Actions. When a new row is manually added on this screen, the entry type will be identified with the M - MANUAL description, and the credit usage type code and the value must be entered. The balances will be updated automatically. 


2- Manual inclusion in the other tabs of the calculation

Another way to include manual information in this tab is through the manual inclusion of entry codes in the tabs ICMS-Calculation, ST-Calculation, DIFAN/FECP, and Special Debits. If an entry code is manually added to any of these 4 tabs, and this code has a linked Credit Adjustment Code, a new row will also be automatically added to the Extra Calculation Credit tab with the same amount. In short, when an entry code exists linked to a Credit Adjustment Code, the row additions, edits, and deletions will also take effect in the Extra Calculation Credits tab.


Automatic Rows of Extra Calculation Credits

The information may also come automatically to this tab. This will occur when a voucher code is used in the tax document and recorded in the CDA table, which in turn has a Credit Adjustment Code linked, that is, the codes automatically loaded in the ICMS-calculation, ST-calculation, DIFAL/FECP, and Special Debits tabs, which have a linked Credit Adjustment Code will also be automatically loaded in this tab of the calculation. The entry type of the automatic rows may be AI - INDIVIDUAL AUTOMATIC when the adjustment code is individualized, or A - GROUPED AUTOMATIC when the code is configured as grouped.


Card
labelGNRE and bill generation by calculation

Procedures for Configuration

To generate Forms and Bills via calculation, it is necessary to configure some parameters. 

In the Configuration Tool (SIGACFG), access Environment/Files/Parameters to configure the following parameters:

Items/Folders

Description

Name

MV_SUBTRIB

Type

Character

Description

Taxpayer's State Registration Number in another State when there is Tax Substitution.

Example of content

PE18154502270978/SC123456789/RJ99999999/

If the MV_SUBTRIB parameter is not sufficient to detail all the State Registration entries of the company, parameters with the name MV_SUBTRI and sequential numeric end must be created to add the remaining entries. Example: MV_SUBTRI2, MV_SUBTRI3, etc.

Items/Folder

Description

Name

MV_STUF

Type

Character

Description

States to be processed in the calculation of the Tax Substitution ICMS outflows only.

Example of content

SP/RJ/MG 

Items/Folder

Description

Name

MV_STUFS

Type

Character

Description

States to be processed in the calculation of the Tax Substitution ICMS outflows only.   

Example of content

SP/RJ/MG

Items/Folder

Description

Name

MV_TRANFST

Type

Character

Description

Indicate the CFOPs that will be used to identify the Transfer Invoices for GIAST processing.

Example of content

5409/6409

Items/Folder

Description

Name

MV_RECST

Type

Character

Description

It indicates each state standard vendor for generating bills payable of the Tax Substitution ICMS.    

Example of content

000001;01

When configuring this parameter, you need to enter the code and store of the default supplier to generate the Tax Substitution bills for each

State, with the following format:

CCCCCC;LL

where:

CCCCCC = supplier code

LL = supplier store

The supplier code and store must be entered with the exact size of the Code (A2_COD) and Store (A2_STORE) fields available in the

system. In the example above, the Code field (A2_COD) is 6 characters long, and the Store field (A2_LOJA) is 2 characters long.

The acronym for each State is shown next to the parameter

Examples: MV_RECSTRJ (standard supplier for the State of Rio de Janeiro), MV_RECSTMG (standard supplier for the state of Minas Gerais), and so on.

When configuring this parameter, ICMS Tax Substitution Payable bills will be generated for States with UF different from the active company in the system.

The parameters for all states in which the payer has State Registration must be created. The bills payable for Tax Substitution will only be generated

for states with the parameter created and valid content, that is, with the supplier existing in the suppliers' file.

Items/Folder

Description

Name

MV_ESTADO

Type

Character

Description

Acronym of the state of the company using the System, to calculate the ICMS (7, 12, or 18%).                         

Example of content

SP

Items/Folder

Description

Name

MV_ICMS

Type

Character

Description

Defines the nature to be used in the automatic generation of the bill with the value of the ICMS calculated in the period by the calculation routine - MATA953.                                                                              

Example of content

ICMS

Enter the code of the nature to be used. If the nature does not exist, it will be automatically registered by the routine.

Items/Folder

Description

Name

MV_APICMST

Type

Character

Description

Defines the nature to be used in the automatic generation of the bill with the value of the ICMS ST calculated in the period by the calculation routine - MATA953.  

Example of content

ICMS ST

Enter the code of the nature to be used. If the nature does not exist, it will be automatically registered by the routine.

Items/Folder

Description

Name

MV_APICMP

Type

Character

Description

Nature of the Complementary ICMS Bill generated through ICMS calculation  

Example of content

ICMCMP

Enter the code of the nature to be used. If the nature does not exist, it will be automatically registered by the routine.

Additional ICMS bills payable will only be generated for states that have legislation to do so.

Items/Folder

Description

Name

MV_PFAPUIC

Type

Character

Description

Bill prefix of accounts payable generated by the ICMS Calculation routine.

Example of content

"ICM"

Items/Folder

Description

Name

MV_UFST

Type

Character

Description

Defines which States will be disregarded for the calculation of ICMS - Tax Substitution according to Decree 27,427

of November 17, 2000 - Section 23 - RJ

Example of content

RJ

Enter, in this parameter, the state of Rio de Janeiro, if the taxpayer is established in RJ and has the need to delete the transactions with its State in the ICMS Accounting Registration - Tax Substitution page of Record P9 and create a Summary of Tax Calculation - Tax Substitution - Internal Operations.

This parameter will only have functionality for the state of Rio de Janeiro and for the issuance of the ICMS Accounting Registration – P9.

Items/Folder

Description

Name

MV_TITAPUR

Type 

Logical

Description

Indicates whether bills payable generated by the calculation of ICMS should be presented on the screen after confirmation of the calculation for maintenance.  

Example of content

.F. or .T.

Items/Folder

Description

Name

MV_CODRSEF 

Type

Character

Content

Define the NF-e Return Code(s) that should be considered in the ICMS Calculation.  

Example of content

'100'

This parameter will have an effect only for SPED, CTE, and NFCE kinds.

The other kinds will be considered in the calculation of ICMS regardless of whether or not the parameter is filled.

If the parameter is not created or is without content, the information considered in the calculation of ICMS for NF-e will be:

  • '' - No return from Sefaz
  • '100' - Authorized use of NF-e

Usage Procedures

In Tax Records (SIGAFIS), go to Miscellaneous/Calculation/ICMS Calculation (MATA953) and set specifically the questions Generate Bills and Generate Collection Form to Yes. Answer the other questions as needed. According to the configuration of the parameters MV_STUF and MV_STUFS, the National Tax Payment Forms are generated by State of the amount related to the Tax Substitution ICMS. If the parameter MV_RECST is set for each State in which the forms were generated, the bills payable will also be saved. The bills payable for the regular ICMS and the complementary ICMS (rate differential) will also be generated. If the parameter MV_TITAPUR exists and is set to .T. (true), when confirming the calculation, the generated bills will be displayed on the screen for possible maintenance.

Example:

We calculated the ICMS for a period in which we obtained the following values to collect:

Regular ICMS: BRL 600.00

Complementary ICMS: BRL 500.00

ICMS - Tax Substitution: BRL 2,250.00

Upon confirmation of the calculation, the National Payment Forms and bills will be generated. Each generated bill (for each tax) will be displayed on the screen for possible maintenance.

Card
defaulttrue
id11
labelLog MThread

Other Actions/MThread Log

In this option, the system displays the Processing Log screen related to the ICMS calculation.

The Warnings and Processing Errors icon are at the bottom.

Click Search tofind specific items, or Details to view other information for the selected item.

Card
labelCalculation using multithread

To speed up the process of booking the Tax Calculation to the ERP Records, this routine distributes the processing using multiple threads that divide the load of the period, considerably reducing the time.

Parameter

Description

Content

MV_RF3THRE

Enables RESUMEF3 processing via Multithread. 

.F. or .T.

MV_RF3THR

Indicate the number of threads to be used when processing the routine. Default 3

Up to 5

MV_RF3MXT

Define the maximum number of threads supported by the routine. Default 5

Up to 5

MV_RF3LOG

Enable or not the saving of the processing log in the Console.log file

.F. or .T.

Card
defaulttrue
id12
labelCaption

Other Actions/Captions

Click this option to display the table for the system captions.

...