Skip to Content
0
Former Member
Sep 09, 2010 at 12:22 PM

Não insere novo documento

47 Views

A base utiliza nf manual por controle especifico, as entredas ocorreram normalmente ate chegar ao nº 500.

Depois disso o sistema me impede de inserir qualquer nota na sequência.

Ao tentar inserir a 500 recebo a mensagem de

Nº de nota fiscal já foi utilizado

Sabendo que o doc não existe tentei inserir um na sequencia e recebi a resposta de

Esta entrada já existe nas tabelas seguintes " (INV1)(ODBC -2035)

Eu realizei essa consulta tentado procurar qualquer doc com o a numeração, mas não encontrei nada.

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM OINV T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM OPCH T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM ORDR T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM ODLN T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM ORDN T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM ODPI T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM ORIN T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM ORDN T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM OPDN T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM ORPD T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM ODPO T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

UNION ALL

SELECT T0.[DocNum], T0.[DocDate], T0.[DocStatus], T0.[Handwrtten], T0.[Series], T0.[Serial]

FROM ORPC T0

where T0.[Docnum] = '500' OR T0.[Serial] = '500'

Alguém já encontrou algo parecido?

Fidelis.