Problem With Approval Documents

[Former Member]

Hi All,

I am having a little problem with two documents that have been approved. I have a query that picks up open documents that have already been approved. I am getting two entries in my query and when I open one which is a AP Credit Memo it says in brackets at the top approved and when I try and add it I am getting this error. "This document was already added after it was approved"

Could somebody please tell me what is going on and how I will be able to solve this problem.

We are running SAP Business One PL 30.

Thanks

Quinn

[Former Member]

The where clause should be T0.[WddStatus\] NOT IN ('W','Y')

Thanks,

Gordon

[Former Member]

Yes, it seems like the document has been added already. Are you sure the query is correct? Can you paste it here?

[former_member187989]

What is ur approval process ?

Post ur query here.

[Former Member]

Here is the query that is being used.

SELECT T0.[DocNum] AS Doc, T0.[DocType] AS Type, T0.[DocStatus] AS Status, T0.[DocDate], DATEDIFF(Day, CURRENT_TIMESTAMP, DocDate) AS Overdue, T0.[UserSign] AS 'User', T0.[WddStatus] AS 'Auth. Status' FROM [dbo].[ODRF]  T0 WHERE T0.[DocStatus] = 'O' AND DATEDIFF(Day, CURRENT_TIMESTAMP, DocDate) < 0 AND  T0.[WddStatus] IN ('W','Y')
ORDER BY DATEDIFF(Day, CURRENT_TIMESTAMP, DocDate)

The approval only needs to be approved by one person and he has done so but there is still this problem.

[Former Member]

It seems the document is a approved order that already exists.