Árvore de páginas

01. Visão Geral

O Índice de Participação por Município (IPM) é um controle efetuado pelas Secretarias da Fazenda Estadual (SEFAZ) para identificar o montante de operações realizadas em cada município,
com o propósito de realizar uma melhor distribuição do imposto recolhido para os municípios de seu território. Essas informações são apresentadas no registro 1400 da EFD ICMS/IPI.
Essa funcionalidade permite rastrear quais os valores divididos para cada município e identificar (via relatório) como o sistema chegou nesses valores, trazendo informações dos documentos fiscais e das regras utilizadas.
O objetivo da rotina de apuração é que seja personalizável, permitindo que o cliente consiga configurar e montar as regras de geração do registro 1400 de acordo com sua movimentação.

02. Pré-Condições

2.0 Código de item para IPM ( CLN )

Realize a importação dos códigos de IPM por UF na rotina Tabela de IPM (FISA094)
Tabelas do sistema: Sistema público de escrituração fiscal

  

2.1 Criação do Tributo Genérico 

           Inclua no configurador de tributos o tributo que será utilizado para identificar as operações a serem consideradas na apuração do IPM. No exemplo, utilizamos a nomenclatura IPM

2.2 Criação de Perfis e Regras

Previamente, devemos incluir os perfis de produto, operação, participante e origem/destino, para posterior vínculo à regra de cálculo.
Além disso, é necessário cadastrar as regras de base de cálculo, alíquota, escrituração e apuração.
No cadastro da regra de apuração, serão definidas as operações de crédito e débito.

Após o cadastro de todos os perfis e regras, devemos vincular a Regra de Cálculo - Documentos Fiscais.


 A Regra de Escrituração e Apuração, não são obrigatórias para o cálculo do tributo no documento de entrada/saída porém são obrigatórias para realizar a apuração do IPM.

Para mais informações sobre o configurador de tributo acesse: Configurador de Tributos.

2.2 Cálculo do Tributo IPM

Após realizar os cadastros anteriores, realize a inclusão de um documento de entrada/saída. Deverá ser apresentado na aba Impostos o código da regra de cálculo.

Na aba Tributos Genéricos - Por Item, serão apresentados os itens que tiveram o tributo de IPM.


 As notas que serão consideradas no filtro de apuração devem possuir incidência de ICMS e o imposto criado no Configurador de Tributos.


03. Apuração

3.1 Definição de Regra de Apuração IPM

Através desta rotina é possível cadastrar uma regra de apuração de IPM. No momento da apuração do tributo esta regra será interpretada.



No cadastro deverá ser criado um código, descrição, início e fim de vigência da regra.

Na Aba IPM, deve ser preenchido: 

UF: Informe a UF que deseja utilizar na regra de cálculo do IPM, pode cadastrar mais de uma UF em um único cadastro.   

          IPM: Informe o código da DIPAM que foi importado na rotina (FISA094).

          Descrição: Descrição do código da DIPAM

          Código Regra: Escolha o código de regra que foi cadastrado na Regra de Cálculo - Documentos Fiscais  

          Op. Município:

              1- Município Origem: será usado o parâmetro MV_ESTADO para filtrar a origem nos campos F1_UFORITR, F2_UFORIG e DUY_EST;

              2- Município Destino: será usado o parâmetro MV_ESTADO para filtrar o destino nos campos F1_UFDESTR, F2_UFDEST e DUY_EST;

              3- Município Participante: será usado o parâmetro MV_ESTADO para filtrar os campos A1_EST e A2_EST do participante;

              4- Município Contribuinte: irá extrair todas as notas que tiveram cálculo da regra de IPM, por UF - IPM, e vincular no município do contribuinte - M0_CODMUN;

              5- Rateio: irá extrair toda as notas que tiveram cálculo da regra de IPM e ratear pelos munícipios configurados.
                 Obs.: Caso possua a UF - DIPAM com regras diferentes e em alguma delas possuir rateio, deverá marcar rateio para todas UF - IPM iguais e o rateio será o mesmo para todas.

          Vl. Simbólico: Inclui o valor simbólico de 0,01 quando não houver operações.

Na Aba Rateio, quando selecionado rateio no IPM, deverá preencher os munícipios e os percentuais para cada município, totalizando 100% da distribuição do rateio. 


Se houver rateio localizado para a competência na chave do UF + Código IPM, todos os outros lançamentos da CKE para aquela UF + Código IPM deverão ser do tipo rateio.

3.2 Apuração de IPM

          Acessar o Configurador de tributos (FISA170) \ Regras Fiscais \ Apuração \ Apuração de IPM ( FISA325 ). 

Através desta rotina é possível realizar a apuração de IPM. O valor de débito resultante será utilizado para o envio do bloco 1400 do SPED Fiscal. 

Para iniciar o processo de apuração, clique em Processar e selecione a filial onde a apuração será registrada. Essa filial será considerada a filial centralizadora.

Será iniciado um Wizard para a informações dos parâmetros:

    • Data Inicial: Data inicial do período;
    • Data Final: Data final do período;
    • Seleciona Filiais: apurar movimento de várias filiais para consolidar na centralizadora;
    • Agrupa CPNJ + IE:  apurar movimento de apenas as filiais selecionadas com a mesma CNPJ + IE;
    • Tipo Período: Mensal ou Anual, conforme tipo da tabela CLN.

Marque o tributo genérico IPM e clique em avançar. Será realizada a apuração conforme parâmetros e configuração da regra IPM, após finalização será apresentado o painel para visualização dos dados apurados.

Caso precise processar o mesmo período novamente, será apresentada a mensagem informando que apuração atual será excluída e será gerada uma nova apuração para o período.

3.2 Apuração de IPM em 2º Plano

Caso o ambiente esteja configurado com o SMARTSCHEDULE a apuração ocorrerá em segundo plano.

O campo CKG_CONAPU é responsável por controlar o início e o fim da apuração. Quando iniciada, a apuração recebe o valor 1-Executando, e, ao ser concluída, é atualizada para 2-Finalizado.

Quando a apuração for concluída, caso o usuário possua inscrição no Event Viewer, será enviada uma notificação informando o término do processo.

Importante

O cadastro do usuário no Event Viewer deve ser realizado no grupo "088 - IPM - Índice de Participação de Município". Para mais informações sobre o procedimento de cadastro, consulte a documentação: Event Viewer


3.3 Sped Fiscal

A rotina do Sped Fiscal foi alterada para gerar o registro 1400 conforme a apuração do IPM feita pelo Configurador de Tributos caso exista apuração para o período processado do Sped Fiscal.

Se para o período processado do Sped Fiscal não exista uma apuração de IPM pelo configurador de tributos, o registro 1400 será gerado da forma antiga, através da informação contida no campo Agr. Vlr. Mun. da TES.

04. Relatório

Foi desenvolvida no SmartView uma visão de dados que apresenta, de forma detalhada, as informações utilizadas na apuração.

05. Dicionário de Dados

  • Necessário aplicar o UpdDistr para criar os seguintes metadados:


SIX

INDICEORDEMCHAVEDESCRICAO
CKI1CKI_FILIAL+CKI_IDDETA+CKI_IDUNIQID Det. Apur + ID Único
CKH1CKH_FILIAL+CKH_IDAPUR+CKH_UF+CKH_DIPAM+CKH_CODMUNID Apuracao + UF + Cod. Dipam + Cod. Municip
CKG2CKG_FILIAL+DTOS(CKG_DTINI)+DTOS(CKG_DTFIM)Data Inicial + Data Final
CKG1CKG_FILIAL+CKG_IDID
CKF1CKF_FILIAL+CKF_IDIPM+CKF_UF+CKF_CODIPM+CKF_CODMUNID + UF + IPM + Município
CKE1CKE_FILIAL+CKE_ID+CKE_UF+CKE_CODIPM+CKE_REGCALID + UF + IPM + Código Regra
CKD2CKD_FILIAL+CKD_CODREGCódigo
CKD1CKD_FILIAL+CKD_ID+CKD_CODREGID + Código


SX2

X2_CHAVEX2_ARQUIVOX2_NOMEX2_UNICOX2_MODOX2_MODOUNX2_MODOEMPX2_SYSOBJ
CKICKIT10  Apuração de IPM - Relatório   CKI_FILIAL+CKI_IDDETA+CKI_IDUNIQEEE                                                                                                    
CKHCKHT10  Apuração de IPM - DetalhamentoCKH_FILIAL+CKH_IDAPUR+CKH_UF+CKH_DIPAM+CKH_CODMUNEEEFISA325                                                                                             
CKGCKGT10  Apuração de IPM - Cabecalho   CKG_FILIAL+CKG_IDEEEFISA325                                                                                             
CKFCKFT10  Regra de IPM - Rateio         CKF_FILIAL+CKF_IDIPM+CKF_UF+CKF_CODIPM+CKF_CODMUNEEEFISA322                                                                                             
CKECKET10  Regra de IPM - Cadastro       CKE_FILIAL+CKE_ID+CKE_UF+CKE_CODIPM+CKE_REGCALEEEFISA322                                                                                             
CKDCKDT10  Cab. Regra de IPM             CKD_FILIAL+CKD_ID+CKD_CODREGEEEFISA322                                                                                             


SX3

X3_ARQUIVOX3_ORDEMX3_CAMPOX3_TIPOX3_TAMANHOX3_DECIMALX3_TITULOX3_PICTUREX3_F3X3_BROWSEX3_VISUALX3_CONTEXT
CKI32CKI_CODFORC60Cod. Fornec.@!                                           FOR   SAR
CKI31CKI_CODCLIC60Cod. Cliente@!                                           SA1   SAR
CKI30CKI_FORNECC500Nome Fornec @!                                                 NVR
CKI29CKI_CLIENTC600Nome Cliente@!                                                 NVR
CKI28CKI_VLTRIBN142Vlr. Tributo@E 99,999,999,999.99                               NVR
CKI27CKI_ALIQ  N106Aliq Aplica @E 999.999999                                      NVR
CKI26CKI_BSECALN142Base Calc   @E 99,999,999,999.99                               NVR
CKI25CKI_VLTOT N162Vlr. Total  @E 9,999,999,999,999.99                            SVR
CKI24CKI_VLCONTN142Vlr.Contabil@E 99,999,999,999.99                               NVR
CKI23CKI_MUNDESC600Munic. Dest @!                                                 NVR
CKI22CKI_UFDESTC20UF Destino  @!                                           12NVR
CKI21CKI_MUNORIC600Munic Origem@!                                                 NVR
CKI20CKI_UFORIGC20UF de Origem@!                                           12NVR
CKI19CKI_MUNPARC600Munic Partic@!                                                 NVR
CKI18CKI_UFPARTC20UF Partic   @!                                           12NVR
CKI17CKI_LOJA  C20Loja        @!                                                 NVR
CKI16CKI_UFNOTAC20UF Emi/Des  @!                                           12NVR
CKI15CKI_DTEMISD80DT. Emissao                                                    NVR
CKI14CKI_DTENT D80DT.Ent. Doc                                                    NVR
CKI13CKI_ITEM  C40Item        @!                                                 NVR
CKI12CKI_TPMOV C10Tp.Movimento@!                                                 NVR
CKI11CKI_SERIE C30Serie       !!!                                                NVR
CKI10CKI_NF    C90NF          @!                                                 NVR
CKI9CKI_CODTRIC60Cod. Tributo@!                                                 NAR
CKI8CKI_REGAPUC60Reg/Proc Apu@!                                                 NVR
CKI7CKI_CODMUNC600Cod. Municip@!                                                 NAR
CKI6CKI_FILDOCC80Filial Doc                                                     NAR
CKI5CKI_CODIPMC600Cod. IPM    @!                                                 NVR
CKI4CKI_UFDOC C20UF documento@!                                           12NVR
CKI3CKI_IDUNIQC360ID Único    @!                                                 NAR
CKI2CKI_IDDETAC360ID Det. Apur@!                                                 NVR
CKI1CKI_FILIALC80Filial                                                         NVR
CKH9CKH_DSCDIPC800Descr. Dipam@!                                                 NVV
CKH8CKH_TIPO  C10Tipo        @!                                                 NVR
CKH7CKH_VLRADCN142Vlr. Adic   @E 99,999,999,999.99                               NVR
CKH6CKH_MUNICIC600Município   @!                                                 NVR
CKH5CKH_CODMUNC50Cod. Municip@!                                                 NAR
CKH4CKH_DIPAM C600Cod. Dipam  @!                                                 NVR
CKH3CKH_UF    C20UF          @!                                                 NVR
CKH2CKH_IDAPURC360ID Apuracao @!                                                 NAR
CKH1CKH_FILIALC80Filial                                                         NVR
CKG4CKG_DTFIM D80Data Final                                                     SVR
CKG3CKG_DTINI D80Data Inicial                                                   SVR
CKG2CKG_ID    C360ID          @!                                                 NVR
CKG1CKG_FILIALC80Filial                                                         SVR
CKF7CKF_RATEION52% Rateio    @E 99.99                                           SAR
CKF6CKF_DESCMUC600Descrição   @!                                                 SVR
CKF5CKF_CODMUNC50Município   @!                                           CC2CKFSAR
CKF4CKF_CODIPMC600IPM         @!                                                 SAR
CKF3CKF_UF    C20UF          @!                                           12SAR
CKF2CKF_IDIPM C360ID          @!                                                 SAR
CKF1CKF_FILIALC80Filial                                                         SAR
CKE9CKE_IDF2B C360ID Reg Calc @!                                                 NAR
CKE8CKE_CONVLSC10Vl Simbólico@!                                                 SAR
CKE7CKE_CONSMUC10Op.Município@!                                                 SAR
CKE6CKE_REGCALC60Código Regra@!                                           F2B3  SAR
CKE5CKE_DSCIPMC600Decrição    @!                                                 SVR
CKE4CKE_CODIPMC600IPM         @!                                           CLNCKESAR
CKE3CKE_UF    C20UF          @!                                           12SAR
CKE2CKE_ID    C360ID          @!                                                 SAR
CKE1CKE_FILIALC80Filial                                                         SVR
CKD6CKD_VIGFIMD80Data Final                                                     SAR
CKD5CKD_VIGINID80Data Início                                                    SAR
CKD4CKD_DESCR C500Descrição   @!                                                 SAR
CKD3CKD_CODREGC60Código      @!                                                 SAR
CKD2CKD_ID    C360ID          @!                                                 NVR
CKD1CKD_FILIALC80Filial                                                         SVR


SX7

X7_CAMPOX7_SEQUENCX7_REGRAX7_CDOMINX7_TIPOX7_SEEKX7_ALIASX7_ORDEMX7_CHAVEX7_PROPRI
CKF_CODMUN1Fisa322CC2(FwFldGet("CKE_UF"),FwFldGet("CKF_CODMUN"))                                                                                                                                                   CKF_DESCMUXN   0                                                                                                                                                                                                        S
CKE_REGCAL1F2B->F2B_ID                                                                                                                                                                                             CKE_IDF2B PN   0                                                                                                                                                                                                        S
CKE_CODIPM1SUBSTR(CLN->CLN_DSCIPM,1,60)                                                                                                                                                                            CKE_DSCIPMPSCLN1XFILIAL("CLN")+FwFldGet("CKE_UF")+FwFldGet("CKE_CODIPM")                                                                                                                                                S


SX9

X9_DOMX9_IDENTX9_CDOMX9_EXPDOMX9_EXPCDOMX9_PROPRIX9_LIGDOMX9_LIGCDOMX9_CONDSQLX9_USEFILX9_ENABLEX9_VINFILX9_CHVFOR
SX58CKEX5_TABELA+X5_CHAVE'12'+CKE_UF                                                                                                                                                                                                                                               S1N                                                                                                                                                                                                                                                          SS22
SX57CKIX5_TABELA+X5_CHAVE'12'+CKI_UFDEST                                                                                                                                                                                                                                           S1N                                                                                                                                                                                                                                                          SS22
SX56CKIX5_TABELA+X5_CHAVE'12'+CKI_UFORIG                                                                                                                                                                                                                                           S1N                                                                                                                                                                                                                                                          SS22
SX55CKIX5_TABELA+X5_CHAVE'12'+CKI_UFPART                                                                                                                                                                                                                                           S1N                                                                                                                                                                                                                                                          SS22
SX54CKIX5_TABELA+X5_CHAVE'12'+CKI_UFNOTA                                                                                                                                                                                                                                           S1N                                                                                                                                                                                                                                                          SS22
SX53CKIX5_TABELA+X5_CHAVE'12'+CKI_UFDOC                                                                                                                                                                                                                                            S1N                                                                                                                                                                                                                                                          SS22
SX52CKHX5_TABELA+X5_CHAVE'12'+CKH_UF                                                                                                                                                                                                                                               S1N                                                                                                                                                                                                                                                          SS22
SX51CKFX5_TABELA+X5_CHAVE'12'+CKF_UF                                                                                                                                                                                                                                               S1N                                                                                                                                                                                                                                                          SS22
SA21CKIA2_COD+A2_LOJACKI_CODFOR+CKI_LOJA                                                                                                                                                                                                                                       S1N                                                                                                                                                                                                                                                          SS22
SA11CKIA1_COD+A1_LOJACKI_CODCLI+CKI_LOJA                                                                                                                                                                                                                                       S1N                                                                                                                                                                                                                                                          SS22
F2B1CKEF2B_REGRACKE_REGCAL                                                                                                                                                                                                                                                S1N                                                                                                                                                                                                                                                          SS22
CLN1CKECLN_UF+CLN_CODIPMCKE_UF+CKE_CODIPM                                                                                                                                                                                                                                         S1N                                                                                                                                                                                                                                                          SS22
CKG1CKHCKG_IDCKH_IDAPUR                                                                                                                                                                                                                                                S1N                                                                                                                                                                                                                                                          SS11
CKE1CKFCKE_ID+CKE_UF+CKE_CODIPMCKF_IDIPM+CKF_UF+CKF_CODIPM                                                                                                                                                                                                                               S1N                                                                                                                                                                                                                                                          SS11
CKD1CKECKD_IDCKE_ID                                                                                                                                                                                                                                                    S1N                                                                                                                                                                                                                                                          SS11
CC22CKHCC2_CODMUNCKH_CODMUN                                                                                                                                                                                                                                                S1N                                                                                                                                                                                                                                                          SS22
CC21CKFCC2_CODMUNCKF_CODMUN                                                                                                                                                                                                                                                S1N                                                                                                                                                                                                                                                          SS22


SXB

XB_ALIASXB_TIPOXB_SEQXB_COLUNAXB_DESCRIXB_DESCSPAXB_DESCENGXB_CONTEM
CLNCKE61                                                              CLN->CLN_UF==FwFldGet("CKE_UF")                                                                                                                                                                                                                           
CLNCKE51                                                              CLN_CODIPM                                                                                                                                                                                                                                                
CLNCKE414Descrição           Descripción         Description         CLN_DSCIPM                                                                                                                                                                                                                                                
CLNCKE413Código IPM          Código IPM          IPM Code            CLN_CODIPM                                                                                                                                                                                                                                                
CLNCKE412Dt Final            Fch. Final          End Date            CLN_DTFIMV                                                                                                                                                                                                                                                
CLNCKE411Dt Início           Fch. Inicial        Start Date          CLN_DTINIV                                                                                                                                                                                                                                                
CLNCKE211Filial+estado+codigoSuc+E/P/R+Código    Branch+State+Code                                                                                                                                                                                                                                                             
CLNCKE11DBInd.Partic.Munic.   Ind.Partic.Munic.   City Partic. Ind.   CLN                                                                                                                                                                                                                                                       
CC2CKF61                                                              CC2->CC2_EST==FwFldGet("CKE_UF")                                                                                                                                                                                                                          
CC2CKF51                                                              CC2_CODMUN                                                                                                                                                                                                                                                
CC2CKF426Municipio           Municipio           City                CC2_MUN                                                                                                                                                                                                                                                   
CC2CKF425Cod. IBGE           Cód. IBGE           IBGE Code           CC2_CODMUN                                                                                                                                                                                                                                                
CC2CKF424Estado              Est/Prov/Reg        State               CC2_EST                                                                                                                                                                                                                                                   
CC2CKF413Municipio           Municipio           City                CC2_MUN                                                                                                                                                                                                                                                   
CC2CKF412Cod. IBGE           Cód. IBGE           IBGE Code           CC2_CODMUN                                                                                                                                                                                                                                                
CC2CKF411Estado              Est/Prov/Reg        State               CC2_EST                                                                                                                                                                                                                                                   
CC2CKF222Codigo Ibge         Código IBGE         IBGE Code                                                                                                                                                                                                                                                                     
CC2CKF211Municipio           Municipio           City                                                                                                                                                                                                                                                                          
CC2CKF11DBMunicipio Rateio    Municipio Prorrateo Apportionment City  CC2                                                                                                                                                                                                                                                       


06. Demais Informações

Implementação cadastro Código IPM

Implementação da tela de apuração

Implementação do relatório SmartView (IPM)