SAP B1 Query manager Opening Wrong Report

[Former Member]

Hi all,

I am facing an issue with Query Manager-->User Queries-->Category 1

When i try to execute a user query from categories, SAP opening a wrong report.

We are using SAP 9.1 PL05.

Please suggest me what might be the issue.

Thanks:

Mohan Reddy

[Former Member]

Hi Mohan,

Can you explain which report you were trying to open and which report is opening ?

Share snapshot to understand better and provide you solution more easily.

Thanks,

Harshal

[Former Member]

Hi Harshal,

Thanks for reply

Actually I try to open change log report for BP Master which is customized

(Query :

Select D.CardCode,D.CardName,D.CardType,D.CreateDate,T0.LogInstanc

,B.U_NAME 'Created By' from OCRD D

            Left Outer join ACRD T0 on D.CardCode =T0.CardCode

            LEFT JOIN [dbo].[OUSR] B ON D.[UserSign]=B.[USERID]

            LEFT JOIN [dbo].[OUSR] C ON D.[UserSign2]=C.[USERID]

            Where T0.UpdateDate is null

            and  D.[CreateDate]  between [%1] and [%2])

But System opens another report called Form-ER 5 Report.

Thanks:

Mohan Reddy

[frank_wang6]

This looks like a data integral problem. I would suggest u to create SAP support ticket on it.

Frank.