Skip to Content

0

Former Member

Sep 09, 2010 at 12:48 PM

Can't insert new a/r invoce

72 Views

I use manual sequence for my invoice, company rules.

After I insert the 499, all docs stop and I have this mesage

When I try insert 500 I get

This entrry already exists in the follow tables " (INV1)(ODBC -2035) [Mensagem 131-183]

Knowing that doc doesn't exists, I made a query searching for any doc with that number.

But I don't find notting.

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'

Someaone saw some like this before?

Fidelis.