Can't insert new a/r invoce

[Former Member]

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.

[Former Member · Accepted solution]

Fidelis,

You don't need to query other tables for A/R Invoice. It is because your document header and row not match. Your INV1 table has more record without header. This can be proved by a query:

SELECT DOCENTRY FROM INV1 T0

WHERE T0.DOCENTRY NOT IN (SELECT DOCENTRY FROM OINV)

If you have any results, you have to log a message for SAP support to fix your database.

Thanks,

Gordon

[Former Member]

Thanks, I run the query and return one doc. I don't find any notes about this problem

I will open a support on the portal SAP.

Again, thanks for the help

[marcella_rivi]

Dear Mr Fidelis,

If the issue suggested by the other person is correct I would recommend to open a message because possibly the database must be correct.

Please, before doing so, check for notes on the portal.

Regards,

Marcella Rivi

SAP Business One Forums Team