Perguntas Erro ao gerar Bloco K no Sped Fiscal

Mais
9 anos 2 meses atrás #29387 por clistenis
Boa tarde amigo, alguém já passou por este erro ao tentar gerar o sped com bloco K ?

Dá um erro de SQL, achei estranho.

Obrigado caso alguém tenha um dica.




THREAD ERROR (clistenis, GNX-DTI-1) 05/10/2015 14:44:37
: Error : 1722 - ORA-01722: invalid number
( From tOracleConnection::GetQueryFile )
Thread ID [2621503248] User [Administrador] IO [316333] Tables [88] MaxTables [88] Comment [SPEDFISCAL - TCPIP] Status [] SP [ ] Traced [No] InTran [No] DBEnv [ORACLE/sigaofc] DBThread [(SID 492,891)] Started [05/10/2015 14:20:27] LastIO [] IP [192.168.32.6:2424] RCV [37955867] SND [307732276] TCBuild [20141119]
SELECT SUM(SD3.D3_QUANT) AS QUANT,SD3.D3_OP,SD3.D3_COD,SD3.D3_FILIAL,SB1.B1_TIPO,SC2.C2_DATPRI AS DTINI,SC2.C2_DATRF AS DTFIM FROM SD3010 SD3 JOIN SB1010 SB1 ON SB1.B1_FILIAL = '0101' AND SB1.B1_COD = SD3.D3_COD AND SB1.D_E_L_E_T_ = ' ' JOIN SC2010 SC2 ON SD3.D3_OP = SC2.C2_NUM+SC2.C2_ITEM+SC2.C2_SEQUEN AND SC2.C2_FILIAL = '0101' AND SC2.D_E_L_E_T_ = ' ' WHERE SD3.D3_FILIAL = '0101' AND SD3.D_E_L_E_T_ = ' ' AND SD3.D3_ESTORNO = ' ' AND SD3.D3_OP <> ' ' AND SD3.D3_CF IN ('PR0','PR1') AND SUBSTR (SD3.D3_COD,1,3) <> 'MOD' AND SD3.D3_EMISSAO >= '20150901' AND SD3.D3_EMISSAO <= '20150930' AND SB1.B1_TIPO IN ('PP','PA') AND SD3.D_E_L_E_T_ = ' ' GROUP BY SD3.D3_OP, SD3.D3_COD, SD3.D3_FILIAL, SB1.B1_TIPO, SC2.C2_DATPRI, SC2.C2_DATRF on REGK230(MATXSPED.PRW) 02/10/2014 13:27:20 line : 557

[TOTVS build: 7.00.131227A-20150327]
Called from SPDBLOCOK(MATXSPED.PRW) 02/10/2014 13:27:20 line : 65
Called from BLOCOK(SPEDXFUN.PRW) 29/04/2015 15:36:10 line : 13522
Called from PRSPED(SPEDFISCAL.PRW) 05/05/2015 14:16:34 line : 3512
Called from {|LEND| PRSPED(@LEND,@CFILEDEST,CPERFIL,@OPROCESS,LTABCOMP,LTABCDT,LTABCD0,LTABCE5,LINTTMS,AWIZSCREEN,LTABCD1)}(SPEDFISCAL.PRW) 05/05/2015 14:16:34 line : 132
Called from eval line : 227
Called from {|SELF|(EVAL(BBLOCK),EVAL({||OBNTCAN:HIDE(),OBNTFIN:SHOW()}))}(FISXCLASS.PRW) 06/05/2013 09:09:46 line : 227
Called from ::MSDIALOG:ACTIVATE
Called from FISPROGRESS:ACTIVATE(FISXCLASS.PRW) 06/05/2013 09:09:46 line : 227
Called from SPEDFISCAL(SPEDFISCAL.PRW) 05/05/2015 14:16:34 line : 133
Called from __EXECUTE(APLIB090.PRW) 30/07/2015 11:33:26 line : 581
Called from FWPREEXECUTE(FWPREEXECUTE.PRW) 16/02/2015 00:06:32 line : 82
Called from {||FWPREEXECUTE('SPED FISCAL', 'SPEDFISCAL()', 1, '09', 'XXXXXXXXXX') } line : 353
Called from ::TWINDOW:ACTIVATE
Called from MSAPP:ACTIVATE(FWAPP.PRW) 20/08/2015 16:07:52 line : 621
Called from SIGAADV(APLIB000.PRW) 18/03/2015 18:17:30 line : 54

Por favor Acessar ou Registrar para participar da conversa.

Mais
5 anos 2 meses atrás #32763 por JamesWesTRP
Amigo,

Conseguiu resolver este caso ?

Se sim, como ? Estou com o mesmo problema...

Por favor Acessar ou Registrar para participar da conversa.

Tempo para a criação da página:0.083 segundos
Joomla templates by a4joomla