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.