Wiki

APP

None Defined

Sorts keep changing in Advanced Delivery

When checked and resorted and then unchecked original sort does not come back

SQL issue. It can not handle the view

The Advanced Delivery Additional Query Filter results are returned in a certain order. When we deselect all rows the report re-sorts, then when all rows are reselected it re-sorts again but not to the original sort. This continues. It was discovered because we were testing 1 statement and when we printed the statement for the BP selected the report output was an an entirely different BP`s data/account balance.

View (acStatementsQuery)… SELECT dbo.OCRD.CardCode, dbo.OCRD.CardName, dbo.OCPR.CntctCode, dbo.OCPR.Name, dbo.OCPR.E_MailL FROM dbo.OCRD INNER JOIN dbo.OCPR ON dbo.OCRD.CardCode = dbo.OCPR.CardCode WHERE (dbo.OCPR.U_TWBS_CWCnType = `MBT`) AND (dbo.OCRD.QryGroup15 = `Y`)

Query… SELECT * FROM acStatementsQuery

There are two ways to fix this. One is apply a SQL hotfix as described in http://support.microsoft.com/kb/926292

The second way to resolve this it to take it out of a view in sql and apply the query directly into SAP.

Solution

05 Nov 2013