ERRO SPED FISCAL "NAO SE APLICA" C490 - O REGISTRO FILHO C490 E OBRIGATORIO SEMPRE QUE HOUVER DOC FISCAL NAO CANCELADO. select sum(A.qtdxunit-A.desconto-A.desconto_item+A.acrescimo) as VL_OPR,B.CSTECF as CST_ICMS, B.CFOPECF AS CFOP,B.ALIQUOTA AS ALIQ_ICMS from MOVDIARIO A INNER join ALIQUOTAS B on B.POSICAO=A.ALIQUOTA where A.empresa=:CodigoDaEmpresa and A.tipo='V' and (A.situacao is null or A.situacao='' or A.situacao=' ') and A.caixa=:NumeroDoCaixa and A.emissao between (:DataInicial) and (:DataFinal) group by B.CSTECF,B.CFOPECF,B.ALIQUOTA ;